Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Export


Hi Cyril,
what Sqoop version are you running on? I think that this issue was resolved in 1.4.3 by SQOOP-818.

Jarcec

On Fri, Apr 26, 2013 at 12:52:40PM -0400, Cyril Bogus wrote:
> Hi everyone,
>
> I am trying to do an export from HDFS to MSSQL using Sqoop
>
> my data is in the following format
>
> JTDKN3DU0B0261494,345
> JTEBU14R840022700,340
> JTEEP21A770208029,314
> JTHBF5C24A5125359,348
> jthbk1eg6a2395028,341
> JTMBD31V565007305,355
> KL1PM5C5XAK700838,352
> KMHCG45C41U225885,352
> KMHDC86EX9U037746,304
> NM0LS6BN8CT123712,354
>
> my export statement is the following
>
> export
> --connect
> 'jdbc:sqlserver://server:port;username=sa;password=pass;database=db'
> --table
> kmeansclusterIds
> --update-key
> driver_license
> --columns
> clusterId
> --update-mode
> allowinsert
> --export-dir
> drivers/output.txt
> --fields-terminated-by
> ','
> --lines-terminated-by
> \n
>
> I created a table named kmeansclusterIds on the server.
> I get the following error:
>
> Exception in thread "main" java.lang.NoSuchMethodError:
> com.cloudera.sqoop.manager.ExportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V
>     at
> com.microsoft.sqoop.SqlServer.MSSQLServerManager.exportTable(MSSQLServerManager.java:151)
>     at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:78)
>     at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:97)
>     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)
>
> Any insight in what the real issue might be?
>
> Thank you in advance for a reply.