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

     1  -- pre
     2  drop database if exists vecdb2;
     3  create database vecdb2;
     4  use vecdb2;
     5  drop table if exists vec_table;
     6  create table vec_table(a int, b vecf32(3), c vecf64(3));
     7  
     8  -- read from an already exported file
     9  load data infile '$resources/load_data/array_out.csv' into table vec_table fields terminated by ',' ignore 1 lines;
    10  select * from vec_table;
    11  
    12  -- write a new export file
    13  -- NOTE: write to `$resources/into_outfile` only. Else it will fail.
    14  select * from vec_table into outfile '$resources/into_outfile/array_out.csv';
    15  delete from vec_table;
    16  
    17  -- read from the newly exported file
    18  load data infile '$resources/into_outfile/array_out.csv' into table vec_table fields terminated by ',' ignore 1 lines;
    19  select * from vec_table;
    20  
    21  -- post
    22  drop database vecdb2;