Jiajun Chen
2012-05-07, 13:14
Harsh J
2012-05-07, 13:18
Jiajun Chen
2012-05-07, 13:21
Jiajun Chen
2012-05-07, 13:28
Doug Meil
2012-05-07, 13:49
Tom Brown
2012-05-07, 14:01
Jiajun Chen
2012-05-07, 14:05
Doug Meil
2012-05-07, 14:19
Jiajun Chen
2012-05-07, 14:23
Bijieshan
2012-05-07, 14:29
Doug Meil
2012-05-07, 14:30
Jiajun Chen
2012-05-07, 14:34
Jiajun Chen
2012-05-07, 14:40
Jiajun Chen
2012-05-07, 14:57
Dave Wang
2012-05-07, 15:08
Jiajun Chen
2012-05-07, 15:11
Ey-Chih chow
2012-05-07, 17:42
Miguel Costa
2012-06-08, 15:00
Mike Wang
2012-06-26, 11:13
-
terrible! I can't drop the tableJiajun Chen 2012-05-07, 13:14
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 ?
the row with prefix cjjWaitHash in .META.
Now how can I drop the table cjjWaitHash ?
-
Re: terrible! I can't drop the tableHarsh J 2012-05-07, 13:18
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]> 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
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]> 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
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 13:21
I restarted the cluster but that has no effect . what else hava to delete?
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 13:28
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?
beacuse I can't drop the table ,so i did this not friendly .
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
there is no cjjWaitHash in list ouputs.
$ echo "scan '.META.'" | bin/hbase shell | grep cjjWaitHash
cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.
column=info:regioninfo, timestamp=1335522191107, value={NAME =>
'cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.', STARTKEY =>
'', ENDKEY => '', ENCODED => 4d0399bcdf15727b1cdf73abaec2e7f8,}
cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.
column=info:server, timestamp=1336106479410, valueslave188.uc.uuwatch.com:60020
cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.
column=info:serverstartcode, timestamp=1336106479410, value=1336106400066
strangely
On 7 May 2012 21:18, Harsh J <[EMAIL PROTECTED]> 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]> 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]*
folder and the meta entries. It does all those actions for you. Why
did you do it this way?
beacuse I can't drop the table ,so i did this not friendly .
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
there is no cjjWaitHash in list ouputs.
$ echo "scan '.META.'" | bin/hbase shell | grep cjjWaitHash
cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.
column=info:regioninfo, timestamp=1335522191107, value={NAME =>
'cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.', STARTKEY =>
'', ENDKEY => '', ENCODED => 4d0399bcdf15727b1cdf73abaec2e7f8,}
cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.
column=info:server, timestamp=1336106479410, valueslave188.uc.uuwatch.com:60020
cjjWaitHash,,1335522190862.4d0399bcdf15727b1cdf73abaec2e7f8.
column=info:serverstartcode, timestamp=1336106479410, value=1336106400066
strangely
On 7 May 2012 21:18, Harsh J <[EMAIL PROTECTED]> 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]> 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]*
-
Re: terrible! I can't drop the tableDoug Meil 2012-05-07, 13:49
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]> 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]> 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
>
-
Re: terrible! I can't drop the tableTom Brown 2012-05-07, 14:01
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
> >
>
>
>
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
> >
>
>
>
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 14:05
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]*
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]*
-
Re: terrible! I can't drop the tableDoug Meil 2012-05-07, 14:19
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]*
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 14:23
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
> >> > >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
> >--
> >
>
>
--
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
> >> > >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
> >--
> >
>
>
--
-
RE: terrible! I can't drop the tableBijieshan 2012-05-07, 14:29
> "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
> >> > >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
> >--
> >
>
>
--
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
> >> > >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
> >--
> >
>
>
--
-
Re: terrible! I can't drop the tableDoug Meil 2012-05-07, 14:30
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
>> >> > >
>> >> >
>> >> >
>> >> >
>> >>
>> >
>> >
>> >
>> >--
>> >
>>
>>
>--
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 14:34
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
> >> >> > >
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >> >
> >> >--
> >> >
> >>
> >>
> >--
>
>
>
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
> >> >> > >
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >> >
> >> >--
> >> >
> >>
> >>
> >--
>
>
>
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 14:40
just want to delete and re-create that table
On 7 May 2012 22:29, Bijieshan <[EMAIL PROTECTED]> wrote:
> > "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
> > >> > >
> > >> >
> > >> >
> > >> >
> > >>
> > >
> > >
> > >
> > >--
> > >
> >
> >
> --
>
**
On 7 May 2012 22:29, Bijieshan <[EMAIL PROTECTED]> wrote:
> > "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
> > >> > >
> > >> >
> > >> >
> > >> >
> > >>
> > >
> > >
> > >
> > >--
> > >
> >
> >
> --
>
**
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 14:57
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
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
-
Re: terrible! I can't drop the tableDave Wang 2012-05-07, 15:08
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:
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:
-
Re: terrible! I can't drop the tableJiajun Chen 2012-05-07, 15:11
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
陈加俊 项目经理
优讯时代（北京）���络技术有限公司
优讯网 www.uuwatch.com
地址：北京市海淀���上地五街7号昊海���厦207
电话：010-82895510
传真：010-82896636
手机：15110038983
电邮：*[EMAIL PROTECTED]*
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
陈加俊 项目经理
优讯时代（北京）���络技术有限公司
优讯网 www.uuwatch.com
地址：北京市海淀���上地五街7号昊海���厦207
电话：010-82895510
传真：010-82896636
手机：15110038983
电邮：*[EMAIL PROTECTED]*
-
Re: terrible! I can't drop the tableEy-Chih chow 2012-05-07, 17:42
If we use the class CleanFromMeta in http://www.mail-archive.com/[EMAIL PROTECTED]/msg06620.html to delete related entries in .META., will the corresponding znode for the table get automatically deleted? Thanks.
Ey-Chih Chow
On May 7, 2012, at 8:11 AM, Jiajun Chen wrote:
> 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
>>>
Ey-Chih Chow
On May 7, 2012, at 8:11 AM, Jiajun Chen wrote:
> 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
>>>
-
Re: terrible! I can't drop the tableMiguel Costa 2012-06-08, 15:00
Hi,
We had the same problem.
We solve it this way:
hbase zk_cli
-ls /hbase/tables
The table was still on Zookeeper.
Deleted the table from zookeeper (rmr).
Restart Hbase Masters, restart hbase region servers.
Miguel Costa
On 05/07/2012 06:42 PM, Ey-Chih chow wrote:
> If we use the class CleanFromMeta in http://www.mail-archive.com/[EMAIL PROTECTED]/msg06620.html to delete related entries in .META., will the corresponding znode for the table get automatically deleted? Thanks.
>
> Ey-Chih Chow
>
>
> On May 7, 2012, at 8:11 AM, Jiajun Chen wrote:
>
>> 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
We had the same problem.
We solve it this way:
hbase zk_cli
-ls /hbase/tables
The table was still on Zookeeper.
Deleted the table from zookeeper (rmr).
Restart Hbase Masters, restart hbase region servers.
Miguel Costa
On 05/07/2012 06:42 PM, Ey-Chih chow wrote:
> If we use the class CleanFromMeta in http://www.mail-archive.com/[EMAIL PROTECTED]/msg06620.html to delete related entries in .META., will the corresponding znode for the table get automatically deleted? Thanks.
>
> Ey-Chih Chow
>
>
> On May 7, 2012, at 8:11 AM, Jiajun Chen wrote:
>
>> 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
-
Re: terrible! I can't drop the tableMike Wang 2012-06-26, 11:13
works for me, thanks
