首页 文章

oracle DB的Sqoop导入失败,Null指针,sqoop eval工作正常

提问于
浏览
0

我们能够成功运行sqoop eval,但是sqoop导入失败并且Null指针异常

sqoop import --driver oracle.jdbc.OracleDriver --connect "jdbc:oracle:thin:@//*.*.*.*:1521/dbname" 
--username **** -P --query "select * from Tablename WHERE \$CONDITIONS" --target-dir '/tmp/newdata' -m 1

esult $ FieldSetterCommand.class 17/09/13 14点56分十二秒DEBUG orm.CompilationManager:GOT类文件:/tmp/sqoop-ngupta/compile/55c0833a52d3ac5cca4948ef7201cb3a/QueryResult.class - > QueryResult.class 17/09/13 14: 56:12 DEBUG orm.CompilationManager:完成编写jar文件/tmp/sqoop-ngupta/compile/55c0833a52d3ac5cca4948ef7201cb3a/QueryResult.jar 17/09/13 14:56:12 INFO mapreduce.ImportJobBase:开始查询导入 . 17/09/13 14:56:12 DEBUG util.ClassLoaderStack:检查现有类:QueryResult 17/09/13 14:56:12 DEBUG util.ClassLoaderStack:尝试通过URL加载jar:jar:file:/ tmp / sqoop-ngupta /编译/ 55c0833a52d3ac5cca4948ef7201cb3a / QueryResult.jar / 17/09/13 14点56分12秒DEBUG util.ClassLoaderStack:以前的类加载器是sun.misc.Launcher$AppClassLoader@46c9220 17/09/13 14点56分12秒DEBUG util.ClassLoaderStack: jar 中测试类:QueryResult中17/09/13 14点56分12秒DEBUG util.ClassLoaderStack:加载 jar 到当前JVM中:jar:文件:/tmp/sqoop-ngupta/compile/55c0833a52d3ac5cca4948ef7201cb3a/QueryResult.jar !/ 17/09/13十四时56分12秒DEBUG util.ClassLoaderStack:java.net.FactoryURLClassLoader@10c77fcc 17/09/13 14:增加了对 jar /tmp/sqoop-ngupta/compile/55c0833a52d3ac5cca4948ef7201cb3a/QueryResult.jar类加载器: 56:12错误sqoop.Sqoop:在org.apache.sqoop.util.S的org.json.JSONObject . (JSONObject.java:144)运行Sqoop:java.lang.NullPointerException java.lang.NullPointerException异常qoopJsonUtil.getJsonStringforMap(SqoopJsonUtil.java:43)在org.apache.sqoop.SqoopOptions.writeProperties(SqoopOptions.java:780)在org.apache.sqoop.mapreduce.JobBase.putSqoopOptionsToConfiguration(JobBase.java:392)在org.apache位于org.apache.sqoop.manager.SqlManager.importQuery(SqlManager.java)的org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:256)中的.sqoop.mapreduce.JobBase.createJob(JobBase.java:378) :748)org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:514)位于org.apache.sqoop.Sqoop的org.apache.sqoop.tool.ImportTool.run(ImportTool.java:620) . 运行(Sqoop.java:147)org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)atg.apache.sqoop .sqoop.runTool(Sqoop.java:234)org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)org.apache.sqoop.Sqoop.main(Sqoop.java:252)

Sqoop eval运行良好 .

$ sqoop eval --driver oracle.jdbc.OracleDriver --connect "jdbc:oracle:thin:@//*.*.*.*:1521/dbname" --username *** -P --query "select * from tableName"

1 回答

  • 0

    从命令中删除 --driver oracle.jdbc.OracleDriver .

相关问题