You are welcome !!! Sent from my iPhone
> On Jan 23, 2014, at 8:59 PM, "prashant gokhale" <gokhaleprash...@gmail.com> > wrote: > > Perfect! I was able to drop partition using IGNORE PROTECTION. Thanks > Siddharth. > > -Prashant > > >> On Thu, Jan 23, 2014 at 5:37 PM, Siddharth Tiwari >> <siddharth.tiw...@live.com> wrote: >> 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" <gokhaleprash...@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 >
