-
Notifications
You must be signed in to change notification settings - Fork 28k
/
ObjectHashAggregateExecBenchmark-jdk11-results.txt
45 lines (36 loc) · 3.51 KB
/
ObjectHashAggregateExecBenchmark-jdk11-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 11.0.17+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
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 8275 8310 48 0.0 126260.6 1.0X
spark af w/o group by 42 69 29 1.5 645.6 195.6X
hive udaf w/ group by 5952 6035 72 0.0 90821.2 1.4X
spark af w/ group by w/o fallback 45 59 9 1.5 683.8 184.6X
spark af w/ group by w/ fallback 55 66 8 1.2 833.9 151.4X
================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - typed_count
================================================================================================
OpenJDK 64-Bit Server VM 11.0.17+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
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 46425 46425 0 2.3 442.7 1.0X
object agg w/ group by w/o fallback 10283 10565 233 10.2 98.1 4.5X
object agg w/ group by w/ fallback 26406 32033 2827 4.0 251.8 1.8X
sort agg w/o group by 7085 7489 307 14.8 67.6 6.6X
object agg w/o group by w/o fallback 6438 6549 94 16.3 61.4 7.2X
================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - percentile_approx
================================================================================================
OpenJDK 64-Bit Server VM 11.0.17+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
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 886 1006 91 2.4 422.4 1.0X
object agg w/ group by w/o fallback 727 838 84 2.9 346.6 1.2X
object agg w/ group by w/ fallback 890 1086 215 2.4 424.6 1.0X
sort agg w/o group by 643 748 80 3.3 306.7 1.4X
object agg w/o group by w/o fallback 614 748 90 3.4 292.8 1.4X