[ https://issues.apache.org/jira/browse/SPARK-35906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17369894#comment-17369894 ]
Apache Spark commented on SPARK-35906: -------------------------------------- User 'wangyum' has created a pull request for this issue: https://github.com/apache/spark/pull/33100 > Remove order by if the maximum number of rows less than or equal to 1 > --------------------------------------------------------------------- > > Key: SPARK-35906 > URL: https://issues.apache.org/jira/browse/SPARK-35906 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.2.0 > Reporter: Yuming Wang > Priority: Major > > {code:scala} > spark.sql("select count(*) from range(1, 10, 2, 2) order by 1 limit > 10").explain("cost") > {code} > Current optimized logical plan: > {noformat} > == Optimized Logical Plan == > Sort [count(1)#2L ASC NULLS FIRST], true, Statistics(sizeInBytes=16.0 B) > +- Aggregate [count(1) AS count(1)#2L], Statistics(sizeInBytes=16.0 B, > rowCount=1) > +- Project, Statistics(sizeInBytes=20.0 B) > +- Range (1, 10, step=2, splits=Some(2)), Statistics(sizeInBytes=40.0 > B, rowCount=5) > {noformat} > Expected optimized logical plan: > {noformat} > == Optimized Logical Plan == > Aggregate [count(1) AS count(1)#2L], Statistics(sizeInBytes=16.0 B, > rowCount=1) > +- Project, Statistics(sizeInBytes=20.0 B) > +- Range (1, 10, step=2, splits=Some(2)), Statistics(sizeInBytes=40.0 B, > rowCount=5) > {noformat} -- 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