phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4468) Looking up a parent index table of a child view from a different client fails.
Date Wed, 20 Dec 2017 20:49:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-4468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16299068#comment-16299068
] 

Hudson commented on PHOENIX-4468:
---------------------------------

FAILURE: Integrated in Jenkins build Phoenix-master #1898 (See [https://builds.apache.org/job/Phoenix-master/1898/])
PHOENIX-4468 Looking up a parent index table of a child view from a (tdsilva: rev c935f57f5e7afb42ff8b62a4712ad7d8ffed17cc)
* (edit) phoenix-core/src/main/antlr3/PhoenixSQL.g
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/PhoenixRuntime.java
* (add) phoenix-core/src/it/java/org/apache/phoenix/end2end/PhoenixDriverIT.java
* (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/PTableImpl.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java


> Looking up a parent index table of a child view from a different client fails. 
> -------------------------------------------------------------------------------
>
>                 Key: PHOENIX-4468
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4468
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Thomas D'Silva
>            Assignee: Thomas D'Silva
>             Fix For: 4.14.0, 4.13.2
>
>         Attachments: PHOENIX-4468-4.x-HBase-0.98.patch, PHOENIX-4468-v2-4.x-HBase-0.98.patch,
PHOENIX-4468-v3-4.x-HBase-0.98.patch
>
>
> When you execute a query on a view, phoenix will use any indexes on the base table that
have all the required columns. We create a new PTable based on the parent table index and
tack on the view statement (to ensure we only see rows that we can access from the view).
This PTable is added to the client side connection metadata cache. This table is not available
on the server side (in SYSTEM.CATALOG).
> If you lookup the parent index table from a different client (that never ran a query
on the view), it will fail with a TableNotFoundException.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message