lincoln.lee created CALCITE-1710:
------------------------------------
Summary: GroupBy columns support arithmetic expression
Key: CALCITE-1710
URL: https://issues.apache.org/jira/browse/CALCITE-1710
Project: Calcite
Issue Type: Improvement
Components: core
Reporter: lincoln.lee
Assignee: Julian Hyde
Priority: Minor
Currently only original column reference(s) and column(s) with UDF valid in
group by clause but arithmetic expression(s) not allowed, while most RDBMS
support
like thus:
{code}
SELECT
ColumnA + ColumnB
FROM T
GROUP BY ColumnA + ColumnB;
SELECT
ColumnA + ColumnB + constant
FROM T
GROUP BY ColumnA, ColumnB;
SELECT
ColumnA % 3
FROM T
GROUP BY ColumnA %3;
{code}
we can treat these arithmetic operators as builtin UDFs and support these kind
of query, it'll be a useful feature.
What do you think?
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
