Hello Phoenix Users,
I am new to Apache Phoenix - so please excuse me if the questions are
naive. The moment I installed phoenix, I found a few HBase Tables getting
created under the ‘default’ namespace. Phoenix thinks that they are in the
‘system’ namespace
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+-----------------+------------+-------------+----------------+----------------------+
| 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_STATEMENT | VIEW_TYPE | INDEX_TYPE | TRANSACTIONAL |
IS_NAMESPACE_MAPPED |
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+-----------------+------------+-------------+----------------+----------------------+
| | SYSTEM | CATALOG | SYSTEM TABLE | |
| | |
| false | null | false |
| | | false | false |
| | SYSTEM | FUNCTION | SYSTEM TABLE | |
| | |
| false | null | false |
| | | false | false |
| | SYSTEM | SEQUENCE | SYSTEM TABLE | |
| | |
| false | null | false |
| | | false | false |
| | SYSTEM | STATS | SYSTEM TABLE | |
| | |
| false | null | false |
| | | false | false |
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+-----------------+------------+-------------+----------------+----------------------+
I also see a couple of namespace related configurations here
<https://github.com/apache/phoenix/blob/83e56f45bf6394ce6e7e29edc9edea750a9ced5c/phoenix-core/src/main/java/org/apache/phoenix/query/QueryServices.java#L54-L55>
that appear to map “system” phoenix schema to “system” HBase namespace. I
really don’t like the “SYSTEM” for a namespace name and I would like to
change it to phoenix - that is, I want all the above auto-generated system
tables to be created under phoenix namespace on HBase. Could someone throw
light on whether such custom schema name for system table is possible?
Thanks,
Karthick
