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


+
hua beatls 2013-01-17, 09:23
+
Jean-Marc Spaggiari 2013-01-17, 11:38
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
> >
>
+
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
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