clickhouse 直连mysql_clickhouse 导入mysql,csv数据

1.建mysql关联表

clickhouse-client //进入命令行

create table testmysql (`id` Nullable(Int32),`name` Nullable(String)) engine = MySQL('192.168.3.175:3306','lyjtest','data','root','123456');

//MySQL(地址,库名,用户名,密码)

2.导入数据到clickhouse

CREATE TABLE  mysql2clickhouse (`id` Nullable(Int32),`name` Nullable(String)) engine =TinyLog(); //创建clickhouse管理表

insert into mysql2clickhouse(id ,name) select * from testmysql; //将mysql数据导入到clickhouse管理表

*******************或者使用下面方式建表导入

create table mysql2clickhouse2 engine= TinyLog  as select * from testmysql;//需要指定engine

3.使用mysql函数方式导入mysql数据库表到clickhouse

insert into mysql2clickhouse2 select * from mysql('192.168.3.175:3306','lyjtest','test','root','123456');//('目标IP','database','table,'user',&#