zepplelin 连接 phoenix 时,Phoenix 启动报错:
Error: ERROR 726 (43M10): Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled (state=43M10,code=726)
解决办法:
1、先将hbase和phoenix conf目录下的hbase-site.xml中关于命名空间启用的设置为 false。
<property>
<name>phoenix.schema.isNamespaceMappingEnabled</name>
<value>false</value>
</property>
<property>
<name>phoenix.schema.mapSystemTablesToNamespace</name>
<value>false</value>
</property>
2、将其他节点的 hbase-site.xml 都修改配置
3、重启hbase,进入hbase shell
4、修改hbase中表 SYSTEM:CATALOG 名为 SYSTEM.CATALOG
-
disable 'SYSTEM:CATALOG'
-
snapshot 'SYSTEM:CATALOG', 'cata_tableSnapshot'
-
clone_snapshot 'cata_tableSnapshot', 'SYSTEM.CATALOG'
-
drop 'SYSTEM:CATALOG'
5、重启phoenix
6、查看数据库中有哪些表
select distinct("TABLE_NAME") FROM SYSTEM.CATALOG