Mailing-List: contact hbase-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hbase-user@hadoop.apache.org
Received-SPF: pass (nike.apache.org: domain of saint.ack@gmail.com designates
 74.125.92.26 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type;
        b=m29QiPFKXHmyFbZhVWaDxaAObWx8gI1zDi605Hvq0Z9vWx0diLf31/6STsryCBN1F0
         GX449YkJNcUE6S7mYIAwECirQUX3OEdaGg3bJF+lN6CIEOZcLJzREQQO1O/pWDfE8MZ6
         3eU7yBgTneMJX3LkALySy6VwhDQivzhbmgwBA=
MIME-Version: 1.0
Sender: saint.ack@gmail.com
In-Reply-To: <24385603.post@talk.nabble.com>
References: <24385603.post@talk.nabble.com>
Date: Tue, 7 Jul 2009 22:50:12 -0700
Message-ID: <7c962aed0907072250o68a95b23v56721f2f8ee2423b@mail.gmail.com>
Subject: Re: delete all rows in table
From: stack <stack@duboce.net>
To: hbase-user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=0016364ef3d22e7625046e2b50aa

--0016364ef3d22e7625046e2b50aa
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

You could do that but would probably take some time.  Or you could truncate
the table via the shell.  This does disable, drop, recreate in 0.19.x.  In
TRUNK, it does disable, drop, major compaction of .META. table, and then
recreate (there is a known issue around dropping a big table.  A workaround
is to run major compaction on the .META. table.  In 0.19.x, you can do this
from the shell by doing 'major_compact ".META."').  Be warned that if your
table is big, users report our enable/disable is a flakey.  You might have
to do it a few times to ensure all regions disabled before delete will
succeed (fix coming...).

St.Ack


On Tue, Jul 7, 2009 at 10:34 PM, Ishaaq Chandy <ishaaq@gmail.com> wrote:

>
> Hi guys,
> What is the quickest way to delete all the rows in a table without deleting
> the table itself? The only way I can see would be to use a scanner. Is this
> right? I am using 0.19.3.
>
> Thanks,
> Ishaaq
> --
> View this message in context:
> http://www.nabble.com/delete-all-rows-in-table-tp24385603p24385603.html
> Sent from the HBase User mailing list archive at Nabble.com.
>
>

--0016364ef3d22e7625046e2b50aa--