It is possible to rename a table in Hbase, but it doesn't appear to be
recognized by Phoenix.

I use the approach documented for HBase:

disable 'MySchema.TABLE1'
snapshot 'MySchema.TABLE1', 'MySchema.TABLE1_SNAPSHOT'
clone_snapshot 'MySchema.TABLE1_SNAPSHOT', NewSchema.TABLE1'
delete_snapshot 'MySchema.TABLE1_SNAPSHOT'
#drop 'MySchema.TABLE1' - let's test before dropping

However, when testing this Phoenix doesn't seem to see the new cloned table
and there is nothing in the SYSTEM.CATALOG for it, even after restarting
the phoenix client.

Should this mechanism work in Phoenix or is there another way to rename or
clone an existing table?

Michael

Reply via email to