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 Sat, 11 Jul 2009 23:29:45 GMT
View bin/HBase.rb.  See what it does for a truncate.  It calls HBaseAdmin
methods.  Do same from your program.
St.Ack

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

>
> Thanks, but I need to do this programmatically, not via the shell. The
> tables
> aren't huge - they only contain test data that needs to be cleaned up after
> the test cycle completes.
>
> Ishaaq
>
>
>
> stack-3 wrote:
> >
> > 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.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/delete-all-rows-in-table-tp24385603p24385875.html
> Sent from the HBase User mailing list archive at Nabble.com.
>
>

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