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

Store data for immutable tables in single KeyValue

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.10.0
    • Labels:
      None

      Description

      Since an immutable table (i.e. declared with IMMUTABLE_ROWS=true) will never update a column value, it'd be more efficient to store all column values for a row in a single KeyValue. We could use the existing format we have for variable length arrays.

      For backward compatibility, we'd need to support the current mechanism. Also, you'd no longer be allowed to transition an existing table to/from being immutable. I think the best approach would be to introduce a new IMMUTABLE keyword and use it like this:

      CREATE IMMUTABLE TABLE ...
      

        Attachments

        1. PHOENIX-2565-v2.patch
          93 kB
          Thomas D'Silva
        2. PHOENIX-2565.patch
          100 kB
          Thomas D'Silva
        3. PHOENIX-2565-wip.patch
          113 kB
          Thomas D'Silva

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                tdsilva Thomas D'Silva
                Reporter:
                jamestaylor James Taylor
              • Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: