| ================================================================================================ |
| Hive UDAF vs Spark AF |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 25.0.4+7-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 2324 2379 43 0.0 35459.6 1.0X |
| spark af w/o group by 17 21 4 3.9 256.5 138.2X |
| hive udaf w/ group by 1502 1520 12 0.0 22920.1 1.5X |
| spark af w/ group by w/o fallback 16 19 4 4.1 242.9 146.0X |
| spark af w/ group by w/ fallback 18 21 3 3.6 274.2 129.3X |
| |
| |
| ================================================================================================ |
| ObjectHashAggregateExec vs SortAggregateExec - typed_count |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 25.0.4+7-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 17247 17436 313 6.1 164.5 1.0X |
| object agg w/ group by w/o fallback 5427 5493 46 19.3 51.8 3.2X |
| object agg w/ group by w/ fallback 10561 10812 194 9.9 100.7 1.6X |
| sort agg w/o group by 3198 3253 50 32.8 30.5 5.4X |
| object agg w/o group by w/o fallback 2657 2682 24 39.5 25.3 6.5X |
| |
| |
| ================================================================================================ |
| ObjectHashAggregateExec vs SortAggregateExec - percentile_approx |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 25.0.4+7-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 312 322 10 6.7 148.9 1.0X |
| object agg w/ group by w/o fallback 249 255 4 8.4 118.8 1.3X |
| object agg w/ group by w/ fallback 350 377 14 6.0 167.1 0.9X |
| sort agg w/o group by 209 215 7 10.0 99.5 1.5X |
| object agg w/o group by w/o fallback 202 209 5 10.4 96.2 1.5X |
| |
| |
