Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Unable to import tables from sqoop


+
iwannaplay games 2012-07-25, 06:12
Copy link to this message
-
Re: Unable to import tables from sqoop
Hi Prabhjot,

This is a known incompatibility issue between MS connector and Sqoop 1.4.1.
In shorts, the problem is that MS connector is compiled against Sqoop 1.3.x
while you're using it against 1.4.1 at runtime. This issue is resolved by
SQOOP-480 <https://issues.apache.org/jira/browse/SQOOP-480>, but the fix is
not in Sqoop 1.4.1.

There are two options that you can choose from:
1) Wait for the 1.4.2 release - This is coming soon.
2) Download the source tarball, apply the patch, and rebuild the Sqoop jar
by yourself.

#2 may not sound friendly, but it's not too hard. Regarding how to build
Sqoop, you can refer to this wiki page:
https://cwiki.apache.org/confluence/display/SQOOP/Setting+up+Development+Environment

Thanks,
Cheolsoo

On Tue, Jul 24, 2012 at 11:12 PM, iwannaplay games <
[EMAIL PROTECTED]> wrote:

> Hi,
>
> I am using sqoop 1.4.1 and after succesfully installing and adding sql
> server connector i am able to get the list of databases from a server
> but am not able to import tables.
>
> Please see
> [hduser@master bin]$ sqoop import-all-tables --connect
> 'jdbc:sqlserver://<IP>;username=dev;password=d3v;database=Content'
>
> Warning: $HADOOP_HOME is deprecated.
>
> 12/07/25 16:52:40 INFO SqlServer.MSSQLServerManagerFactory: Using
> Microsoft's SQL Server - Hadoop Connector
> 12/07/25 16:52:40 INFO manager.SqlManager: Using default fetchSize of 1000
> 12/07/25 16:52:46 INFO tool.CodeGenTool: Beginning code generation
> 12/07/25 16:52:46 INFO manager.SqlManager: Executing SQL statement:
> SELECT TOP 1 * FROM [Batting]
> 12/07/25 16:52:47 INFO manager.SqlManager: Executing SQL statement:
> SELECT TOP 1 * FROM [Batting]
> 12/07/25 16:52:48 INFO orm.CompilationManager: HADOOP_HOME is
> /usr/local/hadoop/libexec/..
> Note:
> /tmp/sqoop-hduser/compile/e80807623f377f6d06f789e49d370a6c/Batting.java
> uses or overrides a deprecated API.
> Note: Recompile with -Xlint:deprecation for details.
> 12/07/25 16:52:48 INFO orm.CompilationManager: Writing jar file:
> /tmp/sqoop-hduser/compile/e80807623f377f6d06f789e49d370a6c/Batting.jar
> Exception in thread "main" java.lang.NoSuchMethodError:
>
> com.cloudera.sqoop.manager.ImportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V
>         at
> com.microsoft.sqoop.SqlServer.MSSQLServerManager.importTable(MSSQLServerManager.java:142)
>         at
> org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:380)
>         at
> org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:64)
>         at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
>         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
>         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
>         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
>         at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
>         at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
>
> Anybody knows the solution
>
> Regards
> Prabhjot
>
+
iwannaplay games 2012-07-25, 07:19
+
Chalcy 2012-07-25, 10:44
+
Chalcy 2012-07-25, 12:53
+
Chalcy 2012-08-06, 19:06
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB