Should You Use ClickHouse as a Main Operational Database?
Percona
JANUARY 14, 2019
To simulate text messages I have used ~3 billion of reddit comments (10 years from 2007 to 2017), downloaded from pushshift.io. No secondary indexes means that point selects (select by ID) tend to be very slow. This is all true for ClickHouse, however, we may be able to live with it for our task. group by a.w, b.total; 0 rows in set.
40 
Let's personalize your content