https://community.cloudera.com/t5/Support-Questions/select-count-query-taking-more-time/m-p/225399#M187260 <P>Hi <A rel="user" href="https://community.cloudera.com/users/1897/ashneesharma88.html" nodeid="1897">@Ashnee Sharma</A></P><P>Based on the logs I could see that when you run a count query it triggers a mapreduce job and it takes time. Could you check running this command (set hive.stats.fetch.column.stats) and verify that it status is true?</P><P>Because when this property is enable then stats should be fetched based on stats information available in the metastore which will not trigger any jobs when you run a count query. It should work regardless whether you are using mr/tez as your execution engine. </P><P>Hope it helps!!</P> Wed, 20 Dec 2017 16:46:41 GMT balavignesh_nag 2017-12-20T16:46:41Z