Thanks a lot. That worked for me. On Wed, Mar 25, 2015 at 2:40 AM, Steve Howard <[email protected]> wrote:
> 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 <[email protected]> > 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 <[email protected]> >> 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 <[email protected]> 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 <[email protected]> >>> 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 <[email protected]> >>>> 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? >>>> >>>> >>> >> >
