You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Liang-Chi Hsieh (JIRA)" <ji...@apache.org> on 2019/05/20 15:43:00 UTC
[jira] [Updated] (SPARK-27779) Regression when explode on map in
Generate
[ https://issues.apache.org/jira/browse/SPARK-27779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Liang-Chi Hsieh updated SPARK-27779:
------------------------------------
Description:
When I ran MiscBenchmark for SPARK-27707, I found a regression regarding explode map:
{code}
OpenJDK 64-Bit Server VM 1.8.0_212-8u212-b03-0ubuntu1.18.04.1-b03 on Linux 4.15.0-1021-aws
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
generate explode map: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
generate explode map wholestage off 50273 51458 1676 0.3 2996.5 1.0X
generate explode map wholestage on 43113 43351 278 0.4 2569.8 1.2X
{code}
I got this benchmark result by running MiscBenchmark on current master. All benchmark result is at https://gist.github.com/viirya/c850b49e364e8e6aaa6271ae9e3343fc
The last committed benchmark number in MiscBenchmark-results.txt:
{code}
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
generate explode map: Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------
generate explode map wholestage off 22128 / 22578 0.8 1318.9 1.0X
generate explode map wholestage on 16421 / 16520 1.0 978.8 1.3X
{code}
It looks significant regression, if I don't miss something.
Maybe others can also verify if there is really a regression.
was:
When I ran MiscBenchmark for SPARK-27707, I found a regression regarding explode map:
{code}
OpenJDK 64-Bit Server VM 1.8.0_212-8u212-b03-0ubuntu1.18.04.1-b03 on Linux 4.15.0-1021-aws
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
generate explode map: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
generate explode map wholestage off 50273 51458 1676 0.3 2996.5 1.0X
generate explode map wholestage on 43113 43351 278 0.4 2569.8 1.2X
{code}
I got this benchmark result by running MiscBenchmark on current master. All benchmark result is at https://gist.github.com/viirya/c850b49e364e8e6aaa6271ae9e3343fc
The last committed benchmark number in MiscBenchmark-results.txt:
{code}
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
generate explode map: Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------
generate explode map wholestage off 22128 / 22578 0.8 1318.9 1.0X
generate explode map wholestage on 16421 / 16520 1.0 978.8 1.3X
{code}
It looks significant regression, if I don't miss something.
Maybe others can also verify if there is really a regression.
> Regression when explode on map in Generate
> ------------------------------------------
>
> Key: SPARK-27779
> URL: https://issues.apache.org/jira/browse/SPARK-27779
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Liang-Chi Hsieh
> Priority: Major
>
> When I ran MiscBenchmark for SPARK-27707, I found a regression regarding explode map:
> {code}
> OpenJDK 64-Bit Server VM 1.8.0_212-8u212-b03-0ubuntu1.18.04.1-b03 on Linux 4.15.0-1021-aws
> Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
> generate explode map: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
> ------------------------------------------------------------------------------------------------------------------------
> generate explode map wholestage off 50273 51458 1676 0.3 2996.5 1.0X
> generate explode map wholestage on 43113 43351 278 0.4 2569.8 1.2X
> {code}
> I got this benchmark result by running MiscBenchmark on current master. All benchmark result is at https://gist.github.com/viirya/c850b49e364e8e6aaa6271ae9e3343fc
> The last committed benchmark number in MiscBenchmark-results.txt:
> {code}
> OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
> Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
> generate explode map: Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
> ------------------------------------------------------------------------------------------------
> generate explode map wholestage off 22128 / 22578 0.8 1318.9 1.0X
> generate explode map wholestage on 16421 / 16520 1.0 978.8 1.3X
> {code}
> It looks significant regression, if I don't miss something.
> Maybe others can also verify if there is really a regression.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org