mysql表通过csv复制到clickhouse

如何将Mysql里的表数据通过csv格式移到clickhouse

    第一步，mysql导出数据到CSV

    第二步，将csv文件发送到clickhouse所在的服务器

    第三步，将csv文件导入到clickhouse

    服务器上连接mysql：

mysql -uroot -S /home/mysql/mysql_3306/mysql_3306.sock -p123456 -D0001790455_pos

    导出到csv：

SELECT DATE(created_on), 
order_dish_id, dish_id, dish_name,
 dining_order_id, discount, 
 member_discount, normal_discount
INTO OUTFILE '/var/lib/mysql-files/pdish_test.csv'    
FIELDS TERMINATED BY ','  OPTIONALLY ENCLOSED BY '"'    
LINES TERMINATED BY '\n'   FROM 
pos_order_dish; 

    服务器之间拷贝CSV文件

scp ol_fans_sns_bind.csv root@192.168.1.231:/root/clickhouse-flies

    clickhouse服务器登入clickhouse建好相关的表

    导入csv至clickhouse：

cat /root/clickhouse-files/rv_ol_fans.csv | clickhouse-client --query="INSERT INTO test6.rv_ol_fans FORMAT CSV"