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 BE74C10988 for ; Tue, 24 Mar 2015 04:40:17 +0000 (UTC) Received: (qmail 71679 invoked by uid 500); 24 Mar 2015 04:39:54 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 71612 invoked by uid 500); 24 Mar 2015 04:39: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 71602 invoked by uid 99); 24 Mar 2015 04:39:54 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Mar 2015 04:39:54 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of megha.garg3@gmail.com designates 209.85.217.173 as permitted sender) Received: from [209.85.217.173] (HELO mail-lb0-f173.google.com) (209.85.217.173) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Mar 2015 04:39:48 +0000 Received: by lbbsy1 with SMTP id sy1so132886889lbb.1 for ; Mon, 23 Mar 2015 21:37:12 -0700 (PDT) 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=YuyxfdPmwMWJ0mgEEe8XcYc8Jfky/ptG3Z6HVzrh5ZU=; b=WkMRVJLW4leBy6Hiy1wHJLEJdOzR0QlBuzGlXmbr8qAfoL4ySEPYBamXoMEomQL726 /8ykZ72RFxG8LfgFN1L0XXCXpzLPbmovsR6qRtgujkmGclvY0NDZ40WovVXltL68VEV7 52RLGnDjiqa6/N0CkK69sAv260ryXzQ6ffPO7HFrKtnHXDCUwe28n04wBvwlhgEuhs/y GjJDDRDY1fYZjr5NG6VkeiapXzhapbmT9JiYtb+C9+jhvJSQGz5rDyfbRX8/ha2fbds7 KBNCX1MOY/eco9K6SOpXlyLKvlR4WXQ7AAIvFiN38PQtQs0baNcgAC9j2HCFVd5t2RiL qNEA== MIME-Version: 1.0 X-Received: by 10.112.134.167 with SMTP id pl7mr1950996lbb.63.1427171832600; Mon, 23 Mar 2015 21:37:12 -0700 (PDT) Received: by 10.25.150.65 with HTTP; Mon, 23 Mar 2015 21:37:12 -0700 (PDT) In-Reply-To: References: <551030E4.5050301@gmail.com> Date: Tue, 24 Mar 2015 10:07:12 +0530 Message-ID: Subject: Re: Delete ORC partition From: Megha Garg To: user@hive.apache.org Content-Type: multipart/alternative; boundary=089e011767f91d9be005120156f7 X-Virus-Checked: Checked by ClamAV on apache.org --089e011767f91d9be005120156f7 Content-Type: text/plain; charset=UTF-8 Thanks for correcting, that was a typo. My actual command is :- alter table my_tbl drop partition (date='2014-01-02 00%3A00%3A00.0') ; On Tue, Mar 24, 2015 at 9:35 AM, Steve Howard wrote: > Do you have a typo in the partition name? There is a space in the list > you have between day and hour, but not in your drop statement. Also %3A is > hex for the ":" character, but you don't have that in you partition name to > get dropped. > > Sent from my iPad > > On Mar 23, 2015, at 11:46 PM, Megha Garg wrote: > > I am not getting any error and my hive version is 0.13 > > On Mon, Mar 23, 2015 at 8:57 PM, Alan Gates wrote: > >> Are you getting an error or does the partition just not get deleted? If >> you get an error message can you share it? What version of Hive are you >> using? >> >> Alan. >> >> >> Megha Garg >> March 23, 2015 at 5:43 >> Hi, >> >> I am new to hive. I have created one ORC table with partitioning where my >> partition looks like below:- >> >> *date=2014-01-01 00%3A00%3A00.0* >> *date=2014-01-02 00%3A00%3A00.0* >> *date=2014-01-03 00%3A00%3A00.0* >> >> I want to delete my second partition (date=2014-01-02 00%3A00%3A00.0) but >> i am not able to do so. I am using the below query:- >> >> * alter table my_tbl drop partition (date='2014-01-0200.00.00.0') ;* >> >> But it is not working. How can i delete it? >> >> > --089e011767f91d9be005120156f7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks for correcting, that was a typo. My actual command = is :-

=C2=A0alter table my_tbl drop partition (date=3D&#= 39;2014-01-02 00%3A00%3A00.0') ;

On Tue, Mar 24, 2015 at 9:35 AM, Steve H= oward <stevedhoward@gmail.com> wrote:
Do you have a typo in the partition= name?=C2=A0 There is a space in the list you have between day and hour, bu= t not in your drop statement.=C2=A0 Also %3A is hex for the ":" c= haracter, but you don't have that in you partition name to get dropped.=

Sent from my iPad

On Mar 23, 2015, a= t 11:46 PM, Megha Garg <megha.garg3@gmail.com> wrote:

I am not getting= any error and my hive version is 0.13

On Mon, Mar 23, 2015 at = 8:57 PM, Alan Gates <alanfgates@gmail.com> wrote:
Are you getting = an error=20 or does the partition just not get deleted?=C2=A0 If you get an error messa= ge can you share it?=C2=A0 What version of Hive are you using?

Alan.

<compose-unknown-= contact.jpg>
=20 March 23, 2015 a= t 5:43
Hi,

I am new to hive. I have creat= ed one ORC table=20 with partitioning where my partition looks like below:-

date=3D2014= -01-01 00%3A00%3A00.0
date=3D2014-01-02 00%3A00%3A00.0
=
date=3D2014-01-03 00%3A00%3A00.0

I want to delete my second=20 partition (date=3D2014-01-02 00%3A00%3A00.0) but i am not able to do so. I am using the below query:-

=C2=A0alter table= =20 my_tbl drop =C2=A0partition (date=3D'2014-01-0200.00.00.0') ;= =C2=A0

But it is not working.=C2=A0 How can i delete it?


--089e011767f91d9be005120156f7--