| ================================================================================================ |
| 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 |
| |
| |
