4 ms·
Actually that table syntax partitions by month, which is a little non-intuitve. In modern ClickHouse SQL it would look like the following. CREATE TABLE tsbs_
by hodgesrm 4y ago
Actually that table syntax partitions by month, which is a little non-intuitve. In modern ClickHouse SQL it would look like the following.
CREATE TABLE tsbs_modern (
created_date Date DEFAULT today(),
created_at DateTime DEFAULT now(),
time String,
tags_id UInt32,
additional_tags String DEFAULT ''
) ENGINE = MergeTree
PARTITION BY toYYYYMM(created_date)
ORDER BY (tags_id, created_at)
- untitaker_ 4y agoThanks, you're right. Mea culpa
- hodgesrm 4y agoBut your point that it's out of date is definitely right.
- untitaker_ 4y agoWhile the partitioning is okay, the order by is still problematic. See https://telegra.ph/No-QuestDB-is-not-Faster-than-ClickHouse-06-15 https://telegra.ph/No-QuestDB-is-not-Faster-than-ClickHouse-...
- hodgesrm 4y agoThat article was a good response.