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

Switch to Threaded View
Sqoop, mail # user - Export


Copy link to this message
-
Export
Cyril Bogus 2013-04-26, 16:52
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.