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 >> terrible! I can't drop the table


Copy link to this message
-
Re: terrible! I can't drop the table

This is why Harsh was suggesting that you look at what is in META for that
table.  Those records have to get cleaned out of META because HBase thinks
that table still exists.

On 5/7/12 10:23 AM, "Jiajun Chen" <[EMAIL PROTECTED]> wrote:

>I can lost the data , how to create the table with no data ?
>
>On 7 May 2012 22:19, Doug Meil <[EMAIL PROTECTED]> wrote:
>
>>
>> Because you did this... "hadoop fs -rmr /hbase/cjjWaitHash"
>>
>> ... your data is gone.
>>
>> Per...
>>
>> http://hbase.apache.org/book.html#trouble.namenode
>>
>>
>> ... that's where StoreFiles are kept for that particular table.
>>
>>
>> On 5/7/12 10:05 AM, "Jiajun Chen" <[EMAIL PROTECTED]> wrote:
>>
>> > which temp directory ?
>> > lose the data of all tables ?
>> >
>> >On 7 May 2012 22:01, Tom Brown <[EMAIL PROTECTED]> wrote:
>> >
>> >> I made a very similar mistake myself the other day when trying to
>>reset
>> >>my
>> >> cluster.  What finally solved it was deleting the temp directory used
>> >>by my
>> >> data nodes (in my case I wanted to loose all my data, so it was ok to
>> >> delete everything... In your case, you may have to figure out how to
>> >>export
>> >> some data first, as I don't know exactly what effect deleting that
>>temp
>> >> directory will have)
>> >>
>> >> Good luck!
>> >>
>> >> --Tom
>> >>
>> >> On Monday, May 7, 2012, Doug Meil wrote:
>> >>
>> >> >
>> >> > Harsh pretty much summed it up already (e.g., "don't do that") but
>> >>below
>> >> > is some further reading of what just happened...
>> >> >
>> >> > http://hbase.apache.org/book.html#arch.catalog
>> >> > http://hbase.apache.org/book.html#trouble.namenode
>> >> >
>> >> > ... META is just an HBase table under the covers. By deleting the
>> >>table
>> >> on
>> >> > the HDFS filesystem, it did nothing with the table metadata in
>>META.
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > On 5/7/12 9:18 AM, "Harsh J" <[EMAIL PROTECTED] <javascript:;>>
>> >>wrote:
>> >> >
>> >> > >The drop is what you ought to have done first, before removing
>>the FS
>> >> > >folder and the meta entries. It does all those actions for you.
>>Why
>> >> > >did you do it this way?
>> >> > >
>> >> > >Do you see the table still appearing in the list outputs? Can you
>> >> > >provide us a paste bin link of:
>> >> > >
>> >> > >echo "scan '.META.'" | hbase shell | grep cjjWaitHash
>> >> > >
>> >> > >On Mon, May 7, 2012 at 6:44 PM, Jiajun Chen <[EMAIL PROTECTED]
>> >> <javascript:;>>
>> >> > wrote:
>> >> > >> I deleted the folder use bin/hadoop fs -rmr /hbase/cjjWaitHash
>>,and
>> >> > >>deleted
>> >> > >> the row with prefix cjjWaitHash in .META.
>> >> > >> Now how can I drop the table cjjWaitHash ?
>> >> > >
>> >> > >
>> >> > >
>> >> > >--
>> >> > >Harsh J
>> >> > >
>> >> >
>> >> >
>> >> >
>> >>
>> >
>> >
>> >
>> >--
>> >
>>
>>
>--
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