Clickhouse: Arbitrary partitioning key for MergeTree engine family
ClickHouse's partitioning key is fixed in month.
I want to create a partition key on a day basis.
Is it possible after Q4 2017?
feature
badvir
>All comments
It is possible right now! (starting from the 54310 release)
Documentation is under development now, but here are a few examples in tests:
https://github.com/yandex/ClickHouse/blob/master/dbms/tests/queries/0_stateless/00502_custom_partitioning_local.sql
https://github.com/yandex/ClickHouse/blob/master/dbms/tests/queries/0_stateless/00502_custom_partitioning_replicated_zookeeper.sql
ztlpn
on 11 Nov 2017
🎉3
Was this page helpful?
0 / 5 - 0 ratings
Related issues
amonakhov
路
3Comments
derekperkins
路
3Comments
atk91
路
3Comments
bseng
路
3Comments
igor-sh8
路
3Comments
Most helpful comment
It is possible right now! (starting from the 54310 release)
Documentation is under development now, but here are a few examples in tests:
https://github.com/yandex/ClickHouse/blob/master/dbms/tests/queries/0_stateless/00502_custom_partitioning_local.sql
https://github.com/yandex/ClickHouse/blob/master/dbms/tests/queries/0_stateless/00502_custom_partitioning_replicated_zookeeper.sql