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/159480#M121869 <P></P><P>Deepesh - it did not worked. Getting below error.</P><P><STRONG>With IF EXIST</STRONG> </P><P></P><P>Error: Error while compiling statement: FAILED: ParseException line 1:75 mismatched input 'IF' expecting ( near 'PARTITION' in drop partition statement (state=42000,code=40000)</P><P><STRONG>Without IF EXIST</STRONG> -</P><P>Error: Error while compiling statement: FAILED: <STRONG>SemanticException Unexpected unknown partitions for</STRONG> (load_s = 2017-02-22 12:21:39.0) (state=42000,code=40000)</P> Thu, 16 Mar 2017 19:54:01 GMT t_sankar85 2017-03-16T19:54:01Z