Re: Unable to delete partitions

2014-01-23 Thread Siddharth Tiwari
You are welcome !!! Sent from my iPhone > On Jan 23, 2014, at 8:59 PM, "prashant gokhale" > 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 >> wrote: >> Try IGNORE PROTECT

Re: Unable to delete partitions

2014-01-23 Thread prashant gokhale
Perfect! I was able to drop partition using IGNORE PROTECTION. Thanks Siddharth. -Prashant On Thu, Jan 23, 2014 at 5:37 PM, Siddharth Tiwari 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, 201

Re: Unable to delete partitions

2014-01-23 Thread Siddharth Tiwari
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" > wrote: > > Hello all, > > I am working with some existing hive tables and I am having trouble deleting > partitions. I

Unable to delete partitions

2014-01-23 Thread 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-2