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
-
Re: Export
Cyril Bogus 2013-04-26, 16:53
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 <[EMAIL PROTECTED]> 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.
>