Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of alanfgates@gmail.com designates
 209.85.220.45 as permitted sender)
Message-ID: <551030E4.5050301@gmail.com>
Date: Mon, 23 Mar 2015 08:27:32 -0700
From: Alan Gates <alanfgates@gmail.com>
User-Agent: Postbox 3.0.11 (Macintosh/20140602)
MIME-Version: 1.0
To: user@hive.apache.org
Subject: Re: Delete ORC partition
References: 
 <CAJufLTcqwGziXSXDdJtLxxDHP2XdSvA7CgBvAhs0fAa-HRyMiQ@mail.gmail.com>
In-Reply-To: 
 <CAJufLTcqwGziXSXDdJtLxxDHP2XdSvA7CgBvAhs0fAa-HRyMiQ@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------080702090102080204010802"

This is a multi-part message in MIME format.
--------------080702090102080204010802
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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 <mailto:megha.garg3@gmail.com>
> 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?

--------------080702090102080204010802
Content-Type: multipart/related;
 boundary="------------030103010704080801050802"


--------------030103010704080801050802
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html><head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head><body bgcolor="#FFFFFF" text="#000000">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?<br>
<br>
Alan.<br>
<br>
<blockquote style="border: 0px none;" 
cite="mid:CAJufLTcqwGziXSXDdJtLxxDHP2XdSvA7CgBvAhs0fAa-HRyMiQ@mail.gmail.com"
 type="cite">
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="display:table;width:100%;border-top:1px solid 
#EDEEF0;padding-top:5px"> 	<div 
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
 photoaddress="megha.garg3@gmail.com" photoname="Megha Garg" 
src="cid:part1.00040608.07070608@gmail.com" 
name="compose-unknown-contact.jpg" height="25px" width="25px"></div>   <div
 
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
   	<a moz-do-not-send="true" href="mailto:megha.garg3@gmail.com" 
style="color:#737F92 
!important;padding-right:6px;font-weight:bold;text-decoration:none 
!important;">Megha Garg</a></div>   <div 
style="display:table-cell;white-space:nowrap;vertical-align:middle;">   
  <font color="#9FA2A5"><span style="padding-left:6px">March 23, 2015 at
 5:43</span></font></div></div></div>
  <div style="color:#888888;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr"><span 
style="font-size:13px">Hi,</span><div style="font-size:13px"><br></div><div
 style="font-size:13px">I am new to hive. I have created one ORC table 
with partitioning where my partition looks like below:-</div><div 
style="font-size:13px"><br></div><div style="font-size:13px"><div><b>date=2014-01-01
 00%3A00%3A00.0</b></div><div><b>date=2014-01-02 00%3A00%3A00.0</b></div><div><b>date=2014-01-03
 00%3A00%3A00.0</b></div><div><br></div><div>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:-</div><div><br></div><div><b> alter table 
my_tbl drop  partition (date='2014-01-0200.00.00.0') ;</b> <br></div><div><br></div><div>But
 it is not working.  How can i delete it?</div></div></div>

  </div>
</blockquote>
</body></html>

--------------030103010704080801050802
Content-Type: image/jpeg; x-apple-mail-type=stationery;
 name="compose-unknown-contact.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.00040608.07070608@gmail.com>
Content-Disposition: inline;
 filename="compose-unknown-contact.jpg"

/9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEC
AQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgIC
AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAAR
CAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUK
BwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAA
AAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oA
DAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJ
VIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4
v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx
+a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mR
UfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbab
eg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbz
hbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUi
yeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37y
zqnlfp6FrqbwawG8/9k=
--------------030103010704080801050802--

--------------080702090102080204010802--