dongjoon-hyun commented on a change in pull request #29642:
URL: https://github.com/apache/spark/pull/29642#discussion_r628899709
##########
File path: sql/core/benchmarks/FilterPushdownBenchmark-jdk11-results.txt
##########
@@ -2,669 +2,669 @@
Pushdown for many distinct value case
================================================================================================
-OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure
-Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
+OpenJDK 64-Bit Server VM 11.0.11+9-LTS on Linux 5.4.0-1046-azure
+Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Select 0 string row (value IS NULL): Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
-Parquet Vectorized 10512 10572
58 1.5 668.4 1.0X
-Parquet Vectorized (Pushdown) 596 621
19 26.4 37.9 17.6X
-Native ORC Vectorized 8555 8723
97 1.8 543.9 1.2X
-Native ORC Vectorized (Pushdown) 592 609
11 26.6 37.7 17.8X
+Parquet Vectorized 9788 10231
259 1.6 622.3 1.0X
+Parquet Vectorized (Pushdown) 493 536
29 31.9 31.3 19.9X
+Native ORC Vectorized 6487 6575
137 2.4 412.4 1.5X
+Native ORC Vectorized (Pushdown) 436 447
14 36.1 27.7 22.4X
-OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure
-Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
+OpenJDK 64-Bit Server VM 11.0.11+9-LTS on Linux 5.4.0-1046-azure
+Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Select 0 string row ('7864320' < value < '7864320'): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-----------------------------------------------------------------------------------------------------------------------------------
-Parquet Vectorized 10406
10461 50 1.5 661.6 1.0X
-Parquet Vectorized (Pushdown) 619
641 22 25.4 39.4 16.8X
-Native ORC Vectorized 8787
8834 57 1.8 558.6 1.2X
-Native ORC Vectorized (Pushdown) 592
608 11 26.6 37.6 17.6X
+Parquet Vectorized 9861
9880 16 1.6 626.9 1.0X
+Parquet Vectorized (Pushdown) 507
529 21 31.0 32.3 19.4X
+Native ORC Vectorized 6871
6938 63 2.3 436.8 1.4X
+Native ORC Vectorized (Pushdown) 453
470 13 34.7 28.8 21.8X
-OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure
-Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
+OpenJDK 64-Bit Server VM 11.0.11+9-LTS on Linux 5.4.0-1046-azure
+Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Select 1 string row (value = '7864320'): Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
-Parquet Vectorized 10632 10694
60 1.5 676.0 1.0X
-Parquet Vectorized (Pushdown) 608 635
22 25.9 38.6 17.5X
-Native ORC Vectorized 8790 8838
37 1.8 558.9 1.2X
-Native ORC Vectorized (Pushdown) 559 584
22 28.1 35.5 19.0X
+Parquet Vectorized 10228 10471
167 1.5 650.3 1.0X
+Parquet Vectorized (Pushdown) 511 519
5 30.8 32.5 20.0X
+Native ORC Vectorized 6700 6865
119 2.3 426.0 1.5X
+Native ORC Vectorized (Pushdown) 436 454
12 36.1 27.7 23.5X
-OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure
-Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
+OpenJDK 64-Bit Server VM 11.0.11+9-LTS on Linux 5.4.0-1046-azure
+Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Select 1 string row (value <=> '7864320'): Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------
-Parquet Vectorized 10529 10624
74 1.5 669.4 1.0X
-Parquet Vectorized (Pushdown) 613 631
16 25.7 39.0 17.2X
-Native ORC Vectorized 8746 8816
63 1.8 556.1 1.2X
-Native ORC Vectorized (Pushdown) 589 600
11 26.7 37.5 17.9X
+Parquet Vectorized 10287 10449
144 1.5 654.0 1.0X
+Parquet Vectorized (Pushdown) 467 494
20 33.7 29.7 22.0X
+Native ORC Vectorized 6781 6848
58 2.3 431.1 1.5X
+Native ORC Vectorized (Pushdown) 428 440
10 36.8 27.2 24.1X
Review comment:
ditto. `17 vs 17` -> `22 vs 24`.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]