hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stack <st...@duboce.net>
Subject Re: how to remove dangling region and table?
Date Thu, 09 Sep 2010 05:03:55 GMT
hbase> scan '.META.'
# Look at output for rows w/ your table mentioned
hbase> delete '.META.', 'ROW_FROM_META_WITH_YOUR_TABLE'

Or you could dump scan to a file

echo "scan '.META.'"|./bin/hbase shell &> /tmp/meta.txt

... figure list of rows to delete

Then write script to delete rows.

St.Ack

On Wed, Sep 8, 2010 at 9:29 PM, Jinsong Hu <jinsong_hu@hotmail.com> wrote:
> 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" <stack@duboce.net>
> Sent: Wednesday, September 08, 2010 8:54 PM
> To: <user@hbase.apache.org>
> Subject: Re: how to remove dangling region and table?
>
>> On Wed, Sep 8, 2010 at 6:05 PM, Jinsong Hu <jinsong_hu@hotmail.com> 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
>>
>

Mime
View raw message