我跟着https://phoenix.apache.org/namspace_mapping.html 待办事项
套 phoenix.schema.isNamespaceMappingEnabled
在hbase-site.xml中启用
当我使用 ./psql.py node1:2181 -m 'loh'.'traffic'
迁移。
获取错误
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=LOH.TRAFFIC
at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:71)
at org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.java:583)
at org.apache.phoenix.util.PhoenixRuntime.getTable(PhoenixRuntime.java:449)
at org.apache.phoenix.util.UpgradeUtil.upgradeTable(UpgradeUtil.java:1823)
at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:264)
"loh:traffic在hbase中存在,为什么找不到表?为什么不能像系统名称空间那样自动创建表和获取数据。
hbase(main):005:0> list
TABLE
SYSTEM:CATALOG
SYSTEM:FUNCTION
SYSTEM:LOG
SYSTEM:MUTEX
SYSTEM:SEQUENCE
SYSTEM:STATS
loh:traffic
7 row(s)
Took 0.5282 seconds
=> ["SYSTEM:CATALOG", "SYSTEM:FUNCTION", "SYSTEM:LOG", "SYSTEM:MUTEX", "SYSTEM:SEQUENCE", "SYSTEM:STATS", "loh:traffic"]
Phoenix
0: jdbc:phoenix:node1:2181> !tables
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+--------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION | INDEX_STATE | IMMUTABLE_ROWS | SALT_BUCKETS | MULTI_TENANT | VIEW_S |
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+--------+
| | SYSTEM | CATALOG | SYSTEM TABLE | | | | | | false | null | false | |
| | SYSTEM | FUNCTION | SYSTEM TABLE | | | | | | false | null | false | |
| | SYSTEM | LOG | SYSTEM TABLE | | | | | | true | 32 | false | |
| | SYSTEM | SEQUENCE | SYSTEM TABLE | | | | | | false | null | false | |
| | SYSTEM | STATS | SYSTEM TABLE | | | | | | false | null | false | |
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+--------+
暂无答案!
目前还没有任何答案,快来回答吧!