Should You Use ClickHouse as a Main Operational Database?
Percona
JANUARY 14, 2019
However, ClickHouse is super efficient for timeseries and provides “sharding” out of the box (scalability beyond one node). As a temporary workaround we can do something like this: SELECT count() FROM rc WHERE (created_utc > ( ( SELECT max(created_utc) FROM rc ) - ((60 * 60) * 24))) AND (subreddit = 'programming') ??count()??
40 
Let's personalize your content