Opened 22 months ago

Last modified 22 months ago

#27646 new New feature

Add QuerySet support for group by modifiers and OLAP functionality

Reported by: Mads Jensen Owned by: nobody
Component: Database layer (models, ORM) Version: master
Severity: Normal Keywords: olap rollup orm
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

PostgreSQL 9.5 introduced cube, grouping sets and rollup. MySQL/MariaDB supports the rollup-operation for aggregations. Oracle (obviously) also supports rollup, grouping sets and cube. I suggest adding methods in QuerySet for this, feature-flags to indicate level of support, and either new expressions for the different rollup-syntax, or amend the operations of the backends for this. The syntax is slightly different in MySQL/MariaDB, as it uses WITH ROLLUP, rather than ROLLUP.

https://oracle-base.com/articles/misc/rollup-cube-grouping-functions-and-grouping-sets
http://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
https://www.postgresql.org/docs/current/static/queries-table-expressions.html#QUERIES-GROUPING-SETS

Change History (1)

comment:1 Changed 22 months ago by Tim Graham

Summary: Group by modifiers, OLAP functionalityAdd QuerySet support for group by modifiers and OLAP functionality
Triage Stage: UnreviewedAccepted

Tentatively accepting. It might be nice to elaborate on the details such as by writing documentation and getting feedback on that before starting to code.

Note: See TracTickets for help on using tickets.
Back to Top