Renaming Phoenix table

["김영우 (YoungWoo Kim)" <yw...@apache.org>]

Hi,

AFAIK, As of now Phoenix does not support renaming table out of the box.
but I have a use case like that. I have table 'TBL' and 'TBL_NEW' and I
would like to rename TBL to TBL_OLD and then, rename TBL_NEW to TBL.
somehow the TBL table should be retired from our Phoenix and also It's hard
to modify the queries from our applications for now. i.e, replace the table
TBL with TBL_NEW

Just curious, Renaming table on HBase side would useful for this?

Any help would be appreciated.

Thanks,
Youngwoo

Re: Renaming Phoenix table

["김영우 (Youngwoo Kim)" <wa...@gmail.com>]

Thanks James!

I would try that when I have some spare cycles

- Youngwoo



On Fri, Jan 6, 2017 at 4:00 AM, James Taylor <ja...@apache.org> wrote:

> Hi Youngwoo,
>
> Correct - no support for renaming a table in Phoenix currently
> (see PHOENIX-2341). Apparently, you can use the HBase snapshot feature to
> rename tables[1]. Using that technique, you could potentially surface this
> in Phoenix and add the logic required to update the SYSTEM.CATALOG as
> necessary. If you're interested in contributing this, I can comment on the
> JIRA in more detail about what would be required.
>
> Thanks,
> James
>
> [1]
> http://stackoverflow.com/questions/27966072/how-do-you-
> rename-a-table-in-hbase
>
> On Thu, Jan 5, 2017 at 6:03 AM, 김영우 (YoungWoo Kim) <yw...@apache.org>
> wrote:
>
> > Hi,
> >
> > AFAIK, As of now Phoenix does not support renaming table out of the box.
> > but I have a use case like that. I have table 'TBL' and 'TBL_NEW' and I
> > would like to rename TBL to TBL_OLD and then, rename TBL_NEW to TBL.
> > somehow the TBL table should be retired from our Phoenix and also It's
> hard
> > to modify the queries from our applications for now. i.e, replace the
> table
> > TBL with TBL_NEW
> >
> > Just curious, Renaming table on HBase side would useful for this?
> >
> > Any help would be appreciated.
> >
> > Thanks,
> > Youngwoo
> >
>

Re: Renaming Phoenix table

[James Taylor <ja...@apache.org>]

Hi Youngwoo,

Correct - no support for renaming a table in Phoenix currently
(see PHOENIX-2341). Apparently, you can use the HBase snapshot feature to
rename tables[1]. Using that technique, you could potentially surface this
in Phoenix and add the logic required to update the SYSTEM.CATALOG as
necessary. If you're interested in contributing this, I can comment on the
JIRA in more detail about what would be required.

Thanks,
James

[1]
http://stackoverflow.com/questions/27966072/how-do-you-rename-a-table-in-hbase

On Thu, Jan 5, 2017 at 6:03 AM, 김영우 (YoungWoo Kim) <yw...@apache.org> wrote:

> Hi,
>
> AFAIK, As of now Phoenix does not support renaming table out of the box.
> but I have a use case like that. I have table 'TBL' and 'TBL_NEW' and I
> would like to rename TBL to TBL_OLD and then, rename TBL_NEW to TBL.
> somehow the TBL table should be retired from our Phoenix and also It's hard
> to modify the queries from our applications for now. i.e, replace the table
> TBL with TBL_NEW
>
> Just curious, Renaming table on HBase side would useful for this?
>
> Any help would be appreciated.
>
> Thanks,
> Youngwoo
>