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: [email protected]
For additional commands, e-mail: [email protected]
