sqoop执行hive导入报错

最新推荐文章于 2023-09-27 11:03:34 发布

源神

最新推荐文章于 2023-09-27 11:03:34 发布

阅读量825

点赞数

分类专栏： Sqoop

本文链接：https://blog.csdn.net/ZhouyuanLinli/article/details/82744533

版权

这篇博客介绍了如何处理Sqoop在执行Hive数据导入时遇到的错误。关键在于，当表位于不同数据库时，需要在LOAD DATA命令中指定完整的数据库.表名路径。

摘要由CSDN通过智能技术生成

错误日志：

2018-09-17 14:50:57,932 INFO [OutputFormatLoader-consumer] com.chinacreator.sqoop.connector.hive.HiveLoader: load sql:LOAD DATA INPATH '/f95af4b623d14fba929e4ef26facd456.txt' INTO TABLE wfxtest
2018-09-17 14:50:57,932 INFO [OutputFormatLoader-consumer] com.chinacreator.sqoop.connector.hive.HiveLoader: Statement:org.apache.hive.jdbc.HiveStatement@43c1e92d
2018-09-17 14:50:58,050 ERROR [OutputFormatLoader-consumer] org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor: Error while loading data out of MR job.
org.apache.sqoop.common.SqoopException: CORE_0000:An unknown error has occurred
	at org.apache.sqoop.utils.ClassUtils.executeWithClassLoader(ClassUtils.java:286)
	at org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:259)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecut