Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6050310947 for ; Fri, 24 Jan 2014 03:59:04 +0000 (UTC) Received: (qmail 35070 invoked by uid 500); 24 Jan 2014 03:59:01 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 34376 invoked by uid 500); 24 Jan 2014 03:58:54 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 34359 invoked by uid 99); 24 Jan 2014 03:58:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Jan 2014 03:58:52 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of gokhaleprashant@gmail.com designates 209.85.216.171 as permitted sender) Received: from [209.85.216.171] (HELO mail-qc0-f171.google.com) (209.85.216.171) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Jan 2014 03:58:46 +0000 Received: by mail-qc0-f171.google.com with SMTP id n7so3715993qcx.2 for ; Thu, 23 Jan 2014 19:58:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=fBgJHlXbrAYBrnA9s9ve0gnnRmnPfV+g/bxQ/IUZvXY=; b=WFGARnSkf+RnxaJs0LjguK8/btSXduptm+428pY6N0mRnkre3hEH23FO8chyslP/2p 4p1Kg8or1RPf+So9SGQ5Y77T109mH65XUYKtUI8DROSSE7pLTeqHNlVoLbwz42m8VV6Z OgWs3B6WrzCov8TwYme6f0+0IW1LBnl8BA2R16sK27kYJ+Sh8e93HMrO+eWVXmXvzRvw vX6tjvJxDE8cJbSR9oArIpH3rHWOR7LpOicjZUM+4DX5/HasSXxXuLljnLsNGrxlTSg8 +8NutTzOEFri+HTHE8aJ5+w9s4HLXa6XLr6RuGWg9hovLIlGhj0xohfYTze3hB56oXAN 46vA== MIME-Version: 1.0 X-Received: by 10.224.26.15 with SMTP id b15mr17135670qac.46.1390535905752; Thu, 23 Jan 2014 19:58:25 -0800 (PST) Received: by 10.229.190.201 with HTTP; Thu, 23 Jan 2014 19:58:25 -0800 (PST) In-Reply-To: References: Date: Thu, 23 Jan 2014 19:58:25 -0800 Message-ID: Subject: Re: Unable to delete partitions From: prashant gokhale To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7bdc7ec2b5d7d804f0af5e6d X-Virus-Checked: Checked by ClamAV on apache.org --047d7bdc7ec2b5d7d804f0af5e6d Content-Type: text/plain; charset=ISO-8859-1 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, 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 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 > > --047d7bdc7ec2b5d7d804f0af5e6d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Perfect! I was able to drop partition using IGNORE PROTECT= ION. Thanks Siddharth.

-Prashant


On Thu, Jan 23, 2014 at= 5:37 PM, Siddharth Tiwari <siddharth.tiwari@live.com> wrote:
Try IGNORE PROTECTION= clause. I gues you had used NO DROP CASCADE clause when you created the sa= me.=A0

Sent from my iPhone

On Jan 23, 201= 4, at 4:28 PM, "prashant gokhale" <gokhaleprashant@gmail.com> wrote= :

Hello all,

I am working with some existing hive tables and I am having trouble deletin= g partitions. I get the following error -

hive > alter t= able tbl drop partition(p_date=3D'2014-01-22');
FAILED: S= emanticException [Error 30011]: Partition protected from being dropped db_t= est@=A0tbl@p_date=3D2014-01-22

=
I tried disablin= g NO_DROP[alter table tbl partition (p_date=3D'2014-01-22') disable= NO_DROP] , but that didn't help either.

Any idea what's ca= using this and how I could unblock myself?


Thanks,
Prashant
<= /div>

--047d7bdc7ec2b5d7d804f0af5e6d--