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

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

Copy link to this message
how to drop a table forcefully?
hua beatls 2013-01-17, 09:23
       A table mistakenly created cannot be dropped?
       first we create it  with 'hbase shell', below:
       [hadoop@hadoop3 ~]$
[hadoop@hadoop3 ~]$ hbase shell
13/01/17 15:49:35 WARN conf.Configuration: hadoop.native.lib is deprecated.
Instead, use io.native.lib.available
HBase Shell; enter 'help<RETURN>' for list of supported commands.
Type "exit<RETURN>" to leave the HBase Shell
Version 0.92.1-cdh4.1.2, r, Thu Nov  1 17:54:35 PDT 2012
hbase(main):001:0> create 't111',{NAME=>'CF111',COMPRESSION=>'snappy'}
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
SLF4J: Found binding in
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
^C[hadoop@hadoop3 ~]$
  (this command hang after i issue "ctrl-c". (please be noted that 'snappy'
is not installed/config in this hbase.)
   second,  we 'describe' this table, below,
 hbase(main):003:0> describe 't111'
 {NAME => 't111', FAMILIES => [{NAME => 'CF111', BLOOMFILTER => 'NONE',
 => '3', COMPRESSION => 'SNAPPY', MIN_VERSIONS => '0', TTL => '2147483647',
BLOCKSIZE => '65536',
  => 'false', BLOCKCACHE =>

1 row(s) in 0.0470 seconds
    3rd,  but this table is in the 'transition' state, and remains in this
    4th,  i want to 'drop' this table, but 'drop'  hang and failed.
   hbase(main):002:0> disable 't111'
0 row(s) in 1.1560 seconds
hbase(main):005:0> drop 't111'

 'drop' is hang until i 'ctrl-c'.

    is there any other way to drop this table forcefully?
Beat R.

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
hua beatls 2013-01-17, 14:42
Jean-Marc Spaggiari 2013-01-17, 14:45