Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase, mail # user - how to drop a table forcefully?


Copy link to this message
-
Re: how to drop a table forcefully?
Jean-Marc Spaggiari 2013-01-17, 14:45
OK, sorry. From the example you sent I tought it cas t111.

Did you get a chance to past on pastebin the entire output for the
hbase check? Not just the summary, but everything, to see what issue
it's reporting.

JM

2013/1/17, hua beatls <[EMAIL PROTECTED]>:
> 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