phoenix table metadata in a bad state

[yixuan geng <ge...@soulgame.com>]

Hi all,

I am now facing an issue with phoenix table metadata. What happened is I
created some table/index using phoenix, and then someone else dropped these
tables directly in hbase.  So now it leaves some phoenix table metadata in
a bad state.

Could you please suggest how can I remove the stale metadata?

Thanks,
yixuan

Re: phoenix table metadata in a bad state

[anil gupta <an...@gmail.com>]

Hi Yixuan,

You need to manually remove all the coprocessors that Phoenix adds to each
HBase table.
After doing above step, just restart HBase and login to phoenix, it will
recreate both the metadata tables. And then you can redefine you tables in
Phoenix.

I have done this on my setup of Phoenix3.0.0 and it works nicely. But,
please try this at your own risk.

Thanks,
Anil Gupta


On Thu, May 8, 2014 at 10:14 PM, yixuan geng <ge...@soulgame.com> wrote:

> Hi all,
>
> I am now facing an issue with phoenix table metadata. What happened is I
> created some table/index using phoenix, and then someone else dropped these
> tables directly in hbase.  So now it leaves some phoenix table metadata in
> a bad state.
>
> Could you please suggest how can I remove the stale metadata?
>
> Thanks,
> yixuan
>



-- 
Thanks & Regards,
Anil Gupta