https://community.cloudera.com/t5/Support-Questions/select-count-query-taking-more-time/m-p/225400#M187261 <P><A rel="user" href="https://community.cloudera.com/users/5019/ssubhas.html" nodeid="5019">@Sindhu</A> </P><P>I have tried with above values.</P><P>Still taking time. There is aroung 38 lakhs records.</P><P>Query ID = ec2-user_20171221001453_85ebceae-ab99-4a88-aadf-8f3eb6d05fdb 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=&lt;number&gt; In order to limit the maximum number of reducers: set hive.exec.reducers.max=&lt;number&gt; In order to set a constant number of reducers: set mapreduce.job.reduces=&lt;number&gt; Starting Job = job_1513772289178_0006, Tracking URL = <A href="http://ip-192-168-180-54.ca-central-1.compute.internal:8088/proxy/application_1513772289178_0006/" target="_blank">http://ip-192-168-180-54.ca-central-1.compute.internal:8088/proxy/application_1513772289178_0006/</A> Kill Command = /usr/hdp/2.6.2.14-5/hadoop/bin/hadoop job -kill job_1513772289178_0006 Hadoop job information for Stage-1: number of mappers: 3; number of reducers: 1 2017-12-21 00:15:10,576 Stage-1 map = 0%, reduce = 0% 2017-12-21 00:16:11,542 Stage-1 map = 0%, reduce = 0%, Cumulative CPU 192.03 sec 2017-12-21 00:16:34,173 Stage-1 map = 33%, reduce = 0%, Cumulative CPU 260.89 sec 2017-12-21 00:16:38,289 Stage-1 map = 67%, reduce = 0%, Cumulative CPU 270.02 sec 2017-12-21 00:16:45,514 Stage-1 map = 67%, reduce = 22%, Cumulative CPU 279.97 sec 2017-12-21 00:17:35,937 Stage-1 map = 100%, reduce = 22%, Cumulative CPU 330.59 sec 2017-12-21 00:17:36,967 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 332.77 sec MapReduce Total cumulative CPU time: 5 minutes 32 seconds 770 msec Ended Job = job_1513772289178_0006 MapReduce Jobs Launched: Stage-Stage-1: Map: 3 Reduce: 1 Cumulative CPU: 332.77 sec HDFS Read: 322983 HDFS Write: 8 SUCCESS Total MapReduce CPU Time Spent: 5 minutes 32 seconds 770 msec OK 3778700</P> Thu, 21 Dec 2017 13:19:03 GMT ashneesharma88 2017-12-21T13:19:03Z