Yeah ! delete the znode for that table and restart the cluster then create it successfully !
On 7 May 2012 23:08, Dave Wang <[email protected]> wrote: > You may need to edit your ZK nodes. Depending on what version of HBase you > are running, you may need to either create or delete the znode for that > table. > > - Dave > > On Mon, May 7, 2012 at 7:57 AM, Jiajun Chen <[email protected]> wrote: > > > I deleted all rows of cjjWaitHash in .META. used deleteall in shell ,and > > output nothing after echo "scan '.META.'" | hbase shell | grep > cjjWaitHash > > . > > > > but why ? > > > > > count 'cjjWaitHash' > > ERROR: Unknown table cjjWaitHash! > > > > > enable 'cjjWaitHash' > > ERROR: Table cjjWaitHash does not exist.' > > > > > disable 'cjjWaitHash' > > ERROR: Table cjjWaitHash does not exist.' > > > > > create 'cjjWaitHash',{NAME => 'c',COMPRESSION =>'LZO', VERSIONS => '1'} > > ERROR: Table already exists: cjjWaitHash! > > > > > > On 7 May 2012 22:34, Jiajun Chen <[email protected]> wrote: > > > > > But I can't find the key contains cjjWaitHash use the following code: > > > > > > public void printMETA() throws IOException > > > { > > > final HTable table = MyHBaseConfiguration.getTable(".META."); > > > final Scan scan = new Scan(); > > > final ResultScanner scanner = table.getScanner(scan); > > > > > > while (true) > > > { > > > final Result next = scanner.next(); > > > if (null == next) > > > { > > > > > > return; > > > } > > > final String row = Bytes.toString(next.getRow()); > > > if (row.contains("cjjWaitHash")) > > > { > > > System.err.println(row); > > > } > > > System.out.println(row); > > > > > > } > > > } > > > > > > On 7 May 2012 22:30, Doug Meil <[email protected]> wrote: > > > > > >> > > >> 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 > > >> >> >> > > > > >> >> >> > > > >> >> >> > > > >> >> >> > > > >> >> >> > > >> >> > > > >> >> > > > >> >> > > > >> >> >-- > > >> >> > > > >> >> > > >> >> > > >> >-- > > >> > > >> > > >> > > > > > > -- 陈加俊 项目经理 优讯时代（北京）网络技术有限公司 优讯网 www.uuwatch.com 地址：北京市海淀区上地五街7号昊海大厦207 电话：010-82895510 传真：010-82896636 手机：15110038983 电邮：*[email protected]*
