You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2022/04/21 06:55:00 UTC

[jira] [Assigned] (HIVE-26160) Materialized View rewrite does not check tables scanned in sub-query expressions

     [ https://issues.apache.org/jira/browse/HIVE-26160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krisztian Kasa reassigned HIVE-26160:
-------------------------------------


> Materialized View rewrite does not check tables scanned in sub-query expressions
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-26160
>                 URL: https://issues.apache.org/jira/browse/HIVE-26160
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO, Materialized views
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>
> Materialized View rewrite based on exact sql text match uses the initial CBO plan to explore possibilities to change the query plan or part of the plan to an MV scan.
> This algorithm requires the tables scanned by the original query plan. If the query contains sub query expressions the tables scanned by the sub query are not listed which can lead to rewrite the original plan to scan an outdated MV.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)