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 > >
