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

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


Thank you for the reply earier again.
You were right but, I updated my sqoop to 1.4.3 and made some changes to my
export query,
I have now the following error.

Exception in thread "main" java.lang.NoClassDefFoundError:
com/cloudera/sqoop/mapreduce/UpdateOutputFormat$UpdateRecordWriter
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClass(ClassLoader.java:634)
    at
java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
    at java.net.URLClassLoader.defineClass(URLClassLoader.java:277)
    at java.net.URLClassLoader.access$000(URLClassLoader.java:73)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:212)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:266)
    at
org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:820)
    at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:865)
    at
org.apache.hadoop.mapreduce.JobContext.getOutputFormatClass(JobContext.java:235)
    at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:884)
    at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:416)
    at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1121)
    at
org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:850)
    at org.apache.hadoop.mapreduce.Job.submit(Job.java:500)
    at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:530)
    at
org.apache.sqoop.mapreduce.ExportJobBase.doSubmitJob(ExportJobBase.java:288)
    at
org.apache.sqoop.mapreduce.ExportJobBase.runJob(ExportJobBase.java:265)
    at
org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:375)
    at
com.microsoft.sqoop.SqlServer.MSSQLServerManager.updateTable(MSSQLServerManager.java:165)
    at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:71)
    at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:100)
    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)
Caused by: java.lang.ClassNotFoundException:
com.cloudera.sqoop.mapreduce.UpdateOutputFormat$UpdateRecordWriter
    at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
    ... 36 more
Apparently it is now looking for a class that do not exist. I checked the
source and indeed UpdateRecordWrite does not exist
On Fri, Apr 26, 2013 at 1:52 PM, Cyril Bogus <[EMAIL PROTECTED]> wrote:

> Here is the sqoop log
>
> 13/04/26 13:36:46 WARN tool.SqoopTool: $SQOOP_CONF_DIR has not been set in
> the environment. Cannot check for additional configuration.
> 13/04/26 13:36:46 WARN sqoop.ConnFactory: $SQOOP_CONF_DIR has not been set
> in the environment. Cannot check for additional configuration.
> 13/04/26 13:36:46 INFO manager.SqlManager: Using default fetchSize of 1000
> 13/04/26 13:36:46 INFO tool.CodeGenTool: Beginning code generation
> 13/04/26 13:36:46 INFO manager.SqlManager: Executing SQL statement: SELECT