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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   705            775         121         22.3          44.8       1.0X
Native ORC MR                                       751            817          70         21.0          47.7       0.9X
Native ORC Vectorized                               102            117          11        154.4           6.5       6.9X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   720            738          19         21.8          45.8       1.0X
Native ORC MR                                       714            764          60         22.0          45.4       1.0X
Native ORC Vectorized                                87            100          11        181.5           5.5       8.3X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   717            739          23         21.9          45.6       1.0X
Native ORC MR                                       786            813          35         20.0          50.0       0.9X
Native ORC Vectorized                                96            111          11        163.6           6.1       7.5X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   722            734          14         21.8          45.9       1.0X
Native ORC MR                                       766            786          23         20.5          48.7       0.9X
Native ORC Vectorized                                92            100           9        170.8           5.9       7.8X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   768            798          28         20.5          48.8       1.0X
Native ORC MR                                       803            817          12         19.6          51.1       1.0X
Native ORC Vectorized                               143            152          10        110.1           9.1       5.4X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   849            854           6         18.5          54.0       1.0X
Native ORC MR                                       881            909          42         17.8          56.0       1.0X
Native ORC Vectorized                               228            243          21         69.0          14.5       3.7X


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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                  1442           1461          27          7.3         137.5       1.0X
Native ORC MR                                      1415           1422          11          7.4         134.9       1.0X
Native ORC Vectorized                               625            630           5         16.8          59.6       2.3X


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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                     814            846          29         19.3          51.8       1.0X
Data column - Native ORC MR                         901            942          40         17.5          57.3       0.9X
Data column - Native ORC Vectorized                  92            102           7        170.8           5.9       8.8X
Partition column - Hive built-in ORC                658            664           6         23.9          41.9       1.2X
Partition column - Native ORC MR                    594            606          19         26.5          37.8       1.4X
Partition column - Native ORC Vectorized             38             49           8        410.1           2.4      21.2X
Both columns - Hive built-in ORC                    925            955          27         17.0          58.8       0.9X
Both columns - Native ORC MR                        988           1003          22         15.9          62.8       0.8X
Both columns - Native ORC Vectorized                104            113           7        150.6           6.6       7.8X


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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-Core Processor
Repeated String:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   867            880          19         12.1          82.7       1.0X
Native ORC MR                                       755            761           7         13.9          72.0       1.1X
Native ORC Vectorized                               141            151          16         74.3          13.5       6.1X


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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                  1443           1452          13          7.3         137.6       1.0X
Native ORC MR                                      1252           1268          22          8.4         119.4       1.2X
Native ORC Vectorized                               302            312          13         34.7          28.8       4.8X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                  1230           1232           3          8.5         117.3       1.0X
Native ORC MR                                      1143           1149           8          9.2         109.0       1.1X
Native ORC Vectorized                               369            415          37         28.4          35.2       3.3X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   736            745           8         14.2          70.2       1.0X
Native ORC MR                                       737            774          61         14.2          70.3       1.0X
Native ORC Vectorized                               154            167          13         68.0          14.7       4.8X


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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   439            488          38          2.4         418.5       1.0X
Native ORC MR                                        86             98          11         12.2          82.0       5.1X
Native ORC Vectorized                                32             37           4         32.3          30.9      13.5X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   786            814          35          1.3         749.5       1.0X
Native ORC MR                                        92            106          10         11.4          87.7       8.5X
Native ORC Vectorized                                39             46           6         26.7          37.5      20.0X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                  1122           1159          52          0.9        1070.1       1.0X
Native ORC MR                                       102            121          18         10.3          97.2      11.0X
Native ORC Vectorized                                48             54           6         21.9          45.7      23.4X


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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   360            375          26          2.9         343.4       1.0X
Native ORC MR                                       288            299           8          3.6         274.9       1.2X
Native ORC Vectorized                               122            147          12          8.6         116.7       2.9X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   2562           2596          48          0.4        2443.5       1.0X
Native ORC MR                                       1676           1721          63          0.6        1598.2       1.5X
Native ORC Vectorized                                870            945          88          1.2         829.5       2.9X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                   7334           7478         203          0.1        6994.5       1.0X
Native ORC MR                                       5205           5277         102          0.2        4964.0       1.4X
Native ORC Vectorized                               5192           5287         134          0.2        4951.5       1.4X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                  15834          15862          40          0.1       15100.3       1.0X
Native ORC MR                                      12078          12110          46          0.1       11518.4       1.3X
Native ORC Vectorized                              12177          12199          31          0.1       11613.2       1.3X


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

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                        2443           2450           9          0.4        2330.0       1.0X
Native ORC MR                                            1870           1872           3          0.6        1783.3       1.3X
Native ORC Vectorized                                     673            695          19          1.6         642.3       3.6X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                        7548           7575          38          0.1        7198.3       1.0X
Native ORC MR                                            4782           4881         139          0.2        4560.9       1.6X
Native ORC Vectorized                                    1557           1602          64          0.7        1485.0       4.8X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
AMD EPYC 9V74 80-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                                        6356           6422          94          0.2        6061.2       1.0X
Native ORC MR                                            4911           4949          54          0.2        4683.2       1.3X
Native ORC Vectorized                                    1928           1993          92          0.5        1838.4       3.3X


