[jira] [Created] (PHOENIX-4596) Add SINGLE_CELL_PER_LEVEL to ensure denseness with hierarchies of views

["James Taylor (JIRA)" <ji...@apache.org>]

James Taylor created PHOENIX-4596:
-------------------------------------

             Summary: Add SINGLE_CELL_PER_LEVEL to ensure denseness with hierarchies of views
                 Key: PHOENIX-4596
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4596
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: James Taylor


Currently we store the col qualifier counter at the physical table level. If we stored it at the view level then the array would be dense. We didn't do this initially because we wouldn't be able to handle adding a new column to the base table (unless we preallocated a fixed number of columns and started the view counters at this number). 
We could solve this issue if we stored column values for each level of the hierarchy in its own cell. The base table column values would be stored in a single cell. Views would store their columns in a separate cell, grand child-views in their own cell and so on. 
We could also do this only when a column is added to the base table (or a view), then store that column value (and any further columns that are added) in its own cell. We start the column qualifier counter at each level at the number of cols in the parent +1.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)