[DRILL-6456] Planner shouldn't create any exchanges on the right side of Lateral Join.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.14.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Hanumath Rao Maduri
• Reporter: Hanumath Rao Maduri
• Reviewer: Aman Sinha
• Created: 31/May/18 02:59
• Updated: 29/Jun/18 17:19
• Resolved: 04/Jun/18 23:22

Description

Currently, there is no restriction placed on right side of the LateralJoin. This is causing planner to generate an Exchange when there are operators like (Agg, Limit, Sort etc). 

Due to this unnest operator cannot retrieve the row from lateral's left side to process the pipeline further. Enhance the planner to not generate exchanges on the right side of the LateralJoin.

Issue Links

• is depended upon by: DRILL-5999 Add support for LATERAL join
• links to: GitHub Pull Request #1299