Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6247

Change SYSTEM.CATALOG to allow separation of physical name (Hbase name) from logical name (Phoenix name)

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 4.17.0, 5.2.0
    • None
    • None

    Description

      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.

      Attachments

        1. PHOENIX-6247.master.merged.patch
          232 kB
          Gokcen Iskender
        2. PHOENIX-6247-4.x-merged.patch
          232 kB
          Gokcen Iskender

        Activity

          People

            giskender Gokcen Iskender
            giskender Gokcen Iskender
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: