-
Notifications
You must be signed in to change notification settings - Fork 28k
/
ObjectHashAggregateExecBenchmark-results.txt
45 lines (36 loc) · 3.53 KB
/
ObjectHashAggregateExecBenchmark-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 1.8.0_352-b08 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 5335 5422 90 0.0 81411.4 1.0X
spark af w/o group by 37 43 6 1.8 565.0 144.1X
hive udaf w/ group by 4248 4256 7 0.0 64823.0 1.3X
spark af w/ group by w/o fallback 39 43 6 1.7 590.9 137.8X
spark af w/ group by w/ fallback 77 80 6 0.9 1174.1 69.3X
================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - typed_count
================================================================================================
OpenJDK 64-Bit Server VM 1.8.0_352-b08 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 31660 31771 156 3.3 301.9 1.0X
object agg w/ group by w/o fallback 8506 8654 166 12.3 81.1 3.7X
object agg w/ group by w/ fallback 17695 18113 432 5.9 168.8 1.8X
sort agg w/o group by 5182 5211 25 20.2 49.4 6.1X
object agg w/o group by w/o fallback 4595 4633 78 22.8 43.8 6.9X
================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - percentile_approx
================================================================================================
OpenJDK 64-Bit Server VM 1.8.0_352-b08 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 647 657 6 3.2 308.3 1.0X
object agg w/ group by w/o fallback 538 556 9 3.9 256.7 1.2X
object agg w/ group by w/ fallback 643 657 9 3.3 306.6 1.0X
sort agg w/o group by 466 483 7 4.5 222.2 1.4X
object agg w/o group by w/o fallback 511 524 8 4.1 243.5 1.3X