Hive with Tez execution engine - count(*) not working , returning 0 results. Solution - set hive.compute.query.using.stats=false Refer - https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties hive.compute.query.using.stats Default Value: false Added In: Hive 0.13.0 with HIVE-5483 When set to true Hive will answer a few queries like min, max, and count(1) purely using statistics stored in the metastore. For basic statistics collection, set the configuration property hive.stats.autogather to true. For more advanced statistics collection, run ANALYZE TABLE queries.