[
https://issues.apache.org/jira/browse/SPARK-35906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17369893#comment-17369893
]
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
