Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> how to drop a table forcefully?


+
hua beatls 2013-01-17, 09:23
+
Jean-Marc Spaggiari 2013-01-17, 11:38
+
hua beatls 2013-01-17, 12:15
+
Jean-Marc Spaggiari 2013-01-17, 12:21
+
hua beatls 2013-01-17, 12:46
+
Jean-Marc Spaggiari 2013-01-17, 13:40
Copy link to this message
-
Re: how to drop a table forcefully?
Hi JM,
    sorry, the table name is 'cdrtestsnappy' and 'cdrtestsnap'.
    i can see them from 'list'.
    hbase(main):001:0> list
TABLE

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/app/hbase/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/app/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
explanation.
cdrtest

cdrtest1

cdrtestGZ

cdrtestsnap

cdrtestsnappy

filelog

merge_bigtable

zlytest

zlytest1

9 row(s) in 0.6050 seconds
hbase(main):002:0>

    Many Thanks!
beatls
On Thu, Jan 17, 2013 at 9:40 PM, Jean-Marc Spaggiari <
[EMAIL PROTECTED]> wrote:

> Ok.
>
> So. You HBase system is inconsistent. And I can't see you table "
> t111" anywhere. On the shell, if you do a "list", which tables are you
> getting? I guess t111 will not be there. First thing to do is to fix
> that.
>
> Can you provide more logs from the hbase check? It might tell you what
> the issues are. You can past it on pastebin.com
>
> JM
>
> 2013/1/17, hua beatls <[EMAIL PROTECTED]>:
> > On Thu, Jan 17, 2013 at 8:21 PM, Jean-Marc Spaggiari <
> > [EMAIL PROTECTED]> wrote:
> >
> >> Hi,
> >>
> >        *below is snapshot of webui,* tabel 'cdrtestsnap' and
> > 'cdrtestsnappy' is on the list , as well as their regions.
> >
> >  cdrtestGZ <http://192.168.250.106:60010/table.jsp?name=cdrtestGZ>
> {NAME =>
> > 'cdrtestGZ', FAMILIES => [{NAME => 'cf', COMPRESSION => 'GZ',
> MIN_VERSIONS
> > => '0'}]}
> > cdrtestsnap<http://192.168.250.106:60010/table.jsp?name=cdrtestsnap>
> > {NAME
> > => 'cdrtestsnap', FAMILIES => [{NAME => 'cf', COMPRESSION => 'SNAPPY',
> > MIN_VERSIONS => '0'}]}
> > cdrtestsnappy<http://192.168.250.106:60010/table.jsp?name=cdrtestsnappy>
> > {NAME
> > => 'cdrtestsnappy', FAMILIES => [{NAME => 'cf', COMPRESSION => 'SNAPPY',
> > MIN_VERSIONS => '0'}]}
> >
> >      region information of table 'cdrtestsnap' show below:
> >       Table Attributes  Attribute Name Value Description Enabled true Is
> > the table enabled Compaction
> >
> > ------------------------------
> >
> > Actions:
> >
> >      Region Key (optional): This action will force a compaction of all
> > regions of the table, or, if a key is supplied, only the region
> containing
> > the given key.     Region Key (optional): This action will force a split
> of
> > all eligible regions of the table, or, if a key is supplied, only the
> > region containing the given key. An eligible region is one that does not
> > contain any references to other regions. Split requests for noneligible
> > regions will be ignored.
> >
> >
> >     *below is excerption  hbase hbck:*
> >      Summary:
> >   -ROOT- is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop2,60020,1358418770574
> >   .META. is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop2,60020,1358418770574
> >   cdrtest is okay.
> >     Number of regions: 122
> >     Deployed on:  hadoop3,60020,1358418770520
> >   cdrtest1 is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop3,60020,1358418770520
> >   cdrtestGZ is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop2,60020,1358418770574
> >   filelog is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop3,60020,1358418770520
> >   merge_bigtable is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop1,60020,1358418784993
> >   zlytest is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop1,60020,1358418784993
> >   zlytest1 is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop3,60020,1358418770520
> > 2 inconsistencies detected.
> > Status: INCONSISTENT
> > [hadoop@hadoop2 ~]$ d
> >
> >  *   these two table are in the transition state.*
> >     Regions in Transition  Region State
> > 89d3b8af7181ad8b857ef7f55c3abe46
> > cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
+
Jean-Marc Spaggiari 2013-01-17, 14:45
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB