I did a count(*) on a table XXX with "set hive.auto.convert.join=false;" and got "643198 rows"
whereas when i did the same count(*) on the same table XXX with "set hive.auto.convert.join=true;" i get only "331815 rows".
I see more than 50% of rows getting dropped and no clue why. Anybody out there to help out?
Let me know if more details are required.