MySQL数据库导入Clickhouse

日常记录，方便以后的应用

clickhouse-client \
--host=172.168.10.102 \  # clickhouse 地址
--port=8123 \			# clickhouse 端口号
--user=default \		#用户名
--password=123			#密码

1.dim_base_lines表导入：
CREATE TABLE dim_base_lines ENGINE = MergeTree ORDER BY lineid AS SELECT * FROM mysql('172.168.10.103:3306', 'mytestdb', 'dim_testdb1', 'root', '123456');

2.dim_base_sections导入：
CREATE TABLE dim_base_sections ENGINE = MergeTree ORDER BY blocksectionid AS SELECT * FROM mysql('172.168.10.103:3306', 'mytestdb', 'dim_testdb2', 'root', '123456');