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? >> >> >
