Takeshi Yamamuro created SPARK-29698:
----------------------------------------

             Summary: Support grouping function with multiple arguments
                 Key: SPARK-29698
                 URL: https://issues.apache.org/jira/browse/SPARK-29698
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Takeshi Yamamuro


In PgSQL, grouping() can have multiple arguments, but Spark grouping() must 
have a single argument 
([https://github.com/apache/spark/blob/master/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/grouping.scala#L100]);
{code:java}
postgres=# select a, b, grouping(a, b), sum(v), count(*), max(v)
postgres-#   from gstest1 group by rollup (a,b);
 a | b | grouping | sum | count | max 
---+---+----------+-----+-------+-----
   |   |        3 |     |     0 |    
(1 row)
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to