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?
Hi,
   the file system is ok.

    any other idea?

beatls

On Thu, Jan 17, 2013 at 7:38 PM, Jean-Marc Spaggiari <
[EMAIL PROTECTED]> wrote:

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