Stuti, Is there a reason why you don't just delete the entire row? (why specify the column family?)
deleteall '.META.','system_mappings,,1318585995582.bded23240ed1a28c2b80ece0cbfb73b8.' 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]
