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 <[email protected]> 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" <[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 >> >
