clickhouse
- ClickHouse是一个用于联机分析(OLAP)的列式数据库管理系统(DBMS)
- clickhouse 适用于读场景,没有完整的事务支持,仅适用批量删除或者修改数据。
clickhouse docker 安装
- rpm 包地址 https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/
- docker安装:
安装server:
docker run -d --name xx-clickhouse-server --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009 -v xxx:/etc/clickhouse-server/config.xml -v xxx:/var/lib/clickhouse yandex/clickhouse-server
安装client:- docker run -it --rm --link xx-clickhouse-server:xx yandex/clickhouse-client --host=xx
- docker run -it --rm xx-clickhouse-server --host=host --port=port --user=username – password=password
clickhouse 从mysql导入数据
- create table xxx engine=MergeTree order by id as select * from mysql(host:port,db,table,user,password)
- INSERT INTO db.table [(c1, c2, c3)] select column from mysql(host:port, db, table, ‘user’, ‘password’)