[
https://issues.apache.org/jira/browse/SPARK-29170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maxim Gekk updated SPARK-29170:
-------------------------------
Description:
The updated benchmark results show performance regression *(2 times slower)* in
CSV/JSON datasources on partitioned tables, see
[https://github.com/apache/spark/pull/25828/files#diff-e37c3433287c7371ff9c2404db821095R160]
. Need to find out the root cause of this and fix it.
Old results:
{code}
Partitioned Table: Best/Avg Time(ms) Rate(M/s) Per
Row(ns) Relative
Partition column - CSV 7403 / 7427 2.1
470.7 4.2X
Partition column - Json 5587 / 5625 2.8
355.2 5.5X
{code}
New results:
{code}
Partitioned Table: Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
Partition column - CSV 14680 14742
88 1.1 933.3 2.6X
Partition column - Json 11200 11251
73 1.4 712.1 3.4X
{code}
was:The updated benchmark results show performance regression *(2 times
slower)* in CSV/JSON datasources on partitioned tables, see
https://github.com/apache/spark/pull/25828/files#diff-e37c3433287c7371ff9c2404db821095R160
. Need to find out the root cause of this and fix it.
> Performance regression in CSV/JSON on partitioned tables
> --------------------------------------------------------
>
> Key: SPARK-29170
> URL: https://issues.apache.org/jira/browse/SPARK-29170
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Maxim Gekk
> Priority: Major
>
> The updated benchmark results show performance regression *(2 times slower)*
> in CSV/JSON datasources on partitioned tables, see
> [https://github.com/apache/spark/pull/25828/files#diff-e37c3433287c7371ff9c2404db821095R160]
> . Need to find out the root cause of this and fix it.
> Old results:
> {code}
> Partitioned Table: Best/Avg Time(ms) Rate(M/s) Per
> Row(ns) Relative
> Partition column - CSV 7403 / 7427 2.1
> 470.7 4.2X
> Partition column - Json 5587 / 5625 2.8
> 355.2 5.5X
> {code}
> New results:
> {code}
> Partitioned Table: Best Time(ms) Avg Time(ms)
> Stdev(ms) Rate(M/s) Per Row(ns) Relative
> Partition column - CSV 14680 14742
> 88 1.1 933.3 2.6X
> Partition column - Json 11200 11251
> 73 1.4 712.1 3.4X
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
