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

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Single BOOLEAN Column Scan:           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           10371          10431          85          1.5         659.4       1.0X
SQL Json                                           7575           7729         218          2.1         481.6       1.4X
SQL Json with UnsafeRow                            8696           8712          24          1.8         552.9       1.2X
SQL Parquet Vectorized: DataPageV1                   88             95           7        178.6           5.6     117.7X
SQL Parquet Vectorized: DataPageV2                   93            102           8        168.3           5.9     111.0X
SQL Parquet MR: DataPageV1                         1759           1761           3          8.9         111.9       5.9X
SQL Parquet MR: DataPageV2                         1636           1644          11          9.6         104.0       6.3X
SQL ORC Vectorized                                  139            145           7        113.4           8.8      74.8X
SQL ORC MR                                         1561           1575          19         10.1          99.3       6.6X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Parquet Reader Single BOOLEAN Column Scan:   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                    91             92           1        172.6           5.8       1.0X
ParquetReader Vectorized: DataPageV2                   105            107           2        149.2           6.7       0.9X
ParquetReader Vectorized -> Row: DataPageV1             72             74           2        217.6           4.6       1.3X
ParquetReader Vectorized -> Row: DataPageV2             88             89           1        178.8           5.6       1.0X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Single TINYINT Column Scan:           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            9487           9506          27          1.7         603.2       1.0X
SQL Json                                           8686           8698          17          1.8         552.2       1.1X
SQL Json with UnsafeRow                            9338           9341           5          1.7         593.7       1.0X
SQL Parquet Vectorized: DataPageV1                   93            103           7        168.5           5.9     101.6X
SQL Parquet Vectorized: DataPageV2                   91            105           9        171.9           5.8     103.7X
SQL Parquet MR: DataPageV1                         1947           1957          14          8.1         123.8       4.9X
SQL Parquet MR: DataPageV2                         1883           1892          12          8.4         119.7       5.0X
SQL ORC Vectorized                                  111            125           9        141.5           7.1      85.3X
SQL ORC MR                                         1788           1796          11          8.8         113.7       5.3X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Parquet Reader Single TINYINT Column Scan:   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                    77             78           1        203.7           4.9       1.0X
ParquetReader Vectorized: DataPageV2                    78             78           1        202.4           4.9       1.0X
ParquetReader Vectorized -> Row: DataPageV1             49             50           1        322.6           3.1       1.6X
ParquetReader Vectorized -> Row: DataPageV2             49             51           2        320.9           3.1       1.6X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Single SMALLINT Column Scan:          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            9786           9788           2          1.6         622.2       1.0X
SQL Json                                           9669           9673           6          1.6         614.7       1.0X
SQL Json with UnsafeRow                           10439          10446          11          1.5         663.7       0.9X
SQL Parquet Vectorized: DataPageV1                  134            140           4        117.7           8.5      73.2X
SQL Parquet Vectorized: DataPageV2                  152            155           3        103.4           9.7      64.4X
SQL Parquet MR: DataPageV1                         2016           2052          50          7.8         128.2       4.9X
SQL Parquet MR: DataPageV2                         2110           2127          25          7.5         134.1       4.6X
SQL ORC Vectorized                                  161            163           2         98.0          10.2      61.0X
SQL ORC MR                                         1722           1738          23          9.1         109.5       5.7X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Parquet Reader Single SMALLINT Column Scan:  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   167            171           4         94.0          10.6       1.0X
ParquetReader Vectorized: DataPageV2                   193            197           2         81.5          12.3       0.9X
ParquetReader Vectorized -> Row: DataPageV1            171            179           8         92.1          10.9       1.0X
ParquetReader Vectorized -> Row: DataPageV2            203            204           2         77.6          12.9       0.8X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Single INT Column Scan:               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           11008          11010           3          1.4         699.9       1.0X
SQL Json                                          10119          10131          18          1.6         643.3       1.1X
SQL Json with UnsafeRow                           10856          10869          19          1.4         690.2       1.0X
SQL Parquet Vectorized: DataPageV1                  109            119           7        144.2           6.9     100.9X
SQL Parquet Vectorized: DataPageV2                  194            203           5         80.9          12.4      56.6X
SQL Parquet MR: DataPageV1                         1960           1964           6          8.0         124.6       5.6X
SQL Parquet MR: DataPageV2                         2081           2094          19          7.6         132.3       5.3X
SQL ORC Vectorized                                  175            183           7         89.9          11.1      62.9X
SQL ORC MR                                         1778           1787          13          8.8         113.0       6.2X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Parquet Reader Single INT Column Scan:       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   152            154           2        103.4           9.7       1.0X
ParquetReader Vectorized: DataPageV2                   240            243           2         65.4          15.3       0.6X
ParquetReader Vectorized -> Row: DataPageV1            155            161           3        101.4           9.9       1.0X
ParquetReader Vectorized -> Row: DataPageV2            241            245           3         65.1          15.4       0.6X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Single BIGINT Column Scan:            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           10731          10742          15          1.5         682.2       1.0X
SQL Json                                          10105          10114          13          1.6         642.5       1.1X
SQL Json with UnsafeRow                           10865          10868           6          1.4         690.7       1.0X
SQL Parquet Vectorized: DataPageV1                  302            315          10         52.1          19.2      35.6X
SQL Parquet Vectorized: DataPageV2                  257            270           7         61.3          16.3      41.8X
SQL Parquet MR: DataPageV1                         2430           2434           5          6.5         154.5       4.4X
SQL Parquet MR: DataPageV2                         1911           1930          27          8.2         121.5       5.6X
SQL ORC Vectorized                                  180            201           8         87.2          11.5      59.5X
SQL ORC MR                                         1761           1788          38          8.9         111.9       6.1X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Parquet Reader Single BIGINT Column Scan:    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   335            338           3         46.9          21.3       1.0X
ParquetReader Vectorized: DataPageV2                   299            303           4         52.7          19.0       1.1X
ParquetReader Vectorized -> Row: DataPageV1            343            344           1         45.9          21.8       1.0X
ParquetReader Vectorized -> Row: DataPageV2            284            288           4         55.4          18.0       1.2X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Single FLOAT Column Scan:             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           10942          10942           1          1.4         695.6       1.0X
SQL Json                                          11987          12003          22          1.3         762.1       0.9X
SQL Json with UnsafeRow                           12629          12643          19          1.2         802.9       0.9X
SQL Parquet Vectorized: DataPageV1                  105            110           3        149.2           6.7     103.8X
SQL Parquet Vectorized: DataPageV2                  105            110           5        149.4           6.7     103.9X
SQL Parquet MR: DataPageV1                         2017           2064          66          7.8         128.2       5.4X
SQL Parquet MR: DataPageV2                         1936           1966          42          8.1         123.1       5.7X
SQL ORC Vectorized                                  240            258          13         65.6          15.2      45.7X
SQL ORC MR                                         1906           1915          12          8.3         121.2       5.7X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Parquet Reader Single FLOAT Column Scan:     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   151            153           1        103.9           9.6       1.0X
ParquetReader Vectorized: DataPageV2                   156            158           2        100.7           9.9       1.0X
ParquetReader Vectorized -> Row: DataPageV1            162            163           1         97.2          10.3       0.9X
ParquetReader Vectorized -> Row: DataPageV2            162            163           2         97.1          10.3       0.9X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Single DOUBLE Column Scan:            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           11259          11262           4          1.4         715.8       1.0X
SQL Json                                          12322          12323           2          1.3         783.4       0.9X
SQL Json with UnsafeRow                           13017          13024          10          1.2         827.6       0.9X
SQL Parquet Vectorized: DataPageV1                  294            302           6         53.5          18.7      38.3X
SQL Parquet Vectorized: DataPageV2                  291            295           3         54.0          18.5      38.6X
SQL Parquet MR: DataPageV1                         2505           2511           7          6.3         159.3       4.5X
SQL Parquet MR: DataPageV2                         2488           2496          11          6.3         158.2       4.5X
SQL ORC Vectorized                                  583            587           3         27.0          37.1      19.3X
SQL ORC MR                                         2250           2256           9          7.0         143.0       5.0X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Parquet Reader Single DOUBLE Column Scan:    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------
ParquetReader Vectorized: DataPageV1                   346            361           8         45.4          22.0       1.0X
ParquetReader Vectorized: DataPageV2                   344            360          10         45.7          21.9       1.0X
ParquetReader Vectorized -> Row: DataPageV1            355            369           9         44.4          22.5       1.0X
ParquetReader Vectorized -> Row: DataPageV2            349            360          12         45.1          22.2       1.0X


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

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
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                                                            2172           2199          38          7.2         138.1       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2180           2218          53          7.2         138.6       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             147            155          11        107.3           9.3      14.8X
SQL Parquet MR: DataPageV1                                            2337           2350          19          6.7         148.6       0.9X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           2859           2867          11          5.5         181.7       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             115            124           7        136.7           7.3      18.9X
SQL Parquet MR: DataPageV2                                            2240           2276          51          7.0         142.4       1.0X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2677           2707          42          5.9         170.2       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             116            121           7        136.1           7.3      18.8X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
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                                                            2277           2303          38          6.9         144.7       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2368           2369           2          6.6         150.5       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             255            260           6         61.8          16.2       8.9X
SQL Parquet MR: DataPageV1                                            2432           2467          49          6.5         154.6       0.9X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           2896           2924          40          5.4         184.1       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             125            135           7        126.1           7.9      18.2X
SQL Parquet MR: DataPageV2                                            2400           2420          29          6.6         152.6       0.9X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2765           2778          18          5.7         175.8       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             224            234           6         70.1          14.3      10.1X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
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                                                            2351           2364          19          6.7         149.5       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2271           2280          13          6.9         144.4       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             283            299          12         55.5          18.0       8.3X
SQL Parquet MR: DataPageV1                                            2423           2440          24          6.5         154.0       1.0X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           2968           2996          40          5.3         188.7       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             130            141           8        120.7           8.3      18.0X
SQL Parquet MR: DataPageV2                                            2456           2459           3          6.4         156.2       1.0X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           3052           3073          29          5.2         194.1       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             266            274           6         59.2          16.9       8.8X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
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                                                            2372           2379          10          6.6         150.8       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2274           2282          12          6.9         144.6       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             290            304          13         54.3          18.4       8.2X
SQL Parquet MR: DataPageV1                                            2838           2846          12          5.5         180.4       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           3448           3448           1          4.6         219.2       0.7X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             332            341           7         47.3          21.1       7.1X
SQL Parquet MR: DataPageV2                                            2411           2421          14          6.5         153.3       1.0X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2906           2906           0          5.4         184.8       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             297            312          14         53.0          18.9       8.0X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
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                                                            2503           2566          89          6.3         159.2       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2422           2425           5          6.5         154.0       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             345            359          14         45.6          22.0       7.3X
SQL Parquet MR: DataPageV1                                            2317           2327          14          6.8         147.3       1.1X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           3039           3040           1          5.2         193.2       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             114            127          10        137.4           7.3      21.9X
SQL Parquet MR: DataPageV2                                            2329           2330           2          6.8         148.1       1.1X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           2887           2887           1          5.4         183.5       0.9X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             137            142           5        114.5           8.7      18.2X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
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                                                            2698           2763          92          5.8         171.5       1.0X
SQL ORC Vectorized (Nested Column Disabled)                           2776           2778           3          5.7         176.5       1.0X
SQL ORC Vectorized (Nested Column Enabled)                             717            719           2         21.9          45.6       3.8X
SQL Parquet MR: DataPageV1                                            2877           2878           2          5.5         182.9       0.9X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           3329           3340          16          4.7         211.6       0.8X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)             330            335           5         47.6          21.0       8.2X
SQL Parquet MR: DataPageV2                                            2819           2823           5          5.6         179.2       1.0X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           3191           3203          18          4.9         202.9       0.8X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)             311            328          13         50.5          19.8       8.7X


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

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
SQL Nested Column Scan:                                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------------------
SQL ORC MR                                                           13029          13175         154          0.1       12425.7       1.0X
SQL ORC Vectorized (Nested Column Disabled)                          13054          13182          91          0.1       12449.3       1.0X
SQL ORC Vectorized (Nested Column Enabled)                            7264           7315          21          0.1        6927.3       1.8X
SQL Parquet MR: DataPageV1                                            8938           9075         119          0.1        8524.3       1.5X
SQL Parquet Vectorized: DataPageV1 (Nested Column Disabled)           9185           9240          64          0.1        8759.1       1.4X
SQL Parquet Vectorized: DataPageV1 (Nested Column Enabled)            5969           6032          44          0.2        5692.4       2.2X
SQL Parquet MR: DataPageV2                                            9610           9683          47          0.1        9164.5       1.4X
SQL Parquet Vectorized: DataPageV2 (Nested Column Disabled)           9969          10025          42          0.1        9507.2       1.3X
SQL Parquet Vectorized: DataPageV2 (Nested Column Enabled)            5809           5833          21          0.2        5539.6       2.2X


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

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Int and String Scan:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                           10409          10498         126          1.0         992.7       1.0X
SQL Json                                          10283          10315          44          1.0         980.7       1.0X
SQL Parquet Vectorized: DataPageV1                 1795           1801           8          5.8         171.1       5.8X
SQL Parquet Vectorized: DataPageV2                 1962           2006          63          5.3         187.1       5.3X
SQL Parquet MR: DataPageV1                         4140           4160          28          2.5         394.8       2.5X
SQL Parquet MR: DataPageV2                         4015           4063          68          2.6         382.9       2.6X
SQL ORC Vectorized                                 1822           1851          42          5.8         173.7       5.7X
SQL ORC MR                                         3582           3607          36          2.9         341.6       2.9X


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

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Repeated String:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            5650           5714          91          1.9         538.9       1.0X
SQL Json                                           6643           6644           1          1.6         633.6       0.9X
SQL Parquet Vectorized: DataPageV1                  484            489           3         21.7          46.1      11.7X
SQL Parquet Vectorized: DataPageV2                  464            473           7         22.6          44.2      12.2X
SQL Parquet MR: DataPageV1                         1614           1641          37          6.5         154.0       3.5X
SQL Parquet MR: DataPageV2                         1596           1607          15          6.6         152.2       3.5X
SQL ORC Vectorized                                  389            396           6         27.0          37.1      14.5X
SQL ORC MR                                         1733           1764          44          6.1         165.3       3.3X


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

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Partitioned Table:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
---------------------------------------------------------------------------------------------------------------------------------
Data column - CSV                                          11181          11233          74          1.4         710.9       1.0X
Data column - Json                                          9229           9256          39          1.7         586.8       1.2X
Data column - Parquet Vectorized: DataPageV1                 109            122          11        143.9           6.9     102.3X
Data column - Parquet Vectorized: DataPageV2                 231            257          23         68.0          14.7      48.4X
Data column - Parquet MR: DataPageV1                        2240           2254          21          7.0         142.4       5.0X
Data column - Parquet MR: DataPageV2                        2331           2346          20          6.7         148.2       4.8X
Data column - ORC Vectorized                                 184            197          10         85.3          11.7      60.6X
Data column - ORC MR                                        2231           2237           9          7.1         141.8       5.0X
Partition column - CSV                                      3564           3579          20          4.4         226.6       3.1X
Partition column - Json                                     7924           7928           5          2.0         503.8       1.4X
Partition column - Parquet Vectorized: DataPageV1             31             40           9        500.7           2.0     355.9X
Partition column - Parquet Vectorized: DataPageV2             31             37           6        512.7           2.0     364.4X
Partition column - Parquet MR: DataPageV1                   1262           1270          12         12.5          80.2       8.9X
Partition column - Parquet MR: DataPageV2                   1250           1257          10         12.6          79.5       8.9X
Partition column - ORC Vectorized                             32             35           7        497.9           2.0     354.0X
Partition column - ORC MR                                   1401           1402           2         11.2          89.0       8.0X
Both columns - CSV                                         11404          11414          14          1.4         725.0       1.0X
Both columns - Json                                         9661           9674          18          1.6         614.2       1.2X
Both columns - Parquet Vectorized: DataPageV1                155            165           7        101.3           9.9      72.0X
Both columns - Parquet Vectorized: DataPageV2                298            300           2         52.9          18.9      37.6X
Both columns - Parquet MR: DataPageV1                       2296           2371         105          6.8         146.0       4.9X
Both columns - Parquet MR: DataPageV2                       2342           2358          22          6.7         148.9       4.8X
Both columns - ORC Vectorized                                207            221          10         76.1          13.1      54.1X
Both columns - ORC MR                                       2227           2235          11          7.1         141.6       5.0X


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

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
String with Nulls Scan (0.0%):            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            7318           7331          18          1.4         697.9       1.0X
SQL Json                                           8586           8587           1          1.2         818.8       0.9X
SQL Parquet Vectorized: DataPageV1                 1195           1213          26          8.8         114.0       6.1X
SQL Parquet Vectorized: DataPageV2                 1477           1488          15          7.1         140.8       5.0X
SQL Parquet MR: DataPageV1                         3704           3713          13          2.8         353.3       2.0X
SQL Parquet MR: DataPageV2                         3552           3566          19          3.0         338.8       2.1X
ParquetReader Vectorized: DataPageV1                808            824          14         13.0          77.1       9.1X
ParquetReader Vectorized: DataPageV2               1101           1161          85          9.5         105.0       6.6X
SQL ORC Vectorized                                  834            857          32         12.6          79.5       8.8X
SQL ORC MR                                         3128           3133           8          3.4         298.3       2.3X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
String with Nulls Scan (50.0%):           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            5438           5448          14          1.9         518.6       1.0X
SQL Json                                           7828           7845          24          1.3         746.5       0.7X
SQL Parquet Vectorized: DataPageV1                  824            844          18         12.7          78.6       6.6X
SQL Parquet Vectorized: DataPageV2                 1034           1041          10         10.1          98.6       5.3X
SQL Parquet MR: DataPageV1                         2755           2760           8          3.8         262.7       2.0X
SQL Parquet MR: DataPageV2                         2888           2912          33          3.6         275.5       1.9X
ParquetReader Vectorized: DataPageV1                739            743           5         14.2          70.5       7.4X
ParquetReader Vectorized: DataPageV2                905            912          10         11.6          86.3       6.0X
SQL ORC Vectorized                                  983            990           7         10.7          93.7       5.5X
SQL ORC MR                                         2844           2845           1          3.7         271.2       1.9X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
String with Nulls Scan (95.0%):           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            4010           4023          19          2.6         382.4       1.0X
SQL Json                                           5497           5519          31          1.9         524.2       0.7X
SQL Parquet Vectorized: DataPageV1                  174            187          14         60.3          16.6      23.1X
SQL Parquet Vectorized: DataPageV2                  204            219          14         51.3          19.5      19.6X
SQL Parquet MR: DataPageV1                         1654           1667          19          6.3         157.7       2.4X
SQL Parquet MR: DataPageV2                         1661           1677          22          6.3         158.4       2.4X
ParquetReader Vectorized: DataPageV1                195            199           7         53.7          18.6      20.6X
ParquetReader Vectorized: DataPageV2                221            224           3         47.4          21.1      18.1X
SQL ORC Vectorized                                  314            318           5         33.4          29.9      12.8X
SQL ORC MR                                         1608           1612           5          6.5         153.4       2.5X


================================================================================================
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 7763 64-Core Processor
Single Column Scan from 10 columns:       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            1278           1295          24          0.8        1218.7       1.0X
SQL Json                                           1733           1733           1          0.6        1652.4       0.7X
SQL Parquet Vectorized: DataPageV1                   26             30           6         40.7          24.6      49.6X
SQL Parquet Vectorized: DataPageV2                   34             39           6         31.2          32.0      38.1X
SQL Parquet MR: DataPageV1                          161            171           4          6.5         153.9       7.9X
SQL Parquet MR: DataPageV2                          175            177           2          6.0         166.5       7.3X
SQL ORC Vectorized                                   29             32           5         36.5          27.4      44.5X
SQL ORC MR                                          139            149           9          7.6         132.2       9.2X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Single Column Scan from 50 columns:       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            2633           2644          16          0.4        2511.0       1.0X
SQL Json                                           5595           5623          40          0.2        5335.6       0.5X
SQL Parquet Vectorized: DataPageV1                   28             32           6         37.7          26.5      94.7X
SQL Parquet Vectorized: DataPageV2                   35             40           5         29.7          33.7      74.5X
SQL Parquet MR: DataPageV1                          158            171           9          6.6         150.9      16.6X
SQL Parquet MR: DataPageV2                          167            174           4          6.3         159.6      15.7X
SQL ORC Vectorized                                   32             38           6         33.2          30.1      83.4X
SQL ORC MR                                          144            148           5          7.3         137.0      18.3X

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
Single Column Scan from 100 columns:      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
SQL CSV                                            4236           4278          60          0.2        4039.4       1.0X
SQL Json                                          10322          10520         280          0.1        9844.1       0.4X
SQL Parquet Vectorized: DataPageV1                   36             45           8         29.4          34.0     118.8X
SQL Parquet Vectorized: DataPageV2                   42             48           7         24.9          40.1     100.8X
SQL Parquet MR: DataPageV1                          181            194          11          5.8         172.8      23.4X
SQL Parquet MR: DataPageV2                          181            190           7          5.8         173.0      23.4X
SQL ORC Vectorized                                   38             46           7         27.7          36.2     111.7X
SQL ORC MR                                          140            150           5          7.5         133.8      30.2X


