================================================================================================
Hive UDAF vs Spark AF
================================================================================================

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-Core Processor
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                             3099           3121          23          0.0       47293.2       1.0X
spark af w/o group by                                22             29           4          2.9         342.5     138.1X
hive udaf w/ group by                              2006           2051          48          0.0       30605.8       1.5X
spark af w/ group by w/o fallback                    22             27           4          2.9         343.2     137.8X
spark af w/ group by w/ fallback                     25             28           4          2.7         374.5     126.3X


================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - typed_count
================================================================================================

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-Core Processor
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                              25045          25075          43          4.2         238.8       1.0X
object agg w/ group by w/o fallback                7479           7930         348         14.0          71.3       3.3X
object agg w/ group by w/ fallback                15267          15508         267          6.9         145.6       1.6X
sort agg w/o group by                              3880           3912          40         27.0          37.0       6.5X
object agg w/o group by w/o fallback               3525           3554          25         29.7          33.6       7.1X


================================================================================================
ObjectHashAggregateExec vs SortAggregateExec - percentile_approx
================================================================================================

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-Core Processor
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                                401            410           5          5.2         191.3       1.0X
object agg w/ group by w/o fallback                 334            343           7          6.3         159.2       1.2X
object agg w/ group by w/ fallback                  452            457           5          4.6         215.4       0.9X
sort agg w/o group by                               259            267           6          8.1         123.6       1.5X
object agg w/o group by w/o fallback                247            253           6          8.5         117.9       1.6X


