Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
Today we store the column qualifier counters at the base table level. Views created on the table use this common pool of counters. When views are altered i.e. when columns are added to them, it is likely that the qualifiers allocated to views are not contiguous. This makes the data for views sparse which prevents us from taking advantage of encoding strategies. See discussion on PHOENIX-2565. There could be use cases where the user defines a global view and then child views are defined on that global view. By storing the counter at global view level, child views will be allocated a relatively contiguous set of column qualifiers (especially if they are not modified after the initial CREATE VIEW call).