phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From KARTHICK Duraisamy Soundararaj <ksoundara...@groupon.com>
Subject Custom schema name for system table?
Date Fri, 02 Dec 2016 23:47:14 GMT
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

Mime
View raw message