[SPARK-36612] Support left outer join build left or right outer join build right in shuffled hash join

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Assignee: Szehon Ho
• Reporter: mcdull_zhang
• Created: 30/Aug/21 09:48
• Updated: 02/Jun/23 20:30
• Resolved: 02/Jun/23 20:30

Description

Currently spark sql does not support build left side when left outer join (or build right side when right outer join).

However, in our production environment, there are a large number of scenarios where small tables are left join large tables, and many times, large tables have data skew (currently AQE can't handle this kind of skew).

Inspired by SPARK-32399, we can use similar ideas to realize left outer join build left.

I think this treatment is very meaningful, but I don’t know how members consider this matter?

Issue Links

• links to: [Github] Pull Request #41398 (szehon-ho)