[SERVER-83504] Exclusion projection disables lastpoint optimization in timeseries Created: 21/Nov/23  Updated: 22/Nov/23

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

Type: Improvement Priority: Major - P3
Reporter: Irina Yatsenko (Inactive) Assignee: Backlog - Query Integration
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Integration
Participants:

 Description   

Pipeline

[{$group: {_id: "$m", l: {$bottom: {sortBy: {t: 1}, output: "$x"}}}}]

over timeseries with "m" being the metaField and "t" being the timeField triggers lastpoint optimization as expected, however, the same pipeline prefixed with exclusion projection:

[{$project: {y: 0}}, {$group: {_id: "$m", l: {$bottom: {sortBy: {t: 1}, output: "$x"}}}}]

does not. But it would be valid to apply the optimization in this case as well (or remove the useless projection altogether).


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