| ================================================================================================ |
| filter & aggregate without group |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 39354 39673 451 53.3 18.8 1.0X |
| range/filter/sum wholestage on 3472 3578 64 604.1 1.7 11.3X |
| |
| |
| ================================================================================================ |
| range/limit/sum |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 59 62 4 8881.1 0.1 1.0X |
| range/limit/sum wholestage on 60 67 7 8666.1 0.1 1.0X |
| |
| |
| ================================================================================================ |
| sample |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 8093 8118 35 16.2 61.7 1.0X |
| sample with replacement wholestage on 5100 5122 18 25.7 38.9 1.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 2716 2724 12 48.3 20.7 1.0X |
| sample without replacement wholestage on 652 659 8 200.9 5.0 4.2X |
| |
| |
| ================================================================================================ |
| collect |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 149 227 52 7.0 142.0 1.0X |
| collect 2 millions 288 413 105 3.6 274.5 0.5X |
| collect 4 millions 780 831 85 1.3 743.8 0.2X |
| |
| |
| ================================================================================================ |
| collect limit |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 156 222 55 6.7 148.8 1.0X |
| collect limit 2 millions 322 441 83 3.3 307.4 0.5X |
| |
| |
| ================================================================================================ |
| generate explode |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 12087 12259 244 1.4 720.4 1.0X |
| generate explode array wholestage on 3313 3473 99 5.1 197.5 3.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 24473 24489 22 0.7 1458.7 1.0X |
| generate explode map wholestage on 9589 9743 163 1.7 571.6 2.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 12779 12830 72 1.3 761.7 1.0X |
| generate posexplode array wholestage on 3340 3492 89 5.0 199.1 3.8X |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 7039 7047 12 2.4 419.5 1.0X |
| generate inline array wholestage on 2712 2806 80 6.2 161.6 2.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 188 196 11 0.3 3127.5 1.0X |
| generate big struct array wholestage on 149 169 16 0.4 2484.0 1.3X |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 21562 21565 4 0.0 359373.5 1.0X |
| generate big nested struct array wholestage on 143 161 17 0.4 2378.5 151.1X |
| |
| |
| ================================================================================================ |
| generate regular generator |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.3+9-LTS on Linux 6.5.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 13383 13385 2 1.3 797.7 1.0X |
| generate stack wholestage on 3139 3149 11 5.3 187.1 4.3X |
| |
| |