1删除Phoenix上的映射表,demo是我的表名
DELETE from SYSTEM.CATALOG where TABLE_NAME ='demo';
2删除hbase中phoenix的表描述
打开hbase shell,依次执行以下命令:
disable 'demo'
alter 'demo',METHOD=>'table_att_unset',NAME=>'coprocessor$1'
alter 'demo',METHOD=>'table_att_unset',NAME=>'coprocessor$2'
alter 'demo',METHOD=>'table_att_unset',NAME=>'coprocessor$3'
alter 'demo',METHOD=>'table_att_unset',NAME=>'coprocessor$4'
alter 'demo',METHOD=>'table_att_unset',NAME=>'coprocessor$5'
enable 'demo'
3这样就可以在phoenix中重新创建该表了。