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

OpenJDK 64-Bit Server VM 21.0.12+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                             4040           4191         100          0.0       61641.7       1.0X
spark af w/o group by                                22             29           7          3.0         336.4     183.2X
hive udaf w/ group by                              2074           2094          19          0.0       31652.5       1.9X
spark af w/ group by w/o fallback                    22             27           5          3.0         331.6     185.9X
spark af w/ group by w/ fallback                     25             29           6          2.6         378.5     162.9X


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

OpenJDK 64-Bit Server VM 21.0.12+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                              24294          24624         467          4.3         231.7       1.0X
object agg w/ group by w/o fallback                7140           7167          26         14.7          68.1       3.4X
object agg w/ group by w/ fallback                15006          15111         158          7.0         143.1       1.6X
sort agg w/o group by                              3966           4034          47         26.4          37.8       6.1X
object agg w/o group by w/o fallback               3601           3672          52         29.1          34.3       6.7X


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

OpenJDK 64-Bit Server VM 21.0.12+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                                402            436          14          5.2         191.8       1.0X
object agg w/ group by w/o fallback                 314            322           4          6.7         149.6       1.3X
object agg w/ group by w/ fallback                  450            462          14          4.7         214.8       0.9X
sort agg w/o group by                               264            269           3          7.9         126.0       1.5X
object agg w/o group by w/o fallback                251            257           4          8.3         119.8       1.6X


