Stuti, Sorry for the late reply, but Jon's second comment about deletall usage is right. It would not work with a specific column "info:regioninfo", but rather with just family name "info".
On 18-Oct-2011, at 9:45 AM, Stuti Awasthi wrote: > Hi Jon, > > Thanks for the pointers. I figured out that in my case bad table created some > missing and under replicated blocks in HDFS which was causing the problem. > Once I removed those under replicated blocks from HDFS and retried to delete > the entries from .META. table , I was successful. > > Stuti > > -----Original Message----- > From: Jonathan Hsieh [mailto:[email protected]] > Sent: Monday, October 17, 2011 11:06 PM > To: [email protected] > Subject: Re: Not able to remove entries from .META. table > > Stuti, > > I've in the process of completing a offline meta rebuilder. An early version > is here: https://issues.apache.org/jira/browse/HBASE-4377 > > It assumes that your file system data is good, so using it would require > "sidelining" or deleting the regions from the bad table. > > Jon. > > > On Fri, Oct 14, 2011 at 5:42 AM, Stuti Awasthi <[email protected]> wrote: > >> Hi Harsh, >> >> I check the entries by the 'get' command : >> >> hbase(main):001:0> get >> '.META.','system_mappings,,1318585995582.bded23240ed1a28c2b80ece0cbfb73b8.','info' >> COLUMN CELL >> info:regioninfo timestamp=1318606241130, value=REGION => >> {NAME => 'system_mappings,,1318585995582.bded23240ed1a28c2 >> b80ece0cbfb73b8.', STARTKEY => >> '', ENDKEY => '', ENCODED => bded23240ed1a28c2b80ece0cbfb73b8, TABLE >> => {{NAME => 'system_mappings', >> FAMILIES => [{NAME => 'f1', BLOOMFILTER => 'NONE', REPLICATION_SCO >> PE => '0', COMPRESSION => >> 'NONE', VERSIONS => '1', TTL => '2147483647', BLOCKSIZE => '65536', IN_ME >> MORY => 'false', BLOCKCACHE => >> 'true'}]}} >> info:server timestamp=1318606241185, >> value=slave2:60020 >> info:serverstartcode timestamp=1318606241185, value=1316689293206 >> 3 row(s) in 0.3520 seconds >> >> I tried 'deleteall' command : >> hbase(main):002:0> deleteall >> '.META.','system_mappings,,1318585995582.bded23240ed1a28c2b80ece0cbfb73b8.','info' >> 0 row(s) in 0.0120 seconds >> >> Again 'get' command output : >> hbase(main):003:0> get >> '.META.','system_mappings,,1318585995582.bded23240ed1a28c2b80ece0cbfb73b8.','info' >> COLUMN CELL >> info:regioninfo timestamp=1318606241130, value=REGION => >> {NAME => 'system_mappings,,1318585995582.bded23240ed1a28c2 >> b80ece0cbfb73b8.', STARTKEY >> => '', ENDKEY => '', ENCODED => bded23240ed1a28c2b80ece0cbfb73b8, TABLE >> => {{NAME => >> 'system_mappings', FAMILIES => [{NAME => 'f1', BLOOMFILTER => 'NONE', >> REPLICATION_SCO >> PE => '0', COMPRESSION => >> 'NONE', VERSIONS => '1', TTL => '2147483647', BLOCKSIZE => '65536', IN_ME >> MORY => 'false', >> BLOCKCACHE => 'true'}]}} >> info:server timestamp=1318606241185, >> value=slave2:60020 >> info:serverstartcode timestamp=1318606241185, >> value=1316689293206 >> 3 row(s) in 0.0130 seconds >> >> >> -----Original Message----- >> From: Dejan Menges [mailto:[email protected]] >> Sent: Friday, October 14, 2011 6:00 PM >> To: [email protected] >> Subject: Re: Not able to remove entries from .META. table >> >> Or you can format your namenode and prior to that manually clean your >> folders hosting HDFS data. >> >> On Fri, Oct 14, 2011 at 2:27 PM, Harsh J <[email protected]> wrote: >> >>> Stuti, >>> >>> What was your deleteall command for deleting the .META. entry exactly? >>> You generally have to pass the whole region ID string to it to >>> remove the entry properly. If you can provide the entry from your >>> .META., I can churn out the exact command you're required to run to >>> properly remove >> away the entry. >>> >>> On 14-Oct-2011, at 5:35 PM, Stuti Awasthi wrote: >>> >>>> Hi, >>>> I am stuck in a problem that I created some table which was not >>>> created >>> properly. Its entries are added in .Meta. table but the regions are >>> offline so I wanted to delete the table. >>>> I tried to first delete table with 'disable' and 'drop ' commands >>>> but the >>> table is not deleted. >>>> Then I tried to remove the rows entry containing corrupt table >>>> name from >>> .META. table using 'delete', 'deleteall' utilities but the row >>> entries are not getting deleted. >>>> >>>> I also found out that when I 'list' the tables , it shows me the >>>> corrupt >>> table but in HDFS , there is no directory created with corrupt table >> name. >>>> >>>> I tried this again by restarting the Hbase server but same issue. >>>> I am >>> able to access all other tables properly. >>>> >>>> Please help >>>> >>>> >>>> ::DISCLAIMER:: >>>> >>> -------------------------------------------------------------------- >>> -- >>> ------------------------------------------------- >>>> >>>> The contents of this e-mail and any attachment(s) are confidential >>>> and >>> intended for the named recipient(s) only. >>>> It shall not attach any liability on the originator or HCL or its >>> affiliates. Any views or opinions presented in >>>> this email are solely those of the author and may not necessarily >>>> reflect >>> the opinions of HCL or its affiliates. >>>> Any form of reproduction, dissemination, copying, disclosure, >>> modification, distribution and / or publication of >>>> this message without the prior written consent of the author of >>>> this >>> e-mail is strictly prohibited. If you have >>>> received this email in error please delete it and notify the >>>> sender >>> immediately. Before opening any mail and >>>> attachments please check them for viruses and defect. >>>> >>>> >>> -------------------------------------------------------------------- >>> -- >>> ------------------------------------------------- >>> >>> >> > > > > -- > // Jonathan Hsieh (shay) > // Software Engineer, Cloudera > // [email protected]
