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 .