-
Type:
New Feature
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
None
-
Query Optimization
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
postgres supports a windowing capability that allows for calculations within a window of visible data; this is for streaming data.
It's easy to imagine supporting something like a $window pipeline operator, which specifies how many documents to include in the window. Within, aggregate expressions can reference documents within the window using some kind of indexing. This can be used to calculate things like moving averages, e.g., have a window of 5 items, and create a computed field that is (doc[0] + doc[-1] + doc[-2] + doc[-3] + doc[-4])/5, or something like that.
- depends on
-
SERVER-52328 Enable feature flag for Window Functions
-
- Closed
-
- is related to
-
-
- Closed
-
- related to
-
-
- Closed
-
-
SERVER-29339 allow using $reduce expression as accumulator in $group
-
- Backlog
-