问题一:ERROR: Table already exists
使用hbase shell的命令list
查看的时候显示为空[],但是在创建表的时候出现
ERROR: Table already exists
后来查阅资料https://blog.csdn.net/huashao0602/article/details/77050929,得到解决办法:
1、通过./hbase zkcli命令进入zookeeper client模式
2、输入ls /hbase/table命令看到zombie table
3、使用rmr /hbase/table/TABLE_NAME命令删除zombie table
4、重启Hbase
使用
rmr /hbase/table/TABLE_NAME
(将TABLE_NAME替换为你需要删除的表名)命令删除上图中除了“hbase:meta”、“hbase:namespace”之外的表,例如:
WatchedEvent state:SyncConnected type:None path:null
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 0] ls /hbase/table
[StringMetaData, hbase:meta, HostApplicationMap_Ver2, hbase:namespace, Traces, ApplicationTraceIndex, ApplicationMapStatisticsCaller_Ver2, ApplicationMapStatisticsSelf_Ver2, ApplicationMapStatisticsCallee_Ver2, AgentStatV2, AgentLifeCycle, AgentStat, ApiMetaData, SqlMetaData_Ve r2, ApplicationIndex, TraceV2, AgentInfo, AgentEvent]
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 2] rmr /hbase/table/HostApplicationMap_Ver2
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 3] rmr /hbase/table/Traces
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 4] rmr /hbase/table/ApplicationTraceIndex
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 5] rmr /hbase/table/ApplicationMapStatisticsCaller_Ver2
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 6] rmr /hbase/table/ApplicationMapStatisticsSelf_Ver2
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 7] rmr /hbase/table/ApplicationMapStatisticsCallee_Ver2
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 8] rmr /hbase/table/AgentStatV2
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 9] rmr /hbase/table/AgentLifeCycle
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 10] rmr /hbase/table/AgentStat
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 11] rmr /hbase/table/ApiMetaData
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 12] rmr /hbase/table/ApplicationIndex
[zk: 192.168.2.131:2181,192.168.2.132:2181,192.168.2.133:2181(CONNECTED) 13] rmr /hbase/table/AgentInfo