[
https://issues.apache.org/jira/browse/PHOENIX-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17790223#comment-17790223
]
ASF GitHub Bot commented on PHOENIX-4555:
-----------------------------------------
virajjasani commented on PR #1704:
URL: https://github.com/apache/phoenix/pull/1704#issuecomment-1828436906
For this failure
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1704/12/testReport/org.apache.phoenix.end2end/LogicalTableNameExtendedIT/testUpdatePhysicalTableName_tenantViews/
```
java.lang.RuntimeException: org.apache.hadoop.hbase.TableNotFoundException:
SYSTEM.CHILD_LINK
at
org.apache.phoenix.compile.CreateTableCompiler.compile(CreateTableCompiler.java:194)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.compilePlan(PhoenixStatement.java:1070)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.compilePlan(PhoenixStatement.java:1056)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:552)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:533)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:532)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:520)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2253)
```
you can refer to
https://github.com/apache/phoenix/pull/1709/commits/2e0da189b6e0d6be178f322569d5d23c2d583f56
Basically we need to handle namespace resolution.
> 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)
