-
Notifications
You must be signed in to change notification settings - Fork 28k
/
ObjectHashAggregateExecBenchmark-jdk17-results.txt
45 lines (36 loc) · 3.52 KB
/
ObjectHashAggregateExecBenchmark-jdk17-results.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
================================================================================================
Hive UDAF vs Spark AF
================================================================================================
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
hive udaf vs spark af: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
hive udaf w/o group by 5798 5863 37 0.0 88475.5 1.0X
spark af w/o group by 34 43 7 1.9 513.8 172.2X
hive udaf w/ group by 4533 4563 19 0.0 69161.7 1.3X
spark af w/ group by w/o fallback 35 40 5 1.8 541.5 163.4X
spark af w/ group by w/ fallback 44 47 4 1.5 665.0 133.0X
================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - typed_count
================================================================================================
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
object agg v.s. sort agg: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
sort agg w/ group by 30779 31333 783 3.4 293.5 1.0X
object agg w/ group by w/o fallback 8555 8930 184 12.3 81.6 3.6X
object agg w/ group by w/ fallback 22612 24210 2259 4.6 215.6 1.4X
sort agg w/o group by 5662 5715 75 18.5 54.0 5.4X
object agg w/o group by w/o fallback 5410 5428 16 19.4 51.6 5.7X
================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - percentile_approx
================================================================================================
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
object agg v.s. sort agg: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
sort agg w/ group by 710 722 6 3.0 338.5 1.0X
object agg w/ group by w/o fallback 586 599 12 3.6 279.4 1.2X
object agg w/ group by w/ fallback 752 762 7 2.8 358.4 0.9X
sort agg w/o group by 498 505 5 4.2 237.6 1.4X
object agg w/o group by w/o fallback 505 511 4 4.2 240.6 1.4X