[jira] [Created] (PHOENIX-6247) Change SYSTEM.CATALOG to allow separation of physical name (Hbase name) from logical name (Phoenix name)

["Gokcen Iskender (Jira)" <ji...@apache.org>]

Gokcen Iskender created PHOENIX-6247:
----------------------------------------

             Summary: Change SYSTEM.CATALOG to allow separation of physical name (Hbase name) from logical name (Phoenix name)
                 Key: PHOENIX-6247
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6247
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Gokcen Iskender


Currently, the tables in Phoenix have the same name as the underlying Hbase table. Separating logical and physical table name, ie. Having a Phoenix table point to an Hbase table with a different name have some advantages. 

An example is this: Let's say we want to have a different storage/encoding scheme for an index. We can build the new index while the clients use the old index and once the index is rebuilt, we can momentarily start pointing to the new index table without much downtime or performance implications. For the client, they are using the same index with the same name, but the physical table is different. Today, in order to change the index like this, we have to drop it and re-create which is a downtime for the index and the data table full scans are used for queries impacting performance while the index creation goes on.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)