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-2051) Link record is in the format CHILD-PARENT for phoenix views and it has to scan the entire table to find the parent suffix.
Date Wed, 15 Mar 2017 07:37:41 GMT

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

Hudson commented on PHOENIX-2051:
---------------------------------

FAILURE: Integrated in Jenkins build Phoenix-master #1588 (See [https://builds.apache.org/job/Phoenix-master/1588/])
PHOENIX-2051 Link record is in the format CHILD-PARENT for phoenix views (tdsilva: rev 8093d10f1a481101d6c93fdf0744ff15ec48f4aa)
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/UpgradeUtil.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataProtocol.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixDatabaseMetaData.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/PTable.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/MetaDataUtil.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java


> Link record is in the format CHILD-PARENT for phoenix views and it has to scan the entire
table to find the parent suffix.
> --------------------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-2051
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2051
>             Project: Phoenix
>          Issue Type: Sub-task
>    Affects Versions: 4.3.1
>            Reporter: Arun Kumaran Sabtharishi
>            Assignee: Thomas D'Silva
>             Fix For: 4.11.0
>
>         Attachments: PHOENIX-2051.patch
>
>
> When a phoenix view is dropped, it runs a scan on the SYSTEM.CATALOG table looking for
the link record. Since the link record is in the format CHILD-PARENT, it has to scan the entire
table to find the parent suffix. For the long term solution, we can write two link records,
the existing CHILD-PARENT and a new PARENT-CHILD so that the findChildViews() method can use
a key range scan.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message