mysql导入数据到clickhouse

1、从mysql中导出csv文件

SELECT
	b.id,
	b.NO,
	b.type,
	b.in_or_out_time,
	b.photo,
	a.college_id,
	a.major_id,
	a.class_id INTO OUTFILE '/var/lib/mysql-files/stu_in_out_record.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' 
FROM
	stu a
	LEFT JOIN stu_record b ON a.NO = b.NO;
	

2、clickhouse创建对应的表、导入到clickhouse
创建表

CREATE TABLE cjrtest.stu_in_out_record(
                                                       `id` String,
                                                       `no` String,
                                                       `type` Int64,
                                                       `in_or_out_time` DateTime,
                                                       `photo` String,
                                                       `college_id` String,
                                                       `major_id` String,
                                                       `class_id` String

) ENGINE = MergeTree
      --PARTITION BY no
      ORDER BY (no);

导入到clickhouse

cat /var/lib/mysql-files/stu_in_out_record.csv | clickhouse-client --query="INSERT INTO cjrtest.stu_in_out_record FORMAT CSV"