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

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   695            722          31         22.6          44.2       1.0X
Native ORC MR                                       874            892          21         18.0          55.6       0.8X
Native ORC Vectorized                               104            127          13        151.7           6.6       6.7X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   670            700          48         23.5          42.6       1.0X
Native ORC MR                                       790            809          17         19.9          50.2       0.8X
Native ORC Vectorized                                88            116          33        179.3           5.6       7.6X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   779            817          35         20.2          49.5       1.0X
Native ORC MR                                       847            881          40         18.6          53.8       0.9X
Native ORC Vectorized                               110            125          25        142.4           7.0       7.1X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   767            789          21         20.5          48.8       1.0X
Native ORC MR                                       790            802          20         19.9          50.3       1.0X
Native ORC Vectorized                               105            116          20        149.4           6.7       7.3X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   840            858          16         18.7          53.4       1.0X
Native ORC MR                                       955            965          11         16.5          60.7       0.9X
Native ORC Vectorized                               142            161          25        110.9           9.0       5.9X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   954            975          19         16.5          60.7       1.0X
Native ORC MR                                       917            923           7         17.2          58.3       1.0X
Native ORC Vectorized                               228            258          33         69.1          14.5       4.2X


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

OpenJDK 64-Bit Server VM 21.0.10+7-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                                  1616           1656          57          6.5         154.1       1.0X
Native ORC MR                                      1548           1568          28          6.8         147.7       1.0X
Native ORC Vectorized                               645            711          67         16.3          61.5       2.5X


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

OpenJDK 64-Bit Server VM 21.0.10+7-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                     905            918          17         17.4          57.5       1.0X
Data column - Native ORC MR                        1064           1076          17         14.8          67.7       0.9X
Data column - Native ORC Vectorized                 111            124          18        141.6           7.1       8.2X
Partition column - Hive built-in ORC                734            761          38         21.4          46.7       1.2X
Partition column - Native ORC MR                    685            716          31         23.0          43.6       1.3X
Partition column - Native ORC Vectorized             41             52           9        379.7           2.6      21.9X
Both columns - Hive built-in ORC                   1005           1012          10         15.6          63.9       0.9X
Both columns - Native ORC MR                       1086           1215         182         14.5          69.1       0.8X
Both columns - Native ORC Vectorized                118            146          37        133.2           7.5       7.7X


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

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   861            900          60         12.2          82.1       1.0X
Native ORC MR                                       763            800          53         13.7          72.8       1.1X
Native ORC Vectorized                               137            143           8         76.6          13.1       6.3X


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

OpenJDK 64-Bit Server VM 21.0.10+7-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                                  1497           1512          20          7.0         142.8       1.0X
Native ORC MR                                      1264           1272          10          8.3         120.6       1.2X
Native ORC Vectorized                               301            322          10         34.9          28.7       5.0X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                  1417           1418           1          7.4         135.2       1.0X
Native ORC MR                                      1252           1288          51          8.4         119.4       1.1X
Native ORC Vectorized                               369            401          31         28.4          35.2       3.8X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   755            781          36         13.9          72.0       1.0X
Native ORC MR                                       847            848           2         12.4          80.8       0.9X
Native ORC Vectorized                               158            184          24         66.4          15.1       4.8X


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

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   618            631          15          1.7         589.1       1.0X
Native ORC MR                                        91            111          24         11.5          86.8       6.8X
Native ORC Vectorized                                35             46          14         29.9          33.5      17.6X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                  1165           1167           2          0.9        1111.4       1.0X
Native ORC MR                                        98            118          24         10.7          93.8      11.9X
Native ORC Vectorized                                41             48           9         25.5          39.2      28.4X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                  1641           1644           4          0.6        1565.4       1.0X
Native ORC MR                                       105            112           5          9.9         100.6      15.6X
Native ORC Vectorized                                49             67          14         21.3          47.0      33.3X


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

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   308            345          40          3.4         293.9       1.0X
Native ORC MR                                       213            231          34          4.9         203.2       1.4X
Native ORC Vectorized                               107            126          24          9.8         101.9       2.9X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   2141           2167          37          0.5        2041.8       1.0X
Native ORC MR                                       1724           1739          21          0.6        1644.4       1.2X
Native ORC Vectorized                                879            925          73          1.2         838.4       2.4X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                   6072           6186         161          0.2        5790.7       1.0X
Native ORC MR                                       5220           5280          85          0.2        4978.4       1.2X
Native ORC Vectorized                               5205           5250          64          0.2        4963.8       1.2X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                  13313          13534         313          0.1       12696.4       1.0X
Native ORC MR                                      12488          12528          58          0.1       11909.1       1.1X
Native ORC Vectorized                              12641          12718         109          0.1       12055.3       1.1X


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

OpenJDK 64-Bit Server VM 21.0.10+7-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                                        2128           2131           4          0.5        2029.2       1.0X
Native ORC MR                                            1907           1917          14          0.5        1819.0       1.1X
Native ORC Vectorized                                     568            596          43          1.8         541.3       3.7X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                        5783           5784           1          0.2        5515.0       1.0X
Native ORC MR                                            4244           4385         199          0.2        4047.2       1.4X
Native ORC Vectorized                                    1489           1529          57          0.7        1419.6       3.9X

OpenJDK 64-Bit Server VM 21.0.10+7-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                                        5265           5341         107          0.2        5021.2       1.0X
Native ORC MR                                            4674           4694          29          0.2        4457.3       1.1X
Native ORC Vectorized                                    1871           1910          55          0.6        1783.9       2.8X


