yanjing.wang created CALCITE-5089:
-------------------------------------
Summary: Allow GROUP BY ALL or DISTINCT set quantifier on GROUPING
SETS
Key: CALCITE-5089
URL: https://issues.apache.org/jira/browse/CALCITE-5089
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.30.0
Environment: jdk8
Reporter: yanjing.wang
Assignee: yanjing.wang
Fix For: 1.31.0
GROUP BY DISTINCT will be used to remove duplicate GROUPING SETS, for example:
{code:java}
SELECT product_id, product_class_id, count(*) from product GROUP BY DISTINCT
CUBE (product_id, product_class_id), ROLLUP (product_id, product_class_id){code}
it's equivalent to
{code:java}
SELECT product_id, product_class_id, count(*) from product GROUP BY GROUPING
SETS ((product_id, product_class_id), (product_id), (product_class_id), ())
{code}
GROUP BY ALL will remain the duplicate GROUPING SETS, it's equivalent to GROUP
BY, so most databases use ALL as the default set quantifier.
As far as I know the PostgreSQL and Trino support this syntax.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
