clickhouse学习笔记-8-数据采集

把数据从一个集群转移到另一个集群

clickhouse-client --host <source> -q "SELECT * FROM test.app FORMAT CSVWithNames" | \
clickhouse-client --host <target> --port 9000  -q "INSERT INTO test.app FORMAT CSVWithNames"

ps:
https://blog.csdn.net/zhangpeterx/article/details/96494877

clickhouse 同步到MYSQL

insert into function 
mysql('ip_addr:port', 'db_name', 'table_name', 'user_name', 'password') 
select * from ck_table_name

mysql同步到clickhouse

insert into ck_db.c_fct_collect_listing(
    `uuid`,
    `date`
)
SELECT
    `auuid`,
    `date`
FROM mysql('ip_addr:port','db_name','table_name','user_name','password')

clickhouse 导出

clickhouse-client -h 127.0.0.1 -d log -m -u default --password 123456 --query="select * from test where dt>='2018-09-20' and dt<='2018-10-13'   order by logTime desc" >> data1.csv

clickhouse 到 clickhouse

insert into 目的数据库.表 select * from remote('数据源的ip', '数据库.表','登录名','登录密码')

文档：
https://blog.csdn.net/weixin_31508009/article/details/112508095