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

[#1]

Hi Team,

Iam getting different result while executing below command

select count (*) --output 1028

&

Select * from --output 500 ( which is correct)

What could be the issue

Regards

suresh bk

[#2]

Divakar,

MSCK command doesn't create partitions. It just gathers info about existing partitions and put them in the hive metastore. Please correct me if wrong.

[#3]

Cab you run below command and paste the output.

show partitions <table name>;