Andrey Gubichev created SPARK-45055: ---------------------------------------
Summary: 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 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