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

最新推荐文章于 2024-06-25 14:47:55 发布

开飞机的舒克贝塔

最新推荐文章于 2024-06-25 14:47:55 发布

阅读量6.9k

点赞数

分类专栏： Hive

本文链接：https://blog.csdn.net/u012630060/article/details/68483714

版权

在使用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