[HIVE-23973] Use SQL constraints to improve join reordering algorithm (III)

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 31/Jul/20 23:59
• Updated: 27/Feb/24 22:24
• Resolved: 03/Aug/20 14:13

Description

This issue focuses on pulling non-filtering column appending FK-PK joins to the top of the plan. Among other improvements, this will avoid unnecessary shuffling of data in intermediate stages.

Issue Links

• relates to: HIVE-20744 Use SQL constraints to improve join reordering algorithm
• relates to: HIVE-20920 Use SQL constraints to improve join reordering algorithm (II)
• links to: GitHub Pull Request #1349