[
https://issues.apache.org/jira/browse/PHOENIX-5584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16981314#comment-16981314
]
Thomas D'Silva commented on PHOENIX-5584:
-----------------------------------------
The {{doGetTable}} will only work as long as SYSCAT hasn't split. You should
use {{PhoenixRuntime.getTableNoCache}} which will return the parent table with
all its inherited columns if the parent itself is a view and then call
{{ViewUtil.addDerivedColumnsAndIndexesFromParent}}
I don't think you need to add this PTable to the cache as it contains the
parent table columns as well and the original call to {{doGetTable}} would have
added it to the cache if required.
> Older clients don't get correct view metadata when a 4.15 client creates a
> view
> -------------------------------------------------------------------------------
>
> Key: PHOENIX-5584
> URL: https://issues.apache.org/jira/browse/PHOENIX-5584
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0, 5.1.0
> Reporter: Xinyi Yan
> Assignee: Chinmay Kulkarni
> Priority: Blocker
> Fix For: 4.15.0, 5.1.0
>
> Attachments: 5584-4.x-HBase-1.5-v2.txt, 5584-4.x-HBase-1.5.txt,
> PHOENIX-5584-4.x-HBase-1.3-v3.patch
>
>
> To reproduce this bug locally:
> 1. start the sandbox at 4.15.
> 2. created table and view at 4.15 client.
> {code:java}
> CREATE TABLE AAA (A BIGINT PRIMARY KEY, B BIGINT);
> CREATE VIEW A_VIEW AS SELECT * FROM AAA;
> {code}
> 3. query `SELECT * FROM A_VIEW` at 4.14 client.
> {code:java}
> 0: jdbc:phoenix:localhost:51070> SELECT * FROM A_VIEW;
> +--+
> | |
> +--+
> +--+
> No rows selected (0.009 seconds)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
