Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of saint.ack@gmail.com designates
 74.125.82.51 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
         :content-transfer-encoding;
        b=Cvdn+ErLdlYnd6g1tKl+956q884Bp1egOxAmWXi9JxHkqj8WNasA2MK7sZSOm8VpyG
         xj50gpQJ7iLhCSNDZWSnoSyhPsaF5spZjQMQICQaqt51VfZNUTCnXVfhI+lq/QOQbkHx
         MVCWtCOszvMym1MY/CQ5564nquZUuZ1Jcb4aM=
MIME-Version: 1.0
Sender: saint.ack@gmail.com
In-Reply-To: <BLU147-DS6C06CFCE89B5D87AFAEDEF5730@phx.gbl>
References: 
 <5A76F6CE309AD049AAF9A039A3924282073D5B36@sc-mbx04.TheFacebook.com>
	<234843.11162.qm@web65504.mail.ac4.yahoo.com>
	<AANLkTi=gCTtwgGDns_zhsQookQCEj3nj7DRE+WpWZTBT@mail.gmail.com>
	<BLU147-DS155368D3023D1FBC6E25AEF5730@phx.gbl>
	<AANLkTinqgiMPkhCiY+7xbPXSv7EGu+vc5XCmSs_Jkbf3@mail.gmail.com>
	<BLU147-DS6C06CFCE89B5D87AFAEDEF5730@phx.gbl>
Date: Wed, 8 Sep 2010 22:03:55 -0700
Message-ID: <AANLkTinRU9Gf1TB0-SrEPOZ_41iThN2ZhtC_Az0sX7ZF@mail.gmail.com>
Subject: Re: how to remove dangling region and table?
From: Stack <stack@duboce.net>
To: user@hbase.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 =A0entries from .META. ? Is there a command or utilit=
y
> 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 exis=
ts.
>
> 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> wrot=
e:
>>>
>>> Hi,
>>> =A0I 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.
>>> =A0However, I found that some of the regions are not renamed to the tem=
p
>>> 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/regionserv=
er
>>> again. the regions just continue to hang there. and I can't create a
>>> table
>>> with the original name.
>>
>> Yes. =A0The table has mention in the .META. table. =A0You'll need to
>> delete the entries here as well as remove the table dir from hdfs.
>>
>> Or, just keep trying to disable. =A0It usually succeeds eventually.
>> Then do drop table.
>>
>>> =A0Is there any way I can remove the dangling region and then I can cre=
ate
>>> 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
>>
>