hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stuti Awasthi <stutiawas...@hcl.com>
Subject RE: Not able to remove entries from .META. table
Date Fri, 14 Oct 2011 12:42:56 GMT
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:dejan.menges@gmail.com] 
Sent: Friday, October 14, 2011 6:00 PM
To: user@hbase.apache.org
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 <harsh@cloudera.com> 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.
> >
> >
> ----------------------------------------------------------------------
> -------------------------------------------------
>
>

Mime
View raw message