Hive select count(1) 报错问题困惑和解决

最新推荐文章于 2024-02-28 17:39:59 发布

womode

最新推荐文章于 2024-02-28 17:39:59 发布

阅读量1.9k

点赞数

分类专栏：学习路上文章标签： hive hadoop

本文链接：https://blog.csdn.net/womode/article/details/124444770

版权

在学习Hive时遇到执行`select count(1) from info_house_history`报错的问题，错误信息显示Job 1 out of 1失败，无mapper和reducer任务。通过检查发现是在root账户下运行Hive，解决方案是切换到hadoop账户再执行Hive命令，问题得到解决。

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

hive入门时，导数据后，执行：select count(1) from info_house_history;

报错：

hive (real_estate)> select count(1) from info_house_history;
Query ID = root_20220427100959_bf6dedc3-acff-4467-812d-45c15226f385
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
set mapreduce.job.reduces=<number>
2022-04-27 10:10:05 INFO client.AHSProxy: Connecting to Application History server at udp02/10.12.3.12:10201
2022-04-27 10:10:06 INFO client.AHSProxy: Connecting to Application History server at udp02/10.12.3.12:10201
Starting Job = job_1649670158454_0015, Trac