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
hi,
       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
[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.
^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'
DESCRIPTION
ENABLED
 {NAME => 't111', FAMILIES => [{NAME => 'CF111', BLOOMFILTER => 'NONE',
REPLICATION_SCOPE => '0', VERSIONS
true
 => '3', COMPRESSION => 'SNAPPY', MIN_VERSIONS => '0', TTL => '2147483647',
BLOCKSIZE => '65536',
IN_MEMORY
  => 'false', BLOCKCACHE =>
'true'}]}

1 row(s) in 0.0470 seconds
    3rd,  but this table is in the 'transition' state, and remains in this
state.
    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.

beatls
+
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