[
https://issues.apache.org/jira/browse/SPARK-45055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated SPARK-45055:
-----------------------------------
Labels: pull-request-available (was: )
> Do not transpose windows if they conflict on ORDER BY / PROJECT clauses
> -----------------------------------------------------------------------
>
> Key: SPARK-45055
> URL: https://issues.apache.org/jira/browse/SPARK-45055
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.4.1
> Reporter: Andrey Gubichev
> Priority: Major
> Labels: pull-request-available
>
> TransposeWindows rule reorders parent and child window functions. Currently
> it incorrectly reorders the window functions in cases where the top window
> function orders by on the result of the bottom window function, e.g. {{sum1}}
> in the following example:
> {{SELECT ROW_NUMBER() OVER (PARTITION BY C ORDER BY sum1) FROM (SELECT
> ROW_NUMBER() OVER (PARTITION BY C) as sum1 FROM T) }}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
