Unable to delete partitions

[prashant gokhale]

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