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

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single BOOLEAN Column Scan:           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           10112          10350         337          1.6         642.9       1.0X
SQL Json                                           7346           7379          47          2.1         467.0       1.4X
SQL Json with UnsafeRow                            8063           8098          50          2.0         512.6       1.3X
SQL Parquet Vectorized: DataPageV1                   98            108           6        160.3           6.2     103.0X
SQL Parquet Vectorized: DataPageV2                  104            116          12        151.1           6.6      97.2X
SQL Parquet MR: DataPageV1                         1654           1666          17          9.5         105.2       6.1X
SQL Parquet MR: DataPageV2                         1574           1583          13         10.0         100.1       6.4X
SQL ORC Vectorized                                  128            137           6        123.0           8.1      79.1X
SQL ORC MR                                         1444           1447           4         10.9          91.8       7.0X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Parquet Reader Single BOOLEAN Column Scan:   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                    80             81           2        197.6           5.1       1.0X
ParquetReader Vectorized: DataPageV2                    92             93           1        171.6           5.8       0.9X
ParquetReader Vectorized -> Row: DataPageV1             80             82           1        196.0           5.1       1.0X
ParquetReader Vectorized -> Row: DataPageV2             92             94           1        170.1           5.9       0.9X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            9844           9870          37          1.6         625.9       1.0X
SQL Json                                           8096           8148          74          1.9         514.7       1.2X
SQL Json with UnsafeRow                            8849           8852           5          1.8         562.6       1.1X
SQL Parquet Vectorized: DataPageV1                  102            108           7        154.9           6.5      97.0X
SQL Parquet Vectorized: DataPageV2                   99            110           7        159.2           6.3      99.6X
SQL Parquet MR: DataPageV1                         1773           1774           3          8.9         112.7       5.6X
SQL Parquet MR: DataPageV2                         1744           1756          16          9.0         110.9       5.6X
SQL ORC Vectorized                                  110            119           8        142.5           7.0      89.2X
SQL ORC MR                                         1449           1451           3         10.9          92.1       6.8X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Parquet Reader Single TINYINT Column Scan:   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                    47             49           2        336.1           3.0       1.0X
ParquetReader Vectorized: DataPageV2                    47             49           2        336.3           3.0       1.0X
ParquetReader Vectorized -> Row: DataPageV1             46             48           1        338.7           3.0       1.0X
ParquetReader Vectorized -> Row: DataPageV2             46             47           1        338.5           3.0       1.0X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           10558          10613          78          1.5         671.3       1.0X
SQL Json                                           8567           8578          16          1.8         544.7       1.2X
SQL Json with UnsafeRow                            9313           9325          18          1.7         592.1       1.1X
SQL Parquet Vectorized: DataPageV1                  130            135           3        120.8           8.3      81.1X
SQL Parquet Vectorized: DataPageV2                  154            160           6        102.3           9.8      68.7X
SQL Parquet MR: DataPageV1                         1898           1903           7          8.3         120.7       5.6X
SQL Parquet MR: DataPageV2                         1867           1887          29          8.4         118.7       5.7X
SQL ORC Vectorized                                  147            158           7        106.9           9.4      71.8X
SQL ORC MR                                         1663           1677          21          9.5         105.7       6.3X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Parquet Reader Single SMALLINT Column Scan:  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   150            153           3        104.6           9.6       1.0X
ParquetReader Vectorized: DataPageV2                   181            183           1         86.8          11.5       0.8X
ParquetReader Vectorized -> Row: DataPageV1            155            162           8        101.2           9.9       1.0X
ParquetReader Vectorized -> Row: DataPageV2            185            191           5         84.8          11.8       0.8X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           11542          11608          93          1.4         733.8       1.0X
SQL Json                                           9182           9194          17          1.7         583.8       1.3X
SQL Json with UnsafeRow                           10075          10098          32          1.6         640.6       1.1X
SQL Parquet Vectorized: DataPageV1                  125            131           5        125.8           7.9      92.3X
SQL Parquet Vectorized: DataPageV2                  200            212           9         78.5          12.7      57.6X
SQL Parquet MR: DataPageV1                         1909           1958          70          8.2         121.4       6.0X
SQL Parquet MR: DataPageV2                         1872           1880          11          8.4         119.0       6.2X
SQL ORC Vectorized                                  197            201           3         79.9          12.5      58.7X
SQL ORC MR                                         1753           1758           6          9.0         111.5       6.6X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Parquet Reader Single INT Column Scan:       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   159            163           4         98.7          10.1       1.0X
ParquetReader Vectorized: DataPageV2                   248            252           6         63.5          15.7       0.6X
ParquetReader Vectorized -> Row: DataPageV1            168            174           8         93.4          10.7       0.9X
ParquetReader Vectorized -> Row: DataPageV2            250            253           3         63.0          15.9       0.6X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           11580          11646          93          1.4         736.3       1.0X
SQL Json                                           9224           9252          40          1.7         586.5       1.3X
SQL Json with UnsafeRow                            9933           9946          18          1.6         631.5       1.2X
SQL Parquet Vectorized: DataPageV1                  273            295          10         57.6          17.4      42.4X
SQL Parquet Vectorized: DataPageV2                  253            259           3         62.1          16.1      45.7X
SQL Parquet MR: DataPageV1                         2284           2311          38          6.9         145.2       5.1X
SQL Parquet MR: DataPageV2                         1857           1885          39          8.5         118.1       6.2X
SQL ORC Vectorized                                  189            201           9         83.1          12.0      61.2X
SQL ORC MR                                         1810           1811           2          8.7         115.1       6.4X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Parquet Reader Single BIGINT Column Scan:    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   337            345           6         46.6          21.5       1.0X
ParquetReader Vectorized: DataPageV2                   294            303          10         53.4          18.7       1.1X
ParquetReader Vectorized -> Row: DataPageV1            355            358           3         44.3          22.6       1.0X
ParquetReader Vectorized -> Row: DataPageV2            298            302           7         52.8          18.9       1.1X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           11106          11116          13          1.4         706.1       1.0X
SQL Json                                          10993          11011          25          1.4         698.9       1.0X
SQL Json with UnsafeRow                           11750          11775          36          1.3         747.0       0.9X
SQL Parquet Vectorized: DataPageV1                  100            107           5        157.3           6.4     111.1X
SQL Parquet Vectorized: DataPageV2                  106            111           4        149.1           6.7     105.2X
SQL Parquet MR: DataPageV1                         1985           1998          18          7.9         126.2       5.6X
SQL Parquet MR: DataPageV2                         1906           1923          23          8.3         121.2       5.8X
SQL ORC Vectorized                                  246            258          12         63.9          15.7      45.1X
SQL ORC MR                                         1744           1781          53          9.0         110.9       6.4X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Parquet Reader Single FLOAT Column Scan:     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   148            155           6        105.9           9.4       1.0X
ParquetReader Vectorized: DataPageV2                   150            152           3        105.2           9.5       1.0X
ParquetReader Vectorized -> Row: DataPageV1            152            158           6        103.5           9.7       1.0X
ParquetReader Vectorized -> Row: DataPageV2            156            162          10        100.6           9.9       0.9X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           11628          11642          19          1.4         739.3       1.0X
SQL Json                                          11422          11434          16          1.4         726.2       1.0X
SQL Json with UnsafeRow                           12276          12335          84          1.3         780.5       0.9X
SQL Parquet Vectorized: DataPageV1                  288            296          13         54.5          18.3      40.3X
SQL Parquet Vectorized: DataPageV2                  283            286           2         55.5          18.0      41.0X
SQL Parquet MR: DataPageV1                         2337           2349          17          6.7         148.6       5.0X
SQL Parquet MR: DataPageV2                         2282           2287           7          6.9         145.1       5.1X
SQL ORC Vectorized                                  526            538          15         29.9          33.4      22.1X
SQL ORC MR                                         2101           2110          12          7.5         133.6       5.5X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Parquet Reader Single DOUBLE Column Scan:    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   353            361           6         44.6          22.4       1.0X
ParquetReader Vectorized: DataPageV2                   350            356          12         44.9          22.3       1.0X
ParquetReader Vectorized -> Row: DataPageV1            351            361           7         44.9          22.3       1.0X
ParquetReader Vectorized -> Row: DataPageV2            361            367           6         43.6          22.9       1.0X


================================================================================================
SQL Single Numeric Column Scan in Struct
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single TINYINT Column Scan in Struct:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                            2076           2085          12          7.6         132.0       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2062           2077          21          7.6         131.1       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             148            159          17        106.0           9.4      14.0X
SQL Parquet MR: DataPageV1                                            2326           2363          53          6.8         147.9       0.9X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           2712           2747          50          5.8         172.4       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             114            129          30        137.8           7.3      18.2X
SQL Parquet MR: DataPageV2                                            2278           2285          10          6.9         144.8       0.9X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2623           2665          59          6.0         166.8       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             113            119           6        139.6           7.2      18.4X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single SMALLINT Column Scan in Struct:                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                            2217           2220           5          7.1         141.0       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2212           2221          12          7.1         140.6       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             167            171           5         94.4          10.6      13.3X
SQL Parquet MR: DataPageV1                                            2441           2472          45          6.4         155.2       0.9X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           2775           2837          88          5.7         176.5       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             124            132           6        126.5           7.9      17.8X
SQL Parquet MR: DataPageV2                                            2361           2362           2          6.7         150.1       0.9X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2658           2694          52          5.9         169.0       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             153            164           9        103.0           9.7      14.5X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single INT Column Scan in Struct:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                            2240           2267          37          7.0         142.4       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2208           2236          39          7.1         140.4       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             168            180           7         93.6          10.7      13.3X
SQL Parquet MR: DataPageV1                                            2471           2513          59          6.4         157.1       0.9X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           3050           3064          20          5.2         193.9       0.7X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             126            131           6        124.5           8.0      17.7X
SQL Parquet MR: DataPageV2                                            2380           2382           3          6.6         151.3       0.9X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2947           2953           9          5.3         187.4       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             242            261          14         64.9          15.4       9.2X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single BIGINT Column Scan in Struct:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                            2275           2294          26          6.9         144.6       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2260           2263           5          7.0         143.7       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             162            180          23         97.1          10.3      14.0X
SQL Parquet MR: DataPageV1                                            2767           2770           4          5.7         175.9       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           3267           3294          38          4.8         207.7       0.7X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             293            314          12         53.7          18.6       7.8X
SQL Parquet MR: DataPageV2                                            2304           2326          32          6.8         146.5       1.0X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2803           2825          30          5.6         178.2       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             266            275           7         59.1          16.9       8.5X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single FLOAT Column Scan in Struct:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                            2364           2372          12          6.7         150.3       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2302           2323          30          6.8         146.4       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             262            266           3         60.1          16.6       9.0X
SQL Parquet MR: DataPageV1                                            2437           2446          12          6.5         154.9       1.0X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           2997           3012          21          5.2         190.5       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             108            115           6        145.3           6.9      21.8X
SQL Parquet MR: DataPageV2                                            2301           2310          12          6.8         146.3       1.0X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2922           2924           4          5.4         185.7       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             114            123           7        137.7           7.3      20.7X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Single DOUBLE Column Scan in Struct:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                            2578           2586          12          6.1         163.9       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2508           2520          16          6.3         159.5       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             525            528           4         29.9          33.4       4.9X
SQL Parquet MR: DataPageV1                                            2725           2725           1          5.8         173.2       0.9X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           3237           3247          14          4.9         205.8       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             306            313          10         51.4          19.5       8.4X
SQL Parquet MR: DataPageV2                                            2661           2665           6          5.9         169.2       1.0X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           3164           3176          18          5.0         201.1       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             287            304          12         54.8          18.2       9.0X


================================================================================================
SQL Nested Column Scan
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
SQL Nested Column Scan:                                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                           15776          16040         274          0.1       15045.4       1.0X
SQL ORC Vectorized (Nested Column Disabled)                          15887          15970          68          0.1       15151.1       1.0X
SQL ORC Vectorized (Nested Column Enabled)                            7524           7572          32          0.1        7175.6       2.1X
SQL Parquet MR: DataPageV1                                           10498          10658          87          0.1       10011.4       1.5X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)          10884          11081         121          0.1       10379.5       1.4X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)            8056           8192         102          0.1        7683.0       2.0X
SQL Parquet MR: DataPageV2                                           11173          11239          51          0.1       10655.3       1.4X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)          11605          11700          57          0.1       11067.1       1.4X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)            6282           6427          81          0.2        5990.9       2.5X


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

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           10866          10889          33          1.0        1036.3       1.0X
SQL Json                                          10470          10502          46          1.0         998.5       1.0X
SQL Parquet Vectorized: DataPageV1                 1604           1616          17          6.5         152.9       6.8X
SQL Parquet Vectorized: DataPageV2                 1859           1869          14          5.6         177.3       5.8X
SQL Parquet MR: DataPageV1                         3807           3828          31          2.8         363.0       2.9X
SQL Parquet MR: DataPageV2                         3660           3669          13          2.9         349.0       3.0X
SQL ORC Vectorized                                 1604           1612          10          6.5         153.0       6.8X
SQL ORC MR                                         3476           3477           3          3.0         331.5       3.1X


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

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            5426           5459          47          1.9         517.4       1.0X
SQL Json                                           6263           6307          63          1.7         597.3       0.9X
SQL Parquet Vectorized: DataPageV1                  442            447           5         23.7          42.1      12.3X
SQL Parquet Vectorized: DataPageV2                  428            434           4         24.5          40.8      12.7X
SQL Parquet MR: DataPageV1                         1701           1716          22          6.2         162.2       3.2X
SQL Parquet MR: DataPageV2                         1650           1667          24          6.4         157.4       3.3X
SQL ORC Vectorized                                  334            340           8         31.3          31.9      16.2X
SQL ORC MR                                         1678           1686          12          6.2         160.0       3.2X


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

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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 - CSV                                          10890          10890           0          1.4         692.4       1.0X
Data column - Json                                          9322           9439         166          1.7         592.7       1.2X
Data column - Parquet Vectorized: DataPageV1                 120            125           6        130.9           7.6      90.6X
Data column - Parquet Vectorized: DataPageV2                 256            262           5         61.3          16.3      42.5X
Data column - Parquet MR: DataPageV1                        2213           2222          13          7.1         140.7       4.9X
Data column - Parquet MR: DataPageV2                        2174           2184          15          7.2         138.2       5.0X
Data column - ORC Vectorized                                 157            170           9        100.2          10.0      69.4X
Data column - ORC MR                                        2027           2028           2          7.8         128.9       5.4X
Partition column - CSV                                      3898           3911          19          4.0         247.8       2.8X
Partition column - Json                                     8249           8256           9          1.9         524.5       1.3X
Partition column - Parquet Vectorized: DataPageV1             36             41           6        436.0           2.3     301.9X
Partition column - Parquet Vectorized: DataPageV2             35             41           6        450.9           2.2     312.2X
Partition column - Parquet MR: DataPageV1                   1136           1153          24         13.8          72.2       9.6X
Partition column - Parquet MR: DataPageV2                   1154           1164          15         13.6          73.3       9.4X
Partition column - ORC Vectorized                             35             39           6        455.0           2.2     315.1X
Partition column - ORC MR                                   1127           1129           2         14.0          71.7       9.7X
Both columns - CSV                                         10831          10835           6          1.5         688.6       1.0X
Both columns - Json                                         9398           9427          41          1.7         597.5       1.2X
Both columns - Parquet Vectorized: DataPageV1                134            140           6        117.7           8.5      81.5X
Both columns - Parquet Vectorized: DataPageV2                277            281           3         56.8          17.6      39.3X
Both columns - Parquet MR: DataPageV1                       2337           2343           9          6.7         148.6       4.7X
Both columns - Parquet MR: DataPageV2                       2255           2271          22          7.0         143.4       4.8X
Both columns - ORC Vectorized                                189            207          10         83.0          12.0      57.5X
Both columns - ORC MR                                       2091           2114          34          7.5         132.9       5.2X


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

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            7098           7105          10          1.5         676.9       1.0X
SQL Json                                           8968           8972           5          1.2         855.3       0.8X
SQL Parquet Vectorized: DataPageV1                 1034           1035           1         10.1          98.6       6.9X
SQL Parquet Vectorized: DataPageV2                 1287           1289           2          8.1         122.8       5.5X
SQL Parquet MR: DataPageV1                         3530           3532           3          3.0         336.6       2.0X
SQL Parquet MR: DataPageV2                         3234           3241          10          3.2         308.4       2.2X
ParquetReader Vectorized: DataPageV1                746            750           4         14.1          71.2       9.5X
ParquetReader Vectorized: DataPageV2               1085           1087           3          9.7         103.4       6.5X
SQL ORC Vectorized                                  709            734          35         14.8          67.6      10.0X
SQL ORC MR                                         2804           2805           1          3.7         267.4       2.5X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            5504           5577         102          1.9         524.9       1.0X
SQL Json                                           7572           7617          64          1.4         722.2       0.7X
SQL Parquet Vectorized: DataPageV1                  775            793          22         13.5          73.9       7.1X
SQL Parquet Vectorized: DataPageV2                  913            929          26         11.5          87.1       6.0X
SQL Parquet MR: DataPageV1                         2649           2687          54          4.0         252.6       2.1X
SQL Parquet MR: DataPageV2                         2662           2664           3          3.9         253.9       2.1X
ParquetReader Vectorized: DataPageV1                788            796           7         13.3          75.2       7.0X
ParquetReader Vectorized: DataPageV2                897            903           5         11.7          85.6       6.1X
SQL ORC Vectorized                                  930            967          58         11.3          88.7       5.9X
SQL ORC MR                                         2676           2715          54          3.9         255.2       2.1X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            3763           3776          19          2.8         358.8       1.0X
SQL Json                                           5158           5181          33          2.0         491.9       0.7X
SQL Parquet Vectorized: DataPageV1                  180            205          20         58.3          17.2      20.9X
SQL Parquet Vectorized: DataPageV2                  202            214          12         51.8          19.3      18.6X
SQL Parquet MR: DataPageV1                         1696           1710          20          6.2         161.8       2.2X
SQL Parquet MR: DataPageV2                         1612           1629          24          6.5         153.7       2.3X
ParquetReader Vectorized: DataPageV1                169            171           3         61.9          16.1      22.2X
ParquetReader Vectorized: DataPageV2                191            197          12         55.0          18.2      19.7X
SQL ORC Vectorized                                  279            282           5         37.6          26.6      13.5X
SQL ORC MR                                         1601           1608          10          6.5         152.7       2.4X


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

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Single Column Scan from 10 columns:       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            1466           1467           1          0.7        1398.0       1.0X
SQL Json                                           1563           1564           2          0.7        1490.3       0.9X
SQL Parquet Vectorized: DataPageV1                   28             31           5         38.0          26.3      53.1X
SQL Parquet Vectorized: DataPageV2                   36             40           5         29.0          34.5      40.5X
SQL Parquet MR: DataPageV1                          156            168           4          6.7         149.2       9.4X
SQL Parquet MR: DataPageV2                          167            172           5          6.3         159.0       8.8X
SQL ORC Vectorized                                   30             35           5         34.4          29.1      48.1X
SQL ORC MR                                          130            136           4          8.1         123.8      11.3X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Single Column Scan from 50 columns:       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            2753           2758           7          0.4        2625.4       1.0X
SQL Json                                           5031           5102         100          0.2        4798.3       0.5X
SQL Parquet Vectorized: DataPageV1                   31             37           5         34.1          29.3      89.5X
SQL Parquet Vectorized: DataPageV2                   39             43           5         26.6          37.6      69.9X
SQL Parquet MR: DataPageV1                          163            172           7          6.4         155.6      16.9X
SQL Parquet MR: DataPageV2                          163            171           7          6.4         155.6      16.9X
SQL ORC Vectorized                                   34             39           5         30.6          32.7      80.3X
SQL ORC MR                                          136            144           7          7.7         129.7      20.2X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-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
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            4438           4454          22          0.2        4232.8       1.0X
SQL Json                                           9568           9630          87          0.1        9125.2       0.5X
SQL Parquet Vectorized: DataPageV1                   36             51          11         28.9          34.6     122.2X
SQL Parquet Vectorized: DataPageV2                   44             51           6         23.6          42.4      99.8X
SQL Parquet MR: DataPageV1                          173            187           5          6.1         164.9      25.7X
SQL Parquet MR: DataPageV2                          178            184           4          5.9         170.2      24.9X
SQL ORC Vectorized                                   39             42           4         26.9          37.2     113.9X
SQL ORC MR                                          146            157           7          7.2         139.1      30.4X


