[SERVER-67314] Support pushdown of $lookup + $unwind in SBE Created: 15/Jun/22 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: | Eric Cox (Inactive) | Assignee: | Backlog - Query Execution |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | quick-win | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Execution
|
||||||||
| Participants: | |||||||||
| Description |
|
A common agg query is a $lookup followed by an $unwind. When implementing $lookup pushdown into sbe we decided to not support absorption of $unwind into $lookup and execute in sbe to keep the scope smallish. The owner of this ticket should investigate and implement $unwind pushdown in $lookup when executing with sbe. |
| Comments |
| Comment by Kyle Suarez [ 31/Aug/22 ] |
|
After a discussion with Mihai and Storch we decided that none of the current SBE epics felt like the right one. Sending this back to the backlog as I don't think we'd lose track of this request. |
| Comment by Ana Meza [ 05/Aug/22 ] |
|
Hi Kyle, could you please add this to one of the SBE epics? Thanks |