github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/load_data/load_data_parquet.result (about)

     1  drop database if exists parq;
     2  create database parq;
     3  use parq;
     4  create table t1(id bigint,name varchar);
     5  load data infile {'filepath'='$resources/load_data/simple.parq', 'format'='parquet'} into table t1;
     6  select * from t1;
     7  id    name
     8  1    user1
     9  2    user2
    10  7    user7
    11  8    user8
    12  10    user10
    13  12    user12
    14  15    user15
    15  16    user16
    16  create table t2(id bigint not null, name varchar not null, sex bool, f32 float(5,2));
    17  load data infile {'filepath'='$resources/load_data/simple2.parq', 'format'='parquet'} into table t2;
    18  select * from t2;
    19  id    name    sex    f32
    20  1    user1    false    1.0
    21  2    user2    false    null
    22  7    user7    false    7.0
    23  8    user8    true    null
    24  10    user10    false    10.0
    25  12    user12    false    null
    26  15    user15    false    null
    27  16    user16    true    null
    28  create table t3(c varchar);
    29  load data infile {'filepath'='$resources/load_data/indexed_str.parq', 'format'='parquet'} into table t3;
    30  select * from t3;
    31  c
    32  null
    33  aa
    34  null
    35  bb
    36  aa
    37  789$&@789$&@789$&@789$&@789$&@789$&@789$&@789$&@789$&@789$&@
    38  789$&@789$&@789$&@789$&@789$&@789$&@789$&@789$&@789$&@789$&@
    39  aa
    40  bb
    41  xyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABC
    42  null
    43  null
    44  xyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABCxyzABC
    45  drop database parq;