Sqoop将Oracle数据导入Hive时出现异常 running import job: java.io.IOException: Hive exited with status 1

[root@node2 sqoop-1.4.6]# sqoop import --connect jdbc:oracle:thin:@192.168.8.110:1521:orcl --username SKY --password 123456 --table GJJY20150613 -m 8 --hive-import
Warning: /home/sqoop-1.4.6//../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /home/sqoop-1.4.6//../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
Warning: /home/sqoop-1.4.6//../zookeeper does not exist! Accumulo imports will fail.
Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.
17/03/30 09:29:25 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
17/03/30 09:29:25 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/03/30 09:29:25 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
17/03/30 09:29:25 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
17/03/30 09:29:25 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
17/03/30 09:29:25 INFO manager.SqlManager: Using default fetchSize of 1000
17/03/30 09:29:25 INFO tool.CodeGenTool: Beginning code generation
17/03/30 09:29:33 INFO manager.OracleManager: Time zone has been set to GMT
17/03/30 09:29:33 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM GJJY20150613 t WHERE 1=0
17/03/30 09:29:33 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /home/hadoop-2.5.1
Note: /tmp/sqoop-root/compile/99be5bfaadbeef110d46ecba09bf90e8/GJJY20150613.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
17/03/30 09:29:36 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/99be5bfaadbeef110d46ecba09bf90e8/GJJY20150613.jar
17/03/30 09:29:36 INFO manager.OracleManager: Time zone has been set to GMT
17/03/30 09:29:36 INFO manager.OracleManager: Time zone has been set to GMT
17/03/30 09:29:36 INFO mapreduce.ImportJobBase: Beginning import of GJJY20150613
17/03/30 09:29:36 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar
17/03/30 09:29:3
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值