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)

Reply via email to