@AnjiReddy Anumolu We are using TEZ engine. Even after doing the analyze, rows are getting dropped. ANALYZE TABLE XXX PARTITION(snapshot_id='TEST9') COMPUTE STATISTICS; ANALYZE TABLE XXX PARTITION(snapshot_id='TEST9') COMPUTE STATISTICS for columns; SET hive.auto.convert.join =false; select count(*) from XXX where snapshot_id='TEST9' Count - 643198 SET hive.auto.convert.join =true; select count(*) from XXX where snapshot_id='TEST9' Count - 331815 ... View more