[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. |