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. ... View more

Hello Divakar, I don't fully understand why we need to drop partitions ? as you suggested, MSCK command would be good enough to update the hive metastore with latest partitions info. Can you help me understand the need for dropping the partitions ? ... View more

Suresh, do something like below. 1) select partition_column, count(*) from table; -- look for count of records by partition. 2) select * from table ; - look if this query is reading data from all partitions or only from a few. This should atleast point you to find what is actually happening. ... View more