[jira] [Created] (CALCITE-1710) GroupBy columns support arithmetic expression

["lincoln.lee (JIRA)" <ji...@apache.org>]

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)