[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:
Related
related to SERVER-67330 Add counters to count $unwind + $look... Closed
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

Generated at Thu Feb 08 06:07:49 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.