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/159479#M121868 <P>Can you try the following:</P><PRE>ALTER TABLE tablename DROP PARTITION IF EXISTS (load_s=timestamp '2017-02-22 12:21:39');</PRE> Thu, 16 Mar 2017 04:08:41 GMT deepesh1 2017-03-16T04:08:41Z