[
https://issues.apache.org/jira/browse/PHOENIX-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17762827#comment-17762827
]
Jacob Isaac commented on PHOENIX-4555:
--------------------------------------
In addition to the above specification we should restrict
Sibling and child views to use PK columns in the order they are defined.
This will allow updatable views to be identified via prefixes.
Being able to quickly map to a view by looking at the prefix of the row is
useful for e.g -
* When compacting away expired rows when ttl is enabled at the view level.
* Collecting stats at the view level.
> 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: Sub-task
> Reporter: James R. Taylor
> Assignee: Jing Yu
> Priority: Major
>
> 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
(v8.20.10#820010)
