Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Arbitrary partitioning key for MergeTree engine family #1482

Closed
badvir opened this issue Nov 11, 2017 · 1 comment
Closed

Arbitrary partitioning key for MergeTree engine family #1482

badvir opened this issue Nov 11, 2017 · 1 comment
Assignees
@ztlpn
Labels
feature

Comments

@badvir
Copy link

badvir commented Nov 11, 2017

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?
@ztlpn
Copy link
Contributor

ztlpn commented Nov 11, 2017

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

@harlinb harlinb mentioned this issue Nov 17, 2017
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ztlpn ztlpn

Labels
feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ztlpn @badvir @alexey-milovidov