1.将表数据导出为csv

CALL CSVWRITE('/opt/aaa.csv','SELECT * FROM aaa');

2.将csv导入到表

2.1.创建表并导入

CREATE TABLE aaa AS SELECT * FROM CSVREAD('/opt/aaa.csv');

指定表结构

CREATE TABLE aaa (ID INT PRIMARY KEY,NAME VARCHAR(255)) AS SELECT * FROM CSVREAD('/opt/aaa.csv');

2.2.导入已存在的表

INSERT INTO aaa (SELECT * FROM CSVREAD('/opt/aaa.csv'));