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/159481#M121870 <P>For me the command worked.</P><PRE>hive> show partitions tablename; OK load_s=2017-02-22 12%3A21%3A39 hive> alter table tablename drop partition (load_s=timestamp '2017-02-22 12:21:39'); Dropped the partition load_s=2017-02-22 12%3A21%3A39 OK </PRE><P>You can potentially use this <A href="https://community.hortonworks.com/questions/89160/hive-drop-partitions-how-to-drop-date-partitions-c.html#answer-89232">workaround</A> on other thread.</P> Fri, 17 Mar 2017 09:21:45 GMT deepesh1 2017-03-17T09:21:45Z