Select * from and & Select count (*) different result

[#1]

Hi Team,

Iam getting different result while executing below command

select count (*) --output 816293

&

Select * from --output 809,254 rows ( which is correct)

Also tried by using " analyze table TABLE_NAME partition(partition_date) compute statistics ; " and even done with running "MSCK REPAIR TABLE <tablename>;" But no use. Is their anything that I am missing.

Kindly Need help at this point .

[#2]

Try set hive.compute.query.using.stats=false and see if you get correct count using select count(*). If this works that means you have stale statistics and you need to re-run analyze table on all partitions.