| ================================================================================================ |
| Hive UDAF vs Spark AF |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-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 3050 3218 95 0.0 46543.3 1.0X |
| spark af w/o group by 20 25 5 3.3 300.8 154.7X |
| hive udaf w/ group by 2055 2066 10 0.0 31350.2 1.5X |
| spark af w/ group by w/o fallback 22 26 4 2.9 343.3 135.6X |
| spark af w/ group by w/ fallback 26 29 3 2.5 395.7 117.6X |
| |
| |
| ================================================================================================ |
| ObjectHashAggregateExec vs SortAggregateExec - typed_count |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-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 24522 24800 394 4.3 233.9 1.0X |
| object agg w/ group by w/o fallback 7249 7618 194 14.5 69.1 3.4X |
| object agg w/ group by w/ fallback 15805 16342 665 6.6 150.7 1.6X |
| sort agg w/o group by 4098 4134 24 25.6 39.1 6.0X |
| object agg w/o group by w/o fallback 3459 3498 33 30.3 33.0 7.1X |
| |
| |
| ================================================================================================ |
| ObjectHashAggregateExec vs SortAggregateExec - percentile_approx |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-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 418 426 6 5.0 199.5 1.0X |
| object agg w/ group by w/o fallback 351 356 5 6.0 167.4 1.2X |
| object agg w/ group by w/ fallback 449 461 14 4.7 214.0 0.9X |
| sort agg w/o group by 274 281 3 7.7 130.7 1.5X |
| object agg w/o group by w/o fallback 268 274 3 7.8 127.8 1.6X |
| |
| |
