hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From stack <st...@duboce.net>
Subject Re: delete all rows in table
Date Wed, 08 Jul 2009 05:50:12 GMT
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...).


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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message