You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "yikf (Jira)" <ji...@apache.org> on 2021/05/09 06:20:00 UTC

[jira] [Created] (SPARK-35355) improve execution performance in insert...select...limit case

yikf created SPARK-35355:
----------------------------

             Summary: improve execution performance in insert...select...limit  case
                 Key: SPARK-35355
                 URL: https://issues.apache.org/jira/browse/SPARK-35355
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: yikf
             Fix For: 3.0.0


In the case of `insert into...select...limit` , `CollectLimitExec` has better execution performance than `GlobalLimit` .

 

Before:

```

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand ...
+- *(2) GlobalLimit 5
+- Exchange SinglePartition, true, [id=#39]
+- *(1) LocalLimit 5
+- *(1) ColumnarToRow
+- FileScan ...

```

After:

```

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand ...
+- CollectLimit 5
 +- *(1) ColumnarToRow
 +- FileScan ....

```

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org