question How to delete a particular Partition (Timestamp Based) from a hive table ? Example - Partition column value is load_s=2017-02-22 12%253A21%253A39 in Support Questions

question How to delete a particular Partition (Timestamp Based) from a hive table ? Example - Partition column value is load_s=2017-02-22 12%253A21%253A39 in Support Questions https://community.cloudera.com/t5/Support-Questions/How-to-delete-a-particular-Partition-Timestamp-Based-from-a/m-p/159478#M121867 Let me make it clearHDFS Level- we have only valid partitions (parition1,parition2)Table Level - we have both valid(parition1,partition2) and invalid partitions(partition3,partition4). I would like to drop only invalid partitions(partition3,partition4). -> Unable to drop by passing Url encoded characters & Timestamp.-> Created invalid partition at HDFS level, unable to drop.-> Issued MCSK REPAIR command , post success also unable to drop.ALTER TABLE tablename DROP PARTITION IF EXISTS (load_s='2017-02-22 12:21:39'); - did not worked.ALTER TABLE tablename DROP PARTITION (load_s='2017-02-22 12:21:39'); - did not worked.ALTER TABLE tablename DROP PARTITION (load_s='2017-02-22 12%3A21%3A39'); - did not worked. Thu, 16 Mar 2017 02:19:24 GMT t_sankar85 2017-03-16T02:19:24Z