You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2018/07/12 23:55:00 UTC

[jira] [Resolved] (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 ]

Xiao Li resolved SPARK-24790.
-----------------------------
       Resolution: Fixed
         Assignee: Maryann Xue
    Fix Version/s: 2.4.0

> 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
>            Assignee: Maryann Xue
>            Priority: Minor
>             Fix For: 2.4.0
>
>
> 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