hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Gates <alanfga...@gmail.com>
Subject Re: Delete ORC partition
Date Mon, 23 Mar 2015 15:27:32 GMT
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.

> Megha Garg <mailto:megha.garg3@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?

Mime
View raw message