James Taylor created PHOENIX-4555:
-------------------------------------
Summary: Only mark view as updatable if rows cannot overlap with
other updatable views
Key: PHOENIX-4555
URL: https://issues.apache.org/jira/browse/PHOENIX-4555
Project: Phoenix
Issue Type: Bug
Reporter: James Taylor
We'll run into issues if updatable sibling views overlap with each other. For
example, say you have the following hierarchy:
T (A, B, C)
V1 (D, E) FROM T WHERE A = 1
V2 (F, G) FROM T WHERE A = 1 and B = 2
In this case, there's no way to update both V1 and v2 columns. Secondary
indexes wouldn't work either, if you had one on each V1 & V2.
We should restrict updatable views to
- views that filter on PK column(s)
- sibling views filter on same set of PK column(s)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
