how do I delete the entries from .META. ? Is there a command or utility that I can use ?

the table doesn't even appear in "list" command any more.
if I try to run disable command, the shell says the table doesn't exist.
if I try to a table with that name, the shell says the table already exists.

Jimmy.

--------------------------------------------------
From: "Stack" <[email protected]>
Sent: Wednesday, September 08, 2010 8:54 PM
To: <[email protected]>
Subject: Re: how to remove dangling region and table?

On Wed, Sep 8, 2010 at 6:05 PM, Jinsong Hu <[email protected]> wrote:
Hi,
I created a table and inserted 1.1 TB data, then I tried to drop the table
and data. I understand that current hbase has a bug,


Yeah, enable/disable is kinda flakey in 0.20.x hbase.

so I renamed the table to a temp name. and then dropped the temp table.
However, I found that some of the regions are not renamed to the temp table
and they are still with the original table name.
I tried to physically remove the HFS dir, and restart master and
regionserver, delete it from HDFS again , and restart master/regionserver
again. the regions just continue to hang there. and I can't create a table
with the original name.

Yes.  The table has mention in the .META. table.  You'll need to
delete the entries here as well as remove the table dir from hdfs.

Or, just keep trying to disable.  It usually succeeds eventually.
Then do drop table.

Is there any way I can remove the dangling region and then I can create a
brand new table with original name ?


Go through meta and delete each row which has the tablename for a prefix.

Or shutdown hbase, remove the hbase.rootdir and restart.

St.Ack

Reply via email to