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
+
Jean-Marc Spaggiari 2013-01-17, 11:38
+
hua beatls 2013-01-17, 12:15
Copy link to this message
-
Re: how to drop a table forcefully?
Hi,

What do you mean by "the file system is ok"? Have you run both the
HBase and the Hadoop checks and both of them aren't returning any
error?

Also, what do you have on the webui? Can yo usee the table? The regions?

When you are trying to delete the table, what do you havae on you
master logs? Can you share this log?

Thanks,

JM

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