[ https://issues.apache.org/jira/browse/SPARK-34775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17306018#comment-17306018 ]
Apache Spark commented on SPARK-34775: -------------------------------------- User 'leoluan2009' has created a pull request for this issue: https://github.com/apache/spark/pull/31926 > 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 > Priority: Major > > 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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org