[SERVER-82817] Implement corresponding Stage Builder changes for Window Function to optimize projections Created: 06/Nov/23  Updated: 02/Feb/24

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

Type: Improvement Priority: Major - P3
Reporter: Rushan Chen Assignee: Foteini Alvanaki
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-83235 SBE stage builder anti-materializatio... In Code Review
Sprint: QE 2023-12-11, QE 2023-12-25, QE 2024-01-08, QE 2024-01-22, QE 2024-02-05, QE 2024-02-19
Participants:

 Description   

SERVER-81466improves how projections are generated by Stage Builder. It was merged Nov 4th. Stage Builder for window function can use this change to optimize the partition expressions for $linearFill to avoid redundant $project/addFields.

The limitation placed in https://jira.mongodb.org/browse/SERVER-83490 should be removed as part of this work.



 Comments   
Comment by Foteini Alvanaki [ 15/Nov/23 ]

At the moment, we cannot use the new method for setWindowFields because it does not yet support fields that are created in a stage and propagated to the projection. SERVER-83235 will add this functionality.

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