================================================================================================
SQL Single Numeric Column Scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single TINYINT Column Scan:           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   655            703          47         24.0          41.6       1.0X
Native ORC MR                                       963           1018          77         16.3          61.2       0.7X
Native ORC Vectorized                               110            135          28        142.8           7.0       5.9X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single SMALLINT Column Scan:          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   850            882          52         18.5          54.1       1.0X
Native ORC MR                                       929            984          48         16.9          59.1       0.9X
Native ORC Vectorized                               102            114          15        154.6           6.5       8.4X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single INT Column Scan:               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   980           1000          17         16.0          62.3       1.0X
Native ORC MR                                      1065           1078          20         14.8          67.7       0.9X
Native ORC Vectorized                               119            132          15        131.9           7.6       8.2X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single BIGINT Column Scan:            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   946           1011          92         16.6          60.1       1.0X
Native ORC MR                                      1028           1057          41         15.3          65.4       0.9X
Native ORC Vectorized                               119            165          34        132.4           7.6       8.0X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single FLOAT Column Scan:             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   926            970          38         17.0          58.9       1.0X
Native ORC MR                                      1095           1095           1         14.4          69.6       0.8X
Native ORC Vectorized                               151            173          20        104.2           9.6       6.1X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single DOUBLE Column Scan:            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   981           1006          35         16.0          62.4       1.0X
Native ORC MR                                      1165           1186          29         13.5          74.1       0.8X
Native ORC Vectorized                               227            246          28         69.3          14.4       4.3X


================================================================================================
Int and String Scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Int and String Scan:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                  1892           1945          75          5.5         180.5       1.0X
Native ORC MR                                      1730           1744          20          6.1         165.0       1.1X
Native ORC Vectorized                               669            689          31         15.7          63.8       2.8X


================================================================================================
Partitioned Table Scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Partitioned Table:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Data column - Hive built-in ORC                    1100           1103           5         14.3          69.9       1.0X
Data column - Native ORC MR                        1260           1282          31         12.5          80.1       0.9X
Data column - Native ORC Vectorized                 126            171          40        124.8           8.0       8.7X
Partition column - Hive built-in ORC                794            824          42         19.8          50.5       1.4X
Partition column - Native ORC MR                    662            677          13         23.8          42.1       1.7X
Partition column - Native ORC Vectorized             44             57          16        359.6           2.8      25.1X
Both columns - Hive built-in ORC                   1236           1253          24         12.7          78.6       0.9X
Both columns - Native ORC MR                       1420           1425           7         11.1          90.3       0.8X
Both columns - Native ORC Vectorized                150            168          16        105.0           9.5       7.3X


================================================================================================
Repeated String Scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Repeated String:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                  1040           1052          16         10.1          99.2       1.0X
Native ORC MR                                       933            975          69         11.2          89.0       1.1X
Native ORC Vectorized                               130            142          12         80.7          12.4       8.0X


================================================================================================
String with Nulls Scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                  1790           1817          39          5.9         170.7       1.0X
Native ORC MR                                      1548           1572          35          6.8         147.6       1.2X
Native ORC Vectorized                               316            331          10         33.2          30.1       5.7X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                  1486           1519          46          7.1         141.8       1.0X
Native ORC MR                                      1359           1366          10          7.7         129.6       1.1X
Native ORC Vectorized                               368            414          44         28.5          35.1       4.0X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                   898            921          30         11.7          85.6       1.0X
Native ORC MR                                       901            934          53         11.6          85.9       1.0X
Native ORC Vectorized                               139            193          49         75.2          13.3       6.4X


================================================================================================
Single Column Scan From Wide Columns
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                   767            779          14          1.4         731.8       1.0X
Native ORC MR                                       104            126          24         10.1          98.8       7.4X
Native ORC Vectorized                                39             52          12         26.8          37.3      19.6X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                  1393           1407          20          0.8        1328.6       1.0X
Native ORC MR                                       110            136          30          9.5         105.3      12.6X
Native ORC Vectorized                                45             52           6         23.1          43.4      30.6X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                  2006           2039          48          0.5        1912.7       1.0X
Native ORC MR                                       120            126           7          8.7         114.4      16.7X
Native ORC Vectorized                                51             60           6         20.6          48.6      39.4X


================================================================================================
Struct scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                   348            402          47          3.0         331.7       1.0X
Native ORC MR                                       347            379          27          3.0         330.8       1.0X
Native ORC Vectorized                               117            143          27          8.9         112.0       3.0X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                   2237           2282          63          0.5        2133.0       1.0X
Native ORC MR                                       1926           1953          37          0.5        1837.2       1.2X
Native ORC Vectorized                               1081           1149          96          1.0        1030.8       2.1X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                   6628           6842         303          0.2        6321.0       1.0X
Native ORC MR                                       5599           5740         199          0.2        5339.6       1.2X
Native ORC Vectorized                               5874           5882          11          0.2        5602.1       1.1X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                  13561          13563           2          0.1       12933.2       1.0X
Native ORC MR                                      11827          11860          48          0.1       11278.8       1.1X
Native ORC Vectorized                              11722          11770          68          0.1       11179.1       1.2X


================================================================================================
Nested Struct scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                        2261           2298          52          0.5        2156.2       1.0X
Native ORC MR                                            2224           2232          12          0.5        2120.6       1.0X
Native ORC Vectorized                                     677            751          72          1.5         645.2       3.3X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                        5511           5781         382          0.2        5255.9       1.0X
Native ORC MR                                            4926           5107         256          0.2        4697.8       1.1X
Native ORC Vectorized                                    1881           1890          12          0.6        1794.0       2.9X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
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                                        5577           5683         150          0.2        5318.7       1.0X
Native ORC MR                                            5646           5898         357          0.2        5384.4       1.0X
Native ORC Vectorized                                    1884           1965         114          0.6        1797.2       3.0X


