[HIVE-24081] Enable pre-materializing CTEs referenced in scalar subqueries

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Query Processor
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 27/Aug/20 09:15
• Updated: 27/Feb/24 22:23
• Resolved: 02/Sep/20 17:08

Description

HIVE-11752 introduces materializing CTE based on config

hive.optimize.cte.materialize.threshold

Goal of this jira is

• extending the implementation to support materializing CTE's referenced in scalar subqueries
• add a config to materialize CTEs with aggregate output only

Issue Links

• causes: HIVE-24167 TPC-DS query 14 fails while generating plan for the filter
• is related to: HIVE-11752 Pre-materializing complex CTE queries
• links to: GitHub Pull Request #1437