[jira] [Created] (PHOENIX-7067) View indexes should be created only on non overlapping updatable views

["Jacob Isaac (Jira)" <ji...@apache.org>]

Jacob Isaac created PHOENIX-7067:
------------------------------------

             Summary: View indexes should be created only on non overlapping updatable views
                 Key: PHOENIX-7067
                 URL: https://issues.apache.org/jira/browse/PHOENIX-7067
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Jacob Isaac


Updatable views by definition outlined in PHOENIX-4555 are disjoint partitions/virtual tables on the base HBase table.
View indexes should only be allowed to be defined on these partitions.
As PHOENIX-7047 revealed index rows are not generated or get clobbered for certain multi-level views.

This JIRA will try and address these issues and add the proper constraints on when updatable views and view indexes can be created.
1. View should be allowed to extend the parent PK i.e. adding its own PK column in the view definition only when there are no indexes in the parent hierarchy.
and vice versa
2. View indexes can defined on a given view only when there are no child views that have extended the PK of the base view.

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)