Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Cyril Bogus 2013-04-26, 16:52
+
Jarek Jarcec Cecho 2013-04-26, 17:37
+
Cyril Bogus 2013-04-26, 16:53
Hi Cyril,
would you mind sharing entire Sqoop log and the generated java class?

Jarcec

On Fri, Apr 26, 2013 at 12:53:49PM -0400, Cyril Bogus wrote:
> 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.
> >
+
Cyril Bogus 2013-04-26, 17:52
+
Cyril Bogus 2013-04-26, 18:57
+
Jarek Jarcec Cecho 2013-04-26, 19:05
+
Cyril Bogus 2013-04-26, 19:21
+
Jarek Jarcec Cecho 2013-04-28, 15:03
+
Cyril Bogus 2013-05-02, 16:43
+
Jarek Jarcec Cecho 2013-05-03, 04:00
+
Venkat Ranganathan 2013-05-04, 18:25
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB