Do you have a typo in the partition name? There is a space in the list you have between day and hour, but not in your drop statement. Also %3A is hex for the ":" character, but you don't have that in you partition name to get dropped.
Sent from my iPad > On Mar 23, 2015, at 11:46 PM, Megha Garg <megha.ga...@gmail.com> wrote: > > I am not getting any error and my hive version is 0.13 > >> On Mon, Mar 23, 2015 at 8:57 PM, Alan Gates <alanfga...@gmail.com> wrote: >> Are you getting an error or does the partition just not get deleted? If you >> get an error message can you share it? What version of Hive are you using? >> >> Alan. >> >>> <compose-unknown-contact.jpg> Megha Garg March 23, 2015 at 5:43 >>> 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? >