[SERVER-57554] Support outer join in SBE HashJoin stage Created: 08/Jun/21  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Ian Boros Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Execution
Participants:

 Description   

Currently the SBE hash join operator always uses the 'outer' side as the 'build' side. For the $group/$lookup project, the right(inner) side of $lookup will always be the build side. Since $lookup performs a left-outer join, we will have to flip the join sides. We must make HashJoin support right outer joins.


Generated at Thu Feb 08 05:42:10 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.