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?


+
hua beatls 2013-01-17, 09:23
Copy link to this message
-
Re: how to drop a table forcefully?
Jean-Marc Spaggiari 2013-01-17, 11:38
Hi Beat,

Have you tried to check the filesystem using fsck to see if there is
no inconsistencies?

JM

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