Let me make it clear HDFS 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.
... View more
