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

在使用Sqoop从Oracle数据库向Hive迁移数据时遇到异常:running import job: java.io.IOException: Hive exited with status 1。解决这个问题的方法是在HIVE_HOME的lib目录下找到libthrift-0.9.2.jar,并将其复制到SQOOP_HOME的lib目录下,从而成功解决导入错误。
摘要由CSDN通过智能技术生成
[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
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值