phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (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 Tue, 19 Dec 2017 23:43:00 GMT

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

James Taylor commented on PHOENIX-4468:
---------------------------------------

Thanks, [~tdsilva]. One question - I didn't notice the removal of the test before. Why is
that being removed?

Also, please reference the JIRA you created in this comment too:
{code}
+     * it is referenced from a query (a call is made to the server to fetch the latest metadata
of the table
+     * depending on the UPDATE_CACHE_FREQUENCY property)
{code}

+1 otherwise.

> 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
>
>
> 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