[
https://issues.apache.org/jira/browse/SPARK-45055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17762330#comment-17762330
]
Aparna Garg commented on SPARK-45055:
-------------------------------------
User 'agubichev' has created a pull request for this issue:
https://github.com/apache/spark/pull/42778
> 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
>
> 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]
