Please see the scope doc and let Query know if any questions
Description of Linked Ticket
Summary
Add a $top accumulator that returns an array of expressions evaluated for top n documents according to a given sort order
Motivation
One common analytical task is to find the top or bottom n elements in each cohort. For example, we are interested in the 10 best salespeople for each region based on their individual sales, or in the 5 slowest queries issued by a given tenant on each day. This is a generalization of finding the best or worst element.
Cast of Characters
- Product Owner: Katya Kamenieva
- Project Lead: TBD
- Program Manager: Craig Homa
- Drivers Contact: TBD
Documentation
Scope Document
Technical Design Document
Product Description
- clones
-
JAVA-4094 Add builder support for pick-n accumulators
- Closed
- depends on
-
CSHARP-4186 Refactor AstSetWindowFieldsWindowExpressions into multiple subclasses
- Closed
- related to
-
CSHARP-4216 Support $topN and similar accumulators in $setWindowFields
- Backlog