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) <[email protected]> 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 >
