You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2018/07/11 22:44:00 UTC
[jira] [Updated] (SPARK-24790) Allow complex aggregate expressions
in Pivot
[ https://issues.apache.org/jira/browse/SPARK-24790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maryann Xue updated SPARK-24790:
--------------------------------
Description: In SPARK-24035, to conform with Oracle PIVOT syntax, a strict check of PIVOT's aggregate expressions was exerted, which allows only an AggregateExpression with or without alias. Now we would like to relax the check to allow complex aggregate expressions, like {{ceil(sum(col1))}} or {{sum(col1) + 1}} (was: In SPARK-24035, to conform with Oracle PIVOT syntax, a strict check of PIVOT's aggregate expressions was exerted, which allows only an AggregateExpression with or without alias. Now we would like to relax to complex aggregate expressions, like {{ceil(sum(col1))}} or {{sum(col1) + 1}})
> Allow complex aggregate expressions in Pivot
> --------------------------------------------
>
> Key: SPARK-24790
> URL: https://issues.apache.org/jira/browse/SPARK-24790
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 2.4.0
> Reporter: Maryann Xue
> Priority: Minor
>
> In SPARK-24035, to conform with Oracle PIVOT syntax, a strict check of PIVOT's aggregate expressions was exerted, which allows only an AggregateExpression with or without alias. Now we would like to relax the check to allow complex aggregate expressions, like {{ceil(sum(col1))}} or {{sum(col1) + 1}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org