[
https://issues.apache.org/jira/browse/SPARK-12720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15135386#comment-15135386
]
Xiao Li commented on SPARK-12720:
---------------------------------
The solution is done, but hitting a bug in grouping set. Thus, it is blocked.
Will open a JIRA and PR for resolving the bug at first.
{code}
sql("SELECT `key`, `value`, count( value ) AS `_c2` FROM `default`.`t1` " +
"GROUP BY `key`, `value` GROUPING SETS ((), (`key`), (`key`,
`value`))").show()
{code}
{code}
sql("SELECT `key`, `value`, count( value ) AS `_c2` FROM `default`.`t1` " +
"GROUP BY `key`, `value` with rollup").show()
{code}
These two queries return different results, however, they should be identical.
> SQL generation support for cube, rollup, and grouping set
> ---------------------------------------------------------
>
> Key: SPARK-12720
> URL: https://issues.apache.org/jira/browse/SPARK-12720
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 2.0.0
> Reporter: Cheng Lian
>
> {{HiveCompatibilitySuite}} can be useful for bootstrapping test coverage.
> Please refer to SPARK-11012 for more details.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
