查询语句在使用mapreduce是,显示成功,但在终端不显示查询结果为什么?

hive> select distinct s_id from score where c_id=01 and c_id=02
> ;
Automatically selecting local only mode for query
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Query ID = hadoop00_20190711160119_64b8dbc4-8cd3-4a9f-bf19-638b9ae6c198
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=
Job running in-process (local Hadoop)
2019-07-11 16:01:23,125 Stage-1 map = 0%, reduce = 0%
2019-07-11 16:01:25,129 Stage-1 map = 100%, reduce = 100%
Ended Job = job_local1844194359_0038
MapReduce Jobs Launched:
Stage-Stage-1: HDFS Read: 244198 HDFS Write: 218083 SUCCESS
Total MapReduce CPU Time Spent: 0 msec
OK
Time taken: 5.251 seconds

1个回答

yunLi789
云里星辰 你这篇文章说的是hive的简单查询不走mapreduce,但是我的查询语句和你说的也不一样啊,而且什么样的简单语句才不会执行mapreduce呢?还有就是我的hive是执行了mapreduce的,但是为什么我的不显示查询结果呢?
4 个月之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!