HI @shivam0408 , Can you clarify what CDH/HDP/CDP version are you using and what is the datatype of the "DATETIME" column?  What is the desired end result of this command? To drop all the partitions? ... View more

have u tried move out (or delete the folder for that partition ) from hdfs, then run: msck repair table <tablename> ... View more