Yuming Wang created SPARK-34775:
-----------------------------------
Summary: Push down limit through window when partitionSpec is not
empty
Key: SPARK-34775
URL: https://issues.apache.org/jira/browse/SPARK-34775
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.2.0
Reporter: Yuming Wang
For example:
{code:sql}
SELECT *, ROW_NUMBER() OVER(PARTITION BY a ORDER BY b) AS rn FROM t LIMIT 10 ==>
SELECT *, ROW_NUMBER() OVER(PARTITION BY a ORDER BY b) AS rn FROM (SELECT *
FROM t ORDER BY a, b LIMIT 10) tmp
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
