[ 
https://issues.apache.org/jira/browse/SPARK-32947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuming Wang updated SPARK-32947:
--------------------------------
    Target Version/s:   (was: 3.0.1)

> Support top-N sort for Spark SQL window function
> ------------------------------------------------
>
>                 Key: SPARK-32947
>                 URL: https://issues.apache.org/jira/browse/SPARK-32947
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.0.1
>            Reporter: Zikun
>            Priority: Major
>
> In Spark SQL, there are two types of sort execution, *_SortExec_* and 
> *_TakeOrderedAndProjectExec_* . *_SortExec_* is a general sorting execution 
> and it does not support top-N sort. ​*_TakeOrderedAndProjectExec_* is the 
> execution for top-N sort in Spark. Spark SQL rank window function needs to 
> sort the data locally and it relies on the execution plan *_SortExec_* to 
> sort the data in each physical data partition. When the filter of the window 
> rank (e.g. rank <= 100) is specified in a user's query, the filter can 
> actually be pushed down to the SortExec and then we let SortExec operates 
> top-N sort. Right now SortExec does not support top-N sort and we need to 
> extend the capability of SortExec to support top-N sort. 
>  
> This Jira has dependency on another existing Jira
> https://issues.apache.org/jira/browse/SPARK-32096
>  



--
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

Reply via email to