Hi Prabhjot, sqoop 1.4.1 has a bug sqoop-480 and fixed on sqoop1.4.2 I am trying out cdh4 and found this yesterday. Looks like have to build sqoop1.4.2 from snapshot.
I did the same thing like you, could list databases and list tables, but could not import data. https://issues.apache.org/jira/browse/SQOOP-480 --Chalcy On Wed, Jul 25, 2012 at 2:12 AM, 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 >
