> "I can lost the data , how to create the table with no data ?" What's that mean? You can reset the whole cluster? Or just want to delete and re-create that table?
-----Original Message----- From: Jiajun Chen [mailto:[email protected]] Sent: Monday, May 07, 2012 10:24 PM To: [email protected] Subject: Re: terrible! I can't drop the table 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 > >> > > > >> > > >> > > >> > > >> > > > > > > > >-- > > > > --
