sqoop从Oracle导表到hive报错
0
CDH:5.7
ORACLE 11gR2
从Oracle倒数据到hive之前进行测试,失败信息如下:
sqoop list-tables --connect jdbc:oracle:thin:@IP:1521:orcl --username XXXX --password XXX
16/05/27 19:42:17 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
16/05/27 19:42:17 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
16/05/27 19:42:17 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
16/05/27 19:42:17 INFO manager.SqlManager: Using default fetchSize of 1000
16/05/27 19:42:52 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.manager.OracleManager.listTables(OracleManager.java:759)
at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
ORACLE 11gR2
从Oracle倒数据到hive之前进行测试,失败信息如下:
sqoop list-tables --connect jdbc:oracle:thin:@IP:1521:orcl --username XXXX --password XXX
16/05/27 19:42:17 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
16/05/27 19:42:17 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
16/05/27 19:42:17 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
16/05/27 19:42:17 INFO manager.SqlManager: Using default fetchSize of 1000
16/05/27 19:42:52 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.manager.OracleManager.listTables(OracleManager.java:759)
at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
3 个回复
牟瑞 - 大数据 Hadoop 讲师 Hadoop入门课程地址:http://www.hellobi.com/course/39 有架构师,技术总监,CTO的职位请联系我! 2016-05-30 回答
赞同来自:
如果还不行,降低一下sqoop的版本再试一下。
MarsJ - 大数据玩家~DS 2016-05-31 回答
赞同来自:
另外,在$SQOOP_HOME/lib/下你是否有添加Oracle相应版本的ODBC.jar包?
gaoyingchang 2017-01-10 回答
赞同来自: