Jiajun Xie created CALCITE-5525: ----------------------------------- Summary: GROUPING_ID() should be rewritten to GROUPING() in some dialects Key: CALCITE-5525 URL: https://issues.apache.org/jira/browse/CALCITE-5525 Project: Calcite Issue Type: Improvement Components: core Reporter: Jiajun Xie Assignee: Jiajun Xie
Some databases not exists `grouping_id()`, `grouping()` is used as `grouping_id()`. - Postgresql {code:java} ERROR: function grouping_id(integer, character varying) does not exist LINE 1: select grouping(id), grouping(name), grouping_id(id, name), ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts {code} - Presto {code:java} Function grouping_id not registered {code} Here is a simple query, `grouping_id()` is a legal function in Spark. {code:java} select a, b, count(*), grouping(a) ga, grouping(b) gb, grouping_id(a, b) from ( select 1 as a, 2 as b ) group by grouping sets((a, b), (b), ()) {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)