jin xing created SPARK-22350:
--------------------------------

             Summary: Select grouping__id from subquery
                 Key: SPARK-22350
                 URL: https://issues.apache.org/jira/browse/SPARK-22350
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 2.2.0
            Reporter: jin xing


Currently, sql below will fail:
SELECT cnt, k2, k3, grouping__id
FROM
(SELECT count(*) as cnt, k2, k3, grouping__id
FROM t1
GROUP BY k2, k3
GROUPING SETS(k2, k3)) t2

Can we support selecting grouping__id from subquery ?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

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

Reply via email to