| ================================================================================================ |
| filter & aggregate without group |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| range/filter/sum: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| range/filter/sum wholestage off 36339 37196 1213 57.7 17.3 1.0X |
| range/filter/sum wholestage on 3502 3770 300 598.8 1.7 10.4X |
| |
| |
| ================================================================================================ |
| range/limit/sum |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| range/limit/sum: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| range/limit/sum wholestage off 74 75 2 7125.3 0.1 1.0X |
| range/limit/sum wholestage on 75 84 7 6972.8 0.1 1.0X |
| |
| |
| ================================================================================================ |
| sample |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| sample with replacement: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| sample with replacement wholestage off 8091 8152 87 16.2 61.7 1.0X |
| sample with replacement wholestage on 5134 5156 21 25.5 39.2 1.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| sample without replacement: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------- |
| sample without replacement wholestage off 1895 1896 2 69.2 14.5 1.0X |
| sample without replacement wholestage on 657 677 13 199.6 5.0 2.9X |
| |
| |
| ================================================================================================ |
| collect |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| collect: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| collect 1 million 169 218 118 6.2 161.3 1.0X |
| collect 2 millions 309 440 84 3.4 294.7 0.5X |
| collect 4 millions 635 747 116 1.7 605.7 0.3X |
| |
| |
| ================================================================================================ |
| collect limit |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| collect limit: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| collect limit 1 million 149 230 95 7.1 141.8 1.0X |
| collect limit 2 millions 288 409 70 3.6 274.5 0.5X |
| |
| |
| ================================================================================================ |
| generate explode |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| generate explode array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| generate explode array wholestage off 12491 12542 71 1.3 744.5 1.0X |
| generate explode array wholestage on 2970 3145 175 5.6 177.0 4.2X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| generate explode map: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| generate explode map wholestage off 24462 24644 257 0.7 1458.0 1.0X |
| generate explode map wholestage on 9106 9313 230 1.8 542.7 2.7X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| generate posexplode array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| generate posexplode array wholestage off 12603 12606 4 1.3 751.2 1.0X |
| generate posexplode array wholestage on 3011 3097 49 5.6 179.5 4.2X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| generate inline array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| generate inline array wholestage off 6943 6983 57 2.4 413.8 1.0X |
| generate inline array wholestage on 2498 2566 75 6.7 148.9 2.8X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| generate big struct array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| generate big struct array wholestage off 192 198 8 0.3 3201.2 1.0X |
| generate big struct array wholestage on 152 161 8 0.4 2526.6 1.3X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| generate big nested struct array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------------- |
| generate big nested struct array wholestage off 18968 20994 2866 0.0 316136.8 1.0X |
| generate big nested struct array wholestage on 153 161 9 0.4 2544.7 124.2X |
| |
| |
| ================================================================================================ |
| generate regular generator |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| generate stack: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| generate stack wholestage off 13409 13455 66 1.3 799.2 1.0X |
| generate stack wholestage on 3050 3056 4 5.5 181.8 4.4X |
| |
| |
