hbase原表和索引表的表名修改方式是一样的,现在只列出索引表修改方法:
我的旧索引表表名:
修改步骤:
1.hbase(main):017:0>先disable表
disable 'index_device_data_test02'
Took 0.7407 seconds
2.hbase(main):018:0>创建一个快照
snapshot 'index_device_data_test02','index_device_data_test02Snapshot'
Took 0.2878 seconds
3.hbase(main):019:0>克隆快照,赋值给新的表名idx_spc_test02
clone_snapshot 'index_device_data_test02Snapshot','idx_spc_test02'
Took 0.7449 seconds
4.hbase(main):020:0>删除克隆快照
delete_snapshot 'index_device_data_test02Snapshot'
Took 0.0273 seconds
5.hbase(main):021:0>再删除旧表
drop 'index_device_data_test02'
Took 0.2536 seconds
list查看,看见新的表名:
最后再更改phoenix映射表的索引表:
步骤是:
1.删除旧索引表:
drop index "index_device_data_test02" on "device_data_test02";
2.创建新的索引表
CREATE INDEX "idx_spc_test01" ON "device_data_test01"("data"."modelID","data"."deviceID","data"."deviceTime","data"."processState")INCLUDE("data"."subDevice","data"."1","data"."abc1234567");
OK!