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 Threaded View
HBase >> mail # user >> how to drop a table forcefully?


Copy link to this message
-
how to drop a table forcefully?
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
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