ClickHouse

 

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

体验下来, 不怎么好用。

您可以选择一种方式赞助本站