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 devopam@gmail.com designates
 209.85.217.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CALtQu19zD5YZx6L_SkQzdB8QfXGWHxmp4woLDXAbQow=qWvHfQ@mail.gmail.com>
References: 
 <CALtQu19zD5YZx6L_SkQzdB8QfXGWHxmp4woLDXAbQow=qWvHfQ@mail.gmail.com>
Date: Tue, 22 Jul 2014 18:37:42 +0530
Message-ID: 
 <CAGd0Wx+E3SgoAMKA=MyoC9kJ7CA2k0OECRxqFJOUFoP=3EhbvQ@mail.gmail.com>
Subject: Re: Drop Partition by ID
From: Devopam Mittra <devopam@gmail.com>
To: "user@hive.apache.org" <user@hive.apache.org>
Content-Type: multipart/alternative; boundary=001a11c34ba8a78c8f04fec7e80a

--001a11c34ba8a78c8f04fec7e80a
Content-Type: text/plain; charset=UTF-8

Please try using escape character around the '%' if not already done so.

regards
Dev


On Mon, Jul 21, 2014 at 7:32 PM, fab wol <darkwolli32@gmail.com> wrote:

> Hi everyone,
>
> I have the following problem: I have a partitoned managed table (Partition
> table is a string which represents a date, eg. log-date="2014-07-15").
> Unfortunately there is one partition in there like this:
> log_date=2014-07-15-23%3A45%3A38 (copied from show partitions stmt). This
> partitions most likeley got created to a wrong script 8which is fixed).
>
> Now i want to delete this partition, but it doesn't work:
>
>    - alter table ... drop partitition
>    (log_date='2014-07-15-23%3A45%3A38') gives no error, but the partition is
>    still existing afterwards
>    - I tried escaping the %-signs with backslashes but no luck with that
>    - I delete the directory in the HDFS and run msck repair table
>    afterwards. It recognizes that the folder is missing but is not deleting
>    the metadata
>
> So what can I do to get rid of the metadata? My next guess would be to go
> directly to the metastore DB and delete the metadata there. But what
> exactly has to be deleted? I guess there are several dependencies.
>
> Other idea: is there a possibility in Hive to delete a partition by a
> unique ID or something like that?
>
> Or what is needed to delete the table with the normal "alter table drop
> partition" command?
>
> Cheers
> Wolli
>


-- 
Devopam Mittra
Life and Relations are not binary

--001a11c34ba8a78c8f04fec7e80a
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Please try using escape character around the &#39;%&#39; i=
f not already done so.<div><br></div><div>regards</div><div>Dev</div></div>=
<div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Mon, Jul 2=
1, 2014 at 7:32 PM, fab wol <span dir=3D"ltr">&lt;<a href=3D"mailto:darkwol=
li32@gmail.com" target=3D"_blank">darkwolli32@gmail.com</a>&gt;</span> wrot=
e:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi everyone,<div><br></div>=
<div>I have the following problem: I have a partitoned managed table (Parti=
tion table is a string which represents a date, eg. log-date=3D&quot;2014-0=
7-15&quot;). Unfortunately there is one partition in there like this: log_d=
ate=3D2014-07-15-23%3A45%3A38 (copied from show partitions stmt). This part=
itions most likeley got created to a wrong script 8which is fixed).</div>

<div><br></div><div>Now i want to delete this partition, but it doesn&#39;t=
 work:</div><div><ul><li>alter table ... drop partitition (log_date=3D&#39;=
2014-07-15-23%3A45%3A38&#39;) gives no error, but the partition is still ex=
isting afterwards</li>

<li>I tried escaping the %-signs with backslashes but no luck with that</li=
><li>I delete the directory in the HDFS and run msck repair table afterward=
s. It recognizes that the folder is missing but is not deleting the metadat=
a</li>

</ul><div>So what can I do to get rid of the metadata? My next guess would =
be to go directly to the metastore DB and delete the metadata there. But wh=
at exactly has to be deleted? I guess there are several dependencies.</div>

</div><div><br></div><div>Other idea: is there a possibility in Hive to del=
ete a partition by a unique ID or something like that?</div><div><br></div>=
<div>Or what is needed to delete the table with the normal &quot;alter tabl=
e drop partition&quot; command?</div>

<div><br></div><div>Cheers</div><div>Wolli</div></div>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br>Devopam Mitt=
ra<br>Life and Relations are not binary
</div>

--001a11c34ba8a78c8f04fec7e80a--