需求:在phoenix中将表名TABLE1,改为表名TABLE2
步鄹:
1)phoenix建立表名TABLE1
2)Hbase中修改表名TABLE1为TABLE2
3)phoenix建立表名TABLE2(格式同TABLE1)
4)查询phoenix中TABLE2
注意:表结构一定要一样,要不然会导致数据错误
DROP TABLE TABLE2;
CREATE TABLE TABLE1 (ID VARCHAR NOT NULL PRIMARY KEY, COL1 VARCHAR) ;
UPSERT INTO TABLE1 VALUES('1','new');
UPSERT INTO TABLE1 VALUES('2','test_row_2');
hbase shell> disable 'TABLE1'
hbase shell> snapshot 'TABLE1', 'TABLE_TEST'
hbase shell> clone_snapshot 'TABLE_TEST', 'TABLE2'
hbase shell> delete_snapshot 'TABLE_TEST'
hbase shell> drop 'TABLE1'