Arrow uncompressed

Query finished in 3.063791375 s
Now reading data out of band
Data size is 15276072
Data size is 30550888
Data size is 30548648
Data size is 30550080
Data size is 30549344
Data size is 30549056
[34021762, 983317, 8327, 2, 45.0, 63012.15, 0.09, 0.01, N, O, 1997-06-11, 1997-03-17, 1997-07-05, DELIVER IN PERSON, FOB, cingly regular asymptot]
Data size is 30549704
Data size is 30551376
Data size is 30549856
Data size is 30549856
[30060962, 748740, 48741, 2, 50.0, 89435.5, 0.05, 0.07, N, O, 1996-02-19, 1996-02-20, 1996-03-14, NONE, AIR, ful instructions. carefully ir]
Data size is 30548952
Data size is 30548600
Data size is 30551560
Data size is 30547640
Data size is 30551128
[22117219, 1347676, 22716, 3, 10.0, 17236.1, 0.08, 0.07, R, F, 1995-03-29, 1995-03-25, 1995-04-28, NONE, TRUCK, ial accounts. slyly]
Data size is 30550200
Data size is 30550760
Data size is 30549312
Data size is 30550368
[22197952, 1955657, 30715, 2, 22.0, 37676.32, 0.08, 0.05, A, F, 1994-01-31, 1993-11-21, 1994-02-08, NONE, MAIL, ccounts use carefully sly]
Data size is 31023024
Data size is 30550880
Data size is 30550912
Data size is 30549456
Data size is 7620704
[42284549, 997140, 22150, 5, 23.0, 28453.3, 0.03, 0.02, R, F, 1994-02-07, 1994-03-22, 1994-03-03, COLLECT COD, MAIL, packages sleep slyly above the express]
Fully read data in 31.114379417 s
Total row count is 5000000
Total data size is 695468376

Arrow compressed (Zstd)

Query finished in 3.930417875 s
Now reading data out of band
Data size is 4698108
WARNING: A restricted method in java.lang.foreign.SymbolLookup has been called
WARNING: java.lang.foreign.SymbolLookup::libraryLookup has been called by io.airlift.compress.v3.internal.NativeLoader in an unnamed module
WARNING: Use --enable-native-access=ALL-UNNAMED to avoid a warning for callers in this module
WARNING: Restricted methods will be blocked in a future release unless native access is enabled

Data size is 9233631
Data size is 9086944
Data size is 9094646
Data size is 9080477
Data size is 9086708
['30025248', '1663950', '13983', '7', '1.0', '1913.87', '0.0', '0.02', 'R', 'F', '1994-11-15', '1994-10-23', '1994-12-10', 'NONE', 'MAIL', ' nag about the pend']
Data size is 9093042
Data size is 9091970
Data size is 9100849
Data size is 9067822
['30067840', '1171720', '71721', '5', '41.0', '73458.47', '0.07', '0.02', 'R', 'F', '1993-10-21', '1994-01-10', '1993-10-31', 'TAKE BACK RETURN', 'RAIL', 'iously ironic dugouts. regular, even depo']
Data size is 9092042
Data size is 9094458
Data size is 9074413
Data size is 9099730
Data size is 9077395
['8137511', '217676', '92683', '1', '6.0', '9561.96', '0.01', '0.06', 'A', 'F', '1993-01-13', '1992-12-31', '1993-01-28', 'COLLECT COD', 'TRUCK', 'e of the slyly special courts! b']
Data size is 9116909
Data size is 9090743
Data size is 9100353
Data size is 9104166
['14207074', '210327', '85334', '3', '48.0', '59390.88', '0.1', '0.0', 'A', 'F', '1994-01-07', '1994-02-09', '1994-02-03', 'DELIVER IN PERSON', 'AIR', 'ironic theodolites nag carefu']
Data size is 9074643
Data size is 9088158
Data size is 9083980
Data size is 9076613
Data size is 2134020
['8308579', '1006083', '6084', '4', '46.0', '45495.38', '0.0', '0.03', 'N', 'O', '1997-07-07', '1997-08-23', '1997-07-18', 'NONE', 'FOB', 'uests cajole pack']
Fully read data in 12.825652666 s
Total row count is 5000000
Total data size is 206941820

JSON uncompressed

Query finished in 4.6167275 s
Now reading data out of band
Data size is 16280331
Data size is 32439533
Data size is 32415258
Data size is 32464595
Data size is 32498510
Data size is 32496382
[14025089, 1272249, 72250, 5, 24.0, 29308.32, 0.08, 0.07, N, O, 1996-12-27, 1997-02-18, 1997-01-22, TAKE BACK RETURN, AIR,  about the quickly even deposits. fluffily ]
Data size is 32467147
Data size is 32523014
Data size is 32500651
Data size is 32518530
[8064484, 520386, 20387, 4, 39.0, 54848.04, 0.06, 0.06, N, O, 1996-05-01, 1996-05-06, 1996-05-03, COLLECT COD, RAIL,  accounts nod. ev]
Data size is 32533247
Data size is 32529805
Data size is 32416060
Data size is 32489939
Data size is 32524634
[32075585, 398491, 73501, 5, 40.0, 63579.2, 0.1, 0.01, A, F, 1993-01-26, 1992-12-16, 1993-02-14, NONE, REG AIR, ounts. pending pac]
Data size is 32509940
Data size is 32501022
Data size is 32530917
Data size is 32521796
[54108226, 133068, 58070, 1, 47.0, 51749.82, 0.0, 0.04, R, F, 1994-04-12, 1994-03-31, 1994-04-21, COLLECT COD, AIR,  are furiously ]
Data size is 32500638
Data size is 32485841
Data size is 32477660
Data size is 32505520
Data size is 8623044
[34154534, 1851568, 1605, 6, 29.0, 44064.63, 0.09, 0.01, N, O, 1996-06-11, 1996-07-18, 1996-07-05, COLLECT COD, REG AIR, quickly ironic pinto beans sleep ]
Fully read data in 28.143537708 s
Total row count is 5000000
Total data size is 739754014

JSON compressed (zstd)

Query finished in 6.618771208 s
Now reading data out of band
Data size is 4616845
WARNING: A restricted method in java.lang.foreign.SymbolLookup has been called
WARNING: java.lang.foreign.SymbolLookup::libraryLookup has been called by io.airlift.compress.v3.internal.NativeLoader in an unnamed module
WARNING: Use --enable-native-access=ALL-UNNAMED to avoid a warning for callers in this module
WARNING: Restricted methods will be blocked in a future release unless native access is enabled

Data size is 9245942
Data size is 9248168
Data size is 9248511
Data size is 9255752
Data size is 9251670
['48070532', '613600', '63613', '2', '38.0', '57515.66', '0.01', '0.03', 'N', 'O', '1996-07-01', '1996-06-01', '1996-07-25', 'COLLECT COD', 'REG AIR', 'fix furiously bold theodolites. ironic pac']
Data size is 9253047
Data size is 9256731
Data size is 9254857
Data size is 9252917
['4082020', '1062831', '87842', '1', '21.0', '37669.38', '0.03', '0.05', 'R', 'F', '1992-04-24', '1992-04-17', '1992-05-23', 'COLLECT COD', 'RAIL', 'ular foxes aff']
Data size is 9252028
Data size is 9250974
Data size is 9251345
Data size is 9253047
Data size is 9252700
['50093190', '1286407', '86408', '3', '35.0', '48766.9', '0.02', '0.07', 'A', 'F', '1993-10-16', '1993-09-27', '1993-10-31', 'COLLECT COD', 'AIR', 'ual, even accounts acc']
Data size is 9253160
Data size is 9255392
Data size is 9249939
Data size is 9250985
['24282690', '782590', '82591', '2', '3.0', '5017.68', '0.1', '0.02', 'A', 'F', '1993-01-03', '1993-01-19', '1993-01-05', 'DELIVER IN PERSON', 'AIR', 's. carefully regular excuses haggle car']
Data size is 9252441
Data size is 9247368
Data size is 9251968
Data size is 9252411
Data size is 2454774
['12275078', '339441', '89448', '1', '41.0', '60697.63', '0.0', '0.05', 'A', 'F', '1993-03-06', '1993-04-09', '1993-03-20', 'NONE', 'TRUCK', 'ickly final packages. wa']
Fully read data in 14.679204958 s
Total row count is 5000000
Total data size is 210612972