Hive mapreduce not working - no.of.reduce task is set to 0


#1

Select * from airport;
— it is working good …but below is not working

Hive mapper is god, but reducer is not working showing 0% only. so the result is coming in output.

hive> select * from airport WHERE airport_id=‘2050’;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there’s no reduce operator
Starting Job = job_201801102115_0008, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201801102115_0008
Kill Command = /home/hdusr/hadoop/libexec/…/bin/hadoop job -kill job_201801102115_0008
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2018-01-10 22:17:50,976 Stage-1 map = 0%, reduce = 0%
2018-01-10 22:17:56,000 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 1.23 sec
2018-01-10 22:17:57,003 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 1.23 sec
2018-01-10 22:17:58,006 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 1.23 sec
MapReduce Total cumulative CPU time: 1 seconds 230 msec
Ended Job = job_201801102115_0008
MapReduce Jobs Launched:
Job 0: Map: 1 Cumulative CPU: 1.23 sec HDFS Read: 6292 HDFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 1 seconds 230 msec
OK
Time taken: 12.936 seconds

please help me how to get output?
any configuration required in hive-default.xml?


#2

I think it is working fine.
can you paste all the commands that you used?