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
