https://community.cloudera.com/t5/Support-Questions/select-count-query-taking-more-time/m-p/225398#M187259 <A rel="user" href="https://community.cloudera.com/users/1897/ashneesharma88.html" nodeid="1897">@Ashnee Sharma</A><P>Try below parameters and then run select count(*):</P><PRE>set hive.compute.query.using.stats=true; set hive.stats.fetch.column.stats=true; set hive.stats.fetch.partition.stats=true; set hive.fetch.task.conversion=more</PRE> Tue, 19 Dec 2017 14:20:26 GMT ssubhas 2017-12-19T14:20:26Z