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