hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Howard <stevedhow...@gmail.com>
Subject Re: Delete ORC partition
Date Tue, 24 Mar 2015 04:05:15 GMT
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.garg3@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 <alanfgates@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?
> 

Mime
View raw message