| ================================================================================================ |
| SQL Single Numeric Column Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| SQL Single TINYINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 633 690 90 24.9 40.2 1.0X |
| Native ORC MR 765 794 38 20.6 48.6 0.8X |
| Native ORC Vectorized 93 109 12 170.0 5.9 6.8X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| SQL Single SMALLINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 641 685 46 24.5 40.8 1.0X |
| Native ORC MR 724 727 4 21.7 46.0 0.9X |
| Native ORC Vectorized 81 96 12 193.7 5.2 7.9X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| SQL Single INT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 671 683 13 23.4 42.7 1.0X |
| Native ORC MR 711 775 60 22.1 45.2 0.9X |
| Native ORC Vectorized 89 101 8 177.7 5.6 7.6X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| SQL Single BIGINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 682 722 40 23.1 43.4 1.0X |
| Native ORC MR 724 728 4 21.7 46.0 0.9X |
| Native ORC Vectorized 87 96 10 181.0 5.5 7.8X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| SQL Single FLOAT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 709 735 45 22.2 45.1 1.0X |
| Native ORC MR 807 812 6 19.5 51.3 0.9X |
| Native ORC Vectorized 140 146 9 112.2 8.9 5.1X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| SQL Single DOUBLE Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 783 822 64 20.1 49.8 1.0X |
| Native ORC MR 869 890 24 18.1 55.2 0.9X |
| Native ORC Vectorized 223 232 7 70.5 14.2 3.5X |
| |
| |
| ================================================================================================ |
| Int and String Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Int and String Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 1440 1443 4 7.3 137.3 1.0X |
| Native ORC MR 1402 1437 49 7.5 133.7 1.0X |
| Native ORC Vectorized 591 599 7 17.7 56.4 2.4X |
| |
| |
| ================================================================================================ |
| Partitioned Table Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Partitioned Table: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Data column - Hive built-in ORC 816 831 23 19.3 51.9 1.0X |
| Data column - Native ORC MR 907 939 48 17.3 57.7 0.9X |
| Data column - Native ORC Vectorized 89 101 9 175.8 5.7 9.1X |
| Partition column - Hive built-in ORC 613 621 7 25.7 38.9 1.3X |
| Partition column - Native ORC MR 578 608 22 27.2 36.8 1.4X |
| Partition column - Native ORC Vectorized 38 48 7 413.0 2.4 21.4X |
| Both columns - Hive built-in ORC 960 976 17 16.4 61.0 0.9X |
| Both columns - Native ORC MR 999 1037 54 15.7 63.5 0.8X |
| Both columns - Native ORC Vectorized 105 126 10 149.7 6.7 7.8X |
| |
| |
| ================================================================================================ |
| Repeated String Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Repeated String: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 838 844 6 12.5 79.9 1.0X |
| Native ORC MR 740 746 5 14.2 70.6 1.1X |
| Native ORC Vectorized 133 140 10 79.1 12.7 6.3X |
| |
| |
| ================================================================================================ |
| String with Nulls Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| String with Nulls Scan (0.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 1499 1530 45 7.0 142.9 1.0X |
| Native ORC MR 1245 1286 58 8.4 118.7 1.2X |
| Native ORC Vectorized 289 305 18 36.3 27.6 5.2X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| String with Nulls Scan (50.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 1232 1237 8 8.5 117.5 1.0X |
| Native ORC MR 1134 1156 31 9.2 108.2 1.1X |
| Native ORC Vectorized 344 357 13 30.5 32.8 3.6X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| String with Nulls Scan (95.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 701 704 7 15.0 66.8 1.0X |
| Native ORC MR 720 736 25 14.6 68.7 1.0X |
| Native ORC Vectorized 154 176 22 68.1 14.7 4.6X |
| |
| |
| ================================================================================================ |
| Single Column Scan From Wide Columns |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Single Column Scan from 100 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 419 452 36 2.5 399.4 1.0X |
| Native ORC MR 84 103 15 12.4 80.4 5.0X |
| Native ORC Vectorized 32 37 4 32.5 30.8 13.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Single Column Scan from 200 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 730 736 7 1.4 696.3 1.0X |
| Native ORC MR 93 106 12 11.3 88.2 7.9X |
| Native ORC Vectorized 43 49 5 24.3 41.2 16.9X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Single Column Scan from 300 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 1085 1088 3 1.0 1035.1 1.0X |
| Native ORC MR 105 120 11 10.0 99.8 10.4X |
| Native ORC Vectorized 48 58 8 21.7 46.0 22.5X |
| |
| |
| ================================================================================================ |
| Struct scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Single Struct Column Scan with 10 Fields: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 469 484 9 2.2 447.6 1.0X |
| Native ORC MR 293 295 1 3.6 279.6 1.6X |
| Native ORC Vectorized 134 145 8 7.8 127.4 3.5X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Single Struct Column Scan with 100 Fields: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------- |
| Hive built-in ORC 2977 3012 49 0.4 2839.1 1.0X |
| Native ORC MR 1648 1657 13 0.6 1571.9 1.8X |
| Native ORC Vectorized 1058 1073 21 1.0 1009.3 2.8X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Single Struct Column Scan with 300 Fields: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------- |
| Hive built-in ORC 8718 8875 221 0.1 8314.2 1.0X |
| Native ORC MR 5706 5708 3 0.2 5441.5 1.5X |
| Native ORC Vectorized 5543 5621 110 0.2 5286.1 1.6X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Single Struct Column Scan with 600 Fields: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------- |
| Hive built-in ORC 18608 18614 8 0.1 17746.2 1.0X |
| Native ORC MR 13003 13134 187 0.1 12400.2 1.4X |
| Native ORC Vectorized 13037 13128 128 0.1 12433.0 1.4X |
| |
| |
| ================================================================================================ |
| Nested Struct scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Nested Struct Scan with 10 Elements, 10 Fields: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 3055 3149 132 0.3 2913.7 1.0X |
| Native ORC MR 1986 2077 129 0.5 1893.9 1.5X |
| Native ORC Vectorized 666 678 12 1.6 634.9 4.6X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Nested Struct Scan with 30 Elements, 10 Fields: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 9228 9232 6 0.1 8800.2 1.0X |
| Native ORC MR 4661 4696 49 0.2 4445.4 2.0X |
| Native ORC Vectorized 1598 1626 39 0.7 1523.8 5.8X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Nested Struct Scan with 10 Elements, 30 Fields: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------------ |
| Hive built-in ORC 7773 7788 20 0.1 7413.3 1.0X |
| Native ORC MR 5252 5272 27 0.2 5008.9 1.5X |
| Native ORC Vectorized 2071 2134 90 0.5 1974.9 3.8X |
| |
| |
