docker pull yandex/clickhouse-server
docker run -d --name some-clickhouse-server --ulimit nofile=262144:262144 yandex/clickhouse-server
客户端登录: clickhouse-client -m,如果不加-m启用多行,那么将会报错:
docker run -it --rm --link some-clickhouse-server:clickhouse-server yandex/clickhouse-client -m --host clickhouse-server
测试
create table cdc_test (
id Int64
) ENGINE = Log ;
insert into cdc_test select rand64() ;
创建表引擎都有10几个
引擎:
1. TinyLog
2. Log
3. Memory
4. Merge
5. Distributed
6. Null
7. Buffer
8. Set
9. Join
10. MergeTree
11. ReplacingMergeTree
12. SummingMergeTree
13. AggregatingMergeTree
14. CollapsingMergeTree
体验下来, 不怎么好用。