| ================================================================================================ |
| filter & aggregate without group |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 36126 37069 1333 58.1 17.2 1.0X |
| range/filter/sum wholestage on 3453 3747 166 607.3 1.6 10.5X |
| |
| |
| ================================================================================================ |
| range/limit/sum |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 73 76 5 7206.6 0.1 1.0X |
| range/limit/sum wholestage on 87 95 6 6028.2 0.2 0.8X |
| |
| |
| ================================================================================================ |
| sample |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 7717 7759 60 17.0 58.9 1.0X |
| sample with replacement wholestage on 5018 5026 7 26.1 38.3 1.5X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 1808 1814 8 72.5 13.8 1.0X |
| sample without replacement wholestage on 701 743 77 186.9 5.3 2.6X |
| |
| |
| ================================================================================================ |
| collect |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 160 213 67 6.6 152.2 1.0X |
| collect 2 millions 301 430 73 3.5 286.9 0.5X |
| collect 4 millions 716 840 134 1.5 682.5 0.2X |
| |
| |
| ================================================================================================ |
| collect limit |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 162 200 66 6.5 154.4 1.0X |
| collect limit 2 millions 315 407 75 3.3 300.2 0.5X |
| |
| |
| ================================================================================================ |
| generate explode |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 11515 11594 112 1.5 686.3 1.0X |
| generate explode array wholestage on 2936 3021 82 5.7 175.0 3.9X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 23775 23804 41 0.7 1417.1 1.0X |
| generate explode map wholestage on 9691 9798 93 1.7 577.6 2.5X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 12212 12393 257 1.4 727.9 1.0X |
| generate posexplode array wholestage on 2971 3034 40 5.6 177.1 4.1X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 6705 6754 69 2.5 399.7 1.0X |
| generate inline array wholestage on 2490 2525 40 6.7 148.4 2.7X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 200 212 16 0.3 3339.2 1.0X |
| generate big struct array wholestage on 180 188 14 0.3 2996.2 1.1X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 18810 19086 390 0.0 313505.9 1.0X |
| generate big nested struct array wholestage on 173 186 13 0.3 2886.8 108.6X |
| |
| |
| ================================================================================================ |
| generate regular generator |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-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 12822 12842 28 1.3 764.3 1.0X |
| generate stack wholestage on 3056 3073 13 5.5 182.2 4.2X |
| |
| |
