Hi,

I’d like to export MR result (text) files from HDFS to MySQL. My cluster is
running Hadoop 2.4.0.

When I’m running 
./sqoop export –connect jdbc:mysql://mysqlserver/sqoop –username user
–password pass –table test1 –export-dir /output
I get the below exception. I assume, sqoop is using the old MR API? Can I
change this somehow to use the new API, then I'd be able to point
$HADOOP_MAPRED_HOME to the right position?!

14/06/13 13:06:44 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
14/06/13 13:06:44 INFO manager.MySQLManager: Preparing to use a MySQL
streaming resultset.
14/06/13 13:06:44 INFO tool.CodeGenTool: Beginning code generation
14/06/13 13:06:50 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `test1` AS t LIMIT 1
14/06/13 13:06:50 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `test1` AS t LIMIT 1
14/06/13 13:06:50 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is
/opt/hadoop-2.4.0/share/hadoop/yarn
Exception in thread "main" java.lang.NoClassDefFoundError:
org/apache/hadoop/mapred/JobConf
        at
org.apache.sqoop.orm.CompilationManager.findHadoopCoreJar(CompilationManager
.java:109)
        at
org.apache.sqoop.orm.CompilationManager.compile(CompilationManager.java:137)
        at
org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:97)
        at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:64)
        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:70)
        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)

Thanks very much!
Sebastian


Reply via email to