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

     1  -- pre
     2  drop database if exists parq;
     3  create database parq;
     4  use parq;
     5  
     6  -- read from an already exported file
     7  create table t1(id bigint,name varchar);
     8  load data infile {'filepath'='$resources/load_data/simple.parq', 'format'='parquet'} into table t1;
     9  select * from t1;
    10  
    11  create table t2(id bigint not null, name varchar not null, sex bool, f32 float(5,2));
    12  load data infile {'filepath'='$resources/load_data/simple2.parq', 'format'='parquet'} into table t2;
    13  select * from t2;
    14  
    15  create table t3(c varchar);
    16  load data infile {'filepath'='$resources/load_data/indexed_str.parq', 'format'='parquet'} into table t3;
    17  select * from t3;
    18  
    19  -- post
    20  drop database parq;