question Re: 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 Re: 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/159486#M121875 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.Thanks Wed, 29 Mar 2017 02:53:05 GMT t_sankar85 2017-03-29T02:53:05Z