Mailing-List: contact user-help@kudu.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@kudu.incubator.apache.org
Date: Thu, 21 Apr 2016 01:02:23 -0700
From: Casey Ching <casey@cloudera.com>
To: user@kudu.incubator.apache.org, Mike Percy <mpercy@apache.org>
Message-ID: <etPan.5718890f.22cfcb0e.1d5@mac>
In-Reply-To: 
 <CAJLbxRYJyN7QsCs2yXdxPnP0hZOOaZLCzn27XsFuj7Radwf+cQ@mail.gmail.com>
References: 
 <CAJ+QY_GtQXnfxZ8DM6LE8cKaeT1zQzFqshSK2_V-hmJJUO9DJg@mail.gmail.com>
 <CADY20s5LKMBARB18=WwH99RG=Qn6Xpac4F3kYzyLR8zQ4wDNcw@mail.gmail.com>
 <CAJLbxRYJyN7QsCs2yXdxPnP0hZOOaZLCzn27XsFuj7Radwf+cQ@mail.gmail.com>
Subject: Re: How to truncate a kudu table?
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="5718890f_201fcde6_1d5"

--5718890f_201fcde6_1d5
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Thanks Mike.

Darren, if this happens again it would be great if you could send the err=
or message. It might give a better sense of what to do.


On April 21, 2016 at 12:56:23 AM, Mike Percy (mpercy=40apache.org) wrote:=


=46iled a JIRA to track the Impala metadata inconsistency issue =40=C2=A0=
https://issues.cloudera.org/browse/IMPALA-3387

On Thu, Apr 21, 2016 at 12:23 AM, Todd Lipcon <todd=40cloudera.com> wrote=
:
Hi Darren,

Unfortunately kudu does not currently support any truncate operation. You=
'll have to delete and recreate the table.

Todd

On Apr 21, 2016 12:22 AM, =22Darren Hoo=22 <darren.hoo=40gmail.com> wrote=
:
As=C2=A0IMPALA-2999 is still open, so truncate from impala is not possibl=
e now.

Can I truncate a kudu table using kudu side tools=3F kudu-admin only has=C2=
=A0delete=5Ftable operation

btw,=C2=A0delete=5Ftable=C2=A0is very useful, once when I drop a big kudu=
 table from impala-shell and=C2=A0
it fails, the metadata between impala and kudu is out of sync, neither ca=
n I drop nor create the same table.
and kudu-admin saves me=21


--5718890f_201fcde6_1d5
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<html><head><style>body=7Bfont-family:Helvetica,Arial;font-size:13px=7D</=
style></head><body style=3D=22word-wrap: break-word; -webkit-nbsp-mode: s=
pace; -webkit-line-break: after-white-space;=22><div id=3D=22bloop=5Fcust=
omfont=22 style=3D=22font-family:Helvetica,Arial;font-size:13px; color: r=
gba(0,0,0,1.0); margin: 0px; line-height: auto;=22>Thanks Mike.</div><div=
 id=3D=22bloop=5Fcustomfont=22 style=3D=22font-family:Helvetica,Arial;fon=
t-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;=22><=
br></div><div id=3D=22bloop=5Fcustomfont=22 style=3D=22font-family:Helvet=
ica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-heigh=
t: auto;=22>Darren, if this happens again it would be great if you could =
send the error message. It might give a better sense of what to do.</div>=
 <br> <div id=3D=22bloop=5Fsign=5F1461225534184670976=22 class=3D=22bloop=
=5Fsign=22></div> <br><p class=3D=22airmail=5Fon=22>On April 21, 2016 at =
12:56:23 AM, Mike Percy (<a href=3D=22mailto:mpercy=40apache.org=22>mperc=
y=40apache.org</a>) wrote:</p> <blockquote type=3D=22cite=22 class=3D=22c=
lean=5Fbq=22><span><div><div></div><div>


<title></title>


<div dir=3D=22ltr=22>=46iled a JIRA to track the Impala metadata
inconsistency issue =40&nbsp;<a href=3D=22https://issues.cloudera.org/bro=
wse/IMPALA-3387=22>https://issues.cloudera.org/browse/IMPALA-3387</a></di=
v>
<div class=3D=22gmail=5Fextra=22><br>
<div class=3D=22gmail=5Fquote=22>On Thu, Apr 21, 2016 at 12:23 AM, Todd
Lipcon <span dir=3D=22ltr=22>&lt;<a href=3D=22mailto:todd=40cloudera.com=22=
 target=3D=22=5Fblank=22>todd=40cloudera.com</a>&gt;</span> wrote:<br>
<blockquote class=3D=22gmail=5Fquote=22 style=3D=22margin:0 0 0 .8ex;bord=
er-left:1px =23ccc solid;padding-left:1ex=22>
<p dir=3D=22ltr=22>Hi Darren,</p>
<p dir=3D=22ltr=22>Unfortunately kudu does not currently support any
truncate operation. You'll have to delete and recreate the
table.</p>
<p dir=3D=22ltr=22><span class=3D=22HOEnZb=22><font color=3D=22=23888888=22=
>Todd</font></span></p>
<div class=3D=22HOEnZb=22>
<div class=3D=22h5=22>
<div class=3D=22gmail=5Fquote=22>On Apr 21, 2016 12:22 AM, =22Darren Hoo=22=

&lt;<a href=3D=22mailto:darren.hoo=40gmail.com=22 target=3D=22=5Fblank=22=
>darren.hoo=40gmail.com</a>&gt; wrote:<br type=3D=22attribution=22>
<blockquote class=3D=22gmail=5Fquote=22 style=3D=22margin:0 0 0 .8ex;bord=
er-left:1px =23ccc solid;padding-left:1ex=22>
<div dir=3D=22ltr=22>As&nbsp;IMPALA-2999 is still open, so truncate from
impala is not possible now.
<div><br></div>
<div>Can I truncate a kudu table using kudu side tools=3F kudu-admin
only has&nbsp;<span style=3D=22font-family:Menlo;font-size:11px=22>delete=
=5Ftable
operation</span></div>
<div><span style=3D=22font-family:Menlo;font-size:11px=22><br></span></di=
v>
<div><span style=3D=22font-family:Menlo;font-size:11px=22>btw,&nbsp;</spa=
n><span style=3D=22font-family:Menlo;font-size:11px=22>delete=5Ftable&nbs=
p;</span>is very
useful, once when I drop a big kudu table from impala-shell
and&nbsp;</div>
<div>it fails, the metadata between impala and kudu is out of sync,
neither can I drop nor create the same table.</div>
<div>and kudu-admin saves me=21</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br></div>


</div></div></span></blockquote></body></html>
--5718890f_201fcde6_1d5--