UPDATE!!!

Now I get the following error

/tmp/sqoop-cyril/compile/b156fd4f270274b11320d007472bbfe7/kmeansclusterIds.java:73: cannot find symbol
symbol  : variable driver_license
location: class kmeansclusterIds
    JdbcWritableBridge.writeString(driver_license, 2 + __off, 12, __dbStmt);
                                   ^
Note: /tmp/sqoop-cyrille/compile/b156fd4f270274b11320d007472bbfe7/kmeansclusterIds.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
1 error
13/04/26 12:52:26 ERROR tool.ExportTool: Encountered IOException running export job: java.io.IOException: Error returned by javac




On Fri, Apr 26, 2013 at 12:52 PM, Cyril Bogus <cyrilbogus@gmail.com> 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.