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"