hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Tiwari <siddharth.tiw...@live.com>
Subject Re: Unable to delete partitions
Date Fri, 24 Jan 2014 01:37:41 GMT
Try IGNORE PROTECTION clause. I gues you had used NO DROP CASCADE clause when you created the
same. 

Sent from my iPhone

> On Jan 23, 2014, at 4:28 PM, "prashant gokhale" <gokhaleprashant@gmail.com> wrote:
> 
> Hello all,
> 
> I am working with some existing hive tables and I am having trouble deleting partitions.
I get the following error -
> 
> hive > alter table tbl drop partition(p_date='2014-01-22');
> FAILED: SemanticException [Error 30011]: Partition protected from being dropped db_test@
tbl@p_date=2014-01-22
> 
> I tried disabling NO_DROP[alter table tbl partition (p_date='2014-01-22') disable NO_DROP]
, but that didn't help either.
> 
> Any idea what's causing this and how I could unblock myself?
> 
> 
> Thanks,
> Prashant

Mime
View raw message