Krisztian Kasa created HIVE-26160:
-------------------------------------
Summary: 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
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)
