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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: CBO, Materialized views
• Labels: pull-request-available
• Target Version/s: 4.0.0-alpha-2
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 21/Apr/22 06:54
• Updated: 28/Apr/22 04:13
• Resolved: 28/Apr/22 04:13

Description

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.

Issue Links

• links to: GitHub Pull Request #3246