FAILED: SemanticException [Error 10004]: Line 1:16 Invalid table alias or column reference ‘id’: (possible column names are: s_id, s_name, s_birth, s_sex)
hive (hadoop)> select distinct s_id from student;
Query ID = admin_20190910064040_aa574fe2-24d2-4e35-ac66-2bd5e32b22b9
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks not specified. Estimated from input data size: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=
In order to set a constant number of reducers:
set mapreduce.job.reduces=
1.我的原因是以为我的集群是高可用性集群(HA),而我却没有开启yarn资源管理器,但是我配置了hive,这就造成了hive调用MapReduce的时候得不到回应。解决办法:开始yarn资源管理器。
2.如果开始了还是卡住了,请查看下文连接。
转载
hive简单查询语句能够执行,但是需要调用MapReduce的时候就卡住了
最新推荐文章于 2023-10-27 11:01:01 发布