N Campbell created SPARK-20828:
----------------------------------
Summary: 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
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
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
