[
https://issues.apache.org/jira/browse/SPARK-20828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyukjin Kwon resolved SPARK-20828.
----------------------------------
Resolution: Incomplete
> Concatenated grouping sets scenario not supported
> --------------------------------------------------
>
> Key: SPARK-20828
> URL: https://issues.apache.org/jira/browse/SPARK-20828
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.0
> Reporter: N Campbell
> Priority: Major
> Labels: bulk-closed
>
> Following scenario supported by other vendors (i.e. ORACLE, DB2, ...) not
> supported by SPARK SQL
> WITH
> SQL1 AS
> (
> SELECT
> sno AS C1,
> pno AS C2,
> SUM(qty) AS C3
> FROM
> cert.tsupply
> GROUP BY
> ROLLUP(sno),
> CUBE(pno)
> )
> SELECT
> SQL1.C1 AS C1,
> SQL1.C2 AS C2,
> SQL1.C3 AS C3
> FROM
> SQL1
> Error: [Simba][SparkJDBCDriver](500051) ERROR processing query/statement.
> Error Code: ERROR_STATE, SQL state: org.apache.spark.sql.AnalysisException:
> expression 'tsupply.`sno`' is neither present in the group by, nor is it an
> aggregate function. Add to group by or wrap in first() (or first_value) if
> you don't care which value you get.;;
> 'Project ['SQL1.C1 AS C1#1517671, 'SQL1.C2 AS C2#1517672, 'SQL1.C3 AS
> C3#1517673]
> +- 'SubqueryAlias SQL1
> +- 'Aggregate [rollup(sno#1517678), cube(pno#1517679)], [sno#1517678 AS
> C1#1517674, pno#1517679 AS C2#1517675, sum(cast(qty#1517681 as bigint)) AS
> C3#1517676L]
> +- MetastoreRelation cert, tsupply
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
