[
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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
