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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
SQL Single TINYINT Column Scan:           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   471            507          38         33.4          29.9       1.0X
Native ORC MR                                       460            501          49         34.2          29.2       1.0X
Native ORC Vectorized                                73             88          11        214.9           4.7       6.4X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
SQL Single SMALLINT Column Scan:          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   403            420          19         39.0          25.6       1.0X
Native ORC MR                                       432            468          59         36.4          27.5       0.9X
Native ORC Vectorized                                70             84          12        223.6           4.5       5.7X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
SQL Single INT Column Scan:               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   441            452          17         35.7          28.0       1.0X
Native ORC MR                                       503            596         132         31.3          32.0       0.9X
Native ORC Vectorized                                80             88           7        196.3           5.1       5.5X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
SQL Single BIGINT Column Scan:            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   426            453          18         36.9          27.1       1.0X
Native ORC MR                                       448            496          41         35.1          28.5       1.0X
Native ORC Vectorized                                77             86           7        205.0           4.9       5.6X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
SQL Single FLOAT Column Scan:             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   485            492           4         32.4          30.9       1.0X
Native ORC MR                                       504            551          64         31.2          32.1       1.0X
Native ORC Vectorized                               119            123           3        132.6           7.5       4.1X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
SQL Single DOUBLE Column Scan:            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   508            513           4         30.9          32.3       1.0X
Native ORC MR                                       625            656          51         25.2          39.7       0.8X
Native ORC Vectorized                               166            178          14         94.7          10.6       3.1X


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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
Int and String Scan:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   974           1009          50         10.8          92.9       1.0X
Native ORC MR                                       906            956          43         11.6          86.4       1.1X
Native ORC Vectorized                               493            501           7         21.3          47.0       2.0X


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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
Partitioned Table:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Data column - Hive built-in ORC                     559            589          20         28.1          35.6       1.0X
Data column - Native ORC MR                         556            583          34         28.3          35.4       1.0X
Data column - Native ORC Vectorized                  79             88           7        199.6           5.0       7.1X
Partition column - Hive built-in ORC                391            398           8         40.3          24.8       1.4X
Partition column - Native ORC MR                    357            372          10         44.0          22.7       1.6X
Partition column - Native ORC Vectorized             53             63           5        295.0           3.4      10.5X
Both columns - Hive built-in ORC                    551            581          21         28.6          35.0       1.0X
Both columns - Native ORC MR                        648            669          17         24.3          41.2       0.9X
Both columns - Native ORC Vectorized                 87            101           9        180.6           5.5       6.4X


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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
Repeated String:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Hive built-in ORC                                   527            534          13         19.9          50.2       1.0X
Native ORC MR                                       486            517          42         21.6          46.3       1.1X
Native ORC Vectorized                               102            108           5        102.6           9.7       5.2X


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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   940           1021         115         11.2          89.6       1.0X
Native ORC MR                                       756            789          40         13.9          72.1       1.2X
Native ORC Vectorized                               227            231           4         46.1          21.7       4.1X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   838            855          18         12.5          79.9       1.0X
Native ORC MR                                       753            772          21         13.9          71.8       1.1X
Native ORC Vectorized                               298            332          38         35.2          28.4       2.8X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   490            510          26         21.4          46.7       1.0X
Native ORC MR                                       446            459          21         23.5          42.6       1.1X
Native ORC Vectorized                               105            116          11         99.7          10.0       4.7X


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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   312            334          39          3.4         297.5       1.0X
Native ORC MR                                        55             64           8         19.1          52.3       5.7X
Native ORC Vectorized                                28             34           6         37.7          26.5      11.2X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   520            537          23          2.0         495.7       1.0X
Native ORC MR                                        62             70           9         16.8          59.5       8.3X
Native ORC Vectorized                                34             44           7         30.9          32.4      15.3X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   740            750          10          1.4         705.9       1.0X
Native ORC MR                                        70             77           5         15.1          66.3      10.6X
Native ORC Vectorized                                41             43           3         25.7          38.8      18.2X


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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   210            239          30          5.0         199.8       1.0X
Native ORC MR                                       153            158           4          6.8         146.1       1.4X
Native ORC Vectorized                                82             90           6         12.8          78.2       2.6X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   1591           1609          26          0.7        1517.1       1.0X
Native ORC MR                                       1126           1155          41          0.9        1073.5       1.4X
Native ORC Vectorized                                735            751          18          1.4         701.2       2.2X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                   4932           5059         180          0.2        4703.4       1.0X
Native ORC MR                                       3661           3760         140          0.3        3491.5       1.3X
Native ORC Vectorized                               3803           3830          38          0.3        3626.8       1.3X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                  10500          10617         166          0.1       10013.3       1.0X
Native ORC MR                                       8708           8820         159          0.1        8304.2       1.2X
Native ORC Vectorized                               8964           9020          80          0.1        8548.4       1.2X


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

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                        1480           1566         122          0.7        1411.0       1.0X
Native ORC MR                                            1419           1487          96          0.7        1353.7       1.0X
Native ORC Vectorized                                     431            456          21          2.4         411.3       3.4X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                        4041           4163         172          0.3        3853.5       1.0X
Native ORC MR                                            3030           3276         348          0.3        2889.4       1.3X
Native ORC Vectorized                                     923            980          68          1.1         880.4       4.4X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) 6973P-C
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                                        3902           3954          74          0.3        3721.3       1.0X
Native ORC MR                                            3395           3501         149          0.3        3238.0       1.1X
Native ORC Vectorized                                    1138           1153          21          0.9        1085.4       3.4X


