[jira] [Created] (SPARK-35906) Remove order by if the maximum number of rows less than or equal to 1

[Yuming Wang (Jira)]

Yuming Wang created SPARK-35906:
-----------------------------------

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


{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