Hi, I am new to hive. I have created one ORC table with partitioning where my partition looks like below:-
*date=2014-01-01 00%3A00%3A00.0* *date=2014-01-02 00%3A00%3A00.0* *date=2014-01-03 00%3A00%3A00.0* I want to delete my second partition (date=2014-01-02 00%3A00%3A00.0) but i am not able to do so. I am using the below query:- * alter table my_tbl drop partition (date='2014-01-0200.00.00.0') ;* But it is not working. How can i delete it?
