将具有命名空间的现有hbase表迁移到phoenix

krcsximq  于 2021-06-07  发布在  Hbase
关注(0)|答案(0)|浏览(322)

我跟着https://phoenix.apache.org/namspace_mapping.html 待办事项
phoenix.schema.isNamespaceMappingEnabled 在hbase-site.xml中启用
当我使用 ./psql.py node1:2181 -m 'loh'.'traffic' 迁移。
获取错误

  1. org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=LOH.TRAFFIC
  2. at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:71)
  3. at org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.java:583)
  4. at org.apache.phoenix.util.PhoenixRuntime.getTable(PhoenixRuntime.java:449)
  5. at org.apache.phoenix.util.UpgradeUtil.upgradeTable(UpgradeUtil.java:1823)
  6. at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:264)

"loh:traffic在hbase中存在,为什么找不到表?为什么不能像系统名称空间那样自动创建表和获取数据。

  1. hbase(main):005:0> list
  2. TABLE
  3. SYSTEM:CATALOG
  4. SYSTEM:FUNCTION
  5. SYSTEM:LOG
  6. SYSTEM:MUTEX
  7. SYSTEM:SEQUENCE
  8. SYSTEM:STATS
  9. loh:traffic
  10. 7 row(s)
  11. Took 0.5282 seconds
  12. => ["SYSTEM:CATALOG", "SYSTEM:FUNCTION", "SYSTEM:LOG", "SYSTEM:MUTEX", "SYSTEM:SEQUENCE", "SYSTEM:STATS", "loh:traffic"]

Phoenix

  1. 0: jdbc:phoenix:node1:2181> !tables
  2. +------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+--------+
  3. | 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 |
  4. +------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+--------+
  5. | | SYSTEM | CATALOG | SYSTEM TABLE | | | | | | false | null | false | |
  6. | | SYSTEM | FUNCTION | SYSTEM TABLE | | | | | | false | null | false | |
  7. | | SYSTEM | LOG | SYSTEM TABLE | | | | | | true | 32 | false | |
  8. | | SYSTEM | SEQUENCE | SYSTEM TABLE | | | | | | false | null | false | |
  9. | | SYSTEM | STATS | SYSTEM TABLE | | | | | | false | null | false | |
  10. +------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+--------+

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题