hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Megha Garg <megha.ga...@gmail.com>
Subject Re: Delete ORC partition
Date Tue, 24 Mar 2015 04:37:12 GMT
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 <stevedhoward@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.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 <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