What happens if you try it with the actual colon rather than the encoded value?
alter table my_tbl drop partition (date='2014-01-02 00:00:00.0') ; On Tue, Mar 24, 2015 at 12:37 AM, Megha Garg <megha.ga...@gmail.com> wrote: > Thanks for correcting, that was a typo. My actual command is :- > > alter table my_tbl drop partition (date='2014-01-02 00%3A00%3A00.0') ; > > On Tue, Mar 24, 2015 at 9:35 AM, Steve Howard <stevedhow...@gmail.com> > wrote: > >> 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 <megha.ga...@gmail.com> >>> 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? >>> >>> >> >
