配置单元计数(*)查询显示map和reduce的100%,但未显示正确的结果

2q5ifsrm  于 2021-06-26  发布在  Hive
关注(0)|答案(0)|浏览(205)

下面是我执行的一组查询

hive> CREATE external TABLE IF NOT EXISTS hive_table5(id int, name 
string) row format delimited fields terminated by ',';
OK
Time taken: 0.128 seconds

hive> load data inpath 
'hdfs://localhost:54310/usr/hive/warehouse/hive_table4' into table 
hive_table5;
Loading data to table default.hive_table5
Table default.hive_table5 stats: [numFiles=1, totalSize=23]
OK
Time taken: 0.193 seconds

hive> select count(*) from hive_table5;
Query ID = hduser_20170804180531_0f533fc3-4ce5-44d2-9501-68f168115ae0
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>
Job running in-process (local Hadoop)
2017-08-04 18:05:32,654 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_local1227119137_0037
MapReduce Jobs Launched: 
Stage-Stage-1:  HDFS Read: 70974 HDFS Write: 104 SUCCESS
Total MapReduce CPU Time Spent: 0 msec
OK
0
Time taken: 1.255 seconds, Fetched: 1 row(s)
hive>

它显示map和reduce作业都100%完成。但当表中加载了1行时,它仍然在count(*)中给出结果0。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题