You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Andrey Gubichev (Jira)" <ji...@apache.org> on 2023/09/01 19:00:00 UTC

[jira] [Created] (SPARK-45055) Do not transpose windows if they conflict on ORDER BY / PROJECT clauses

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