article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

To simulate text messages I have used ~3 billion of reddit comments (10 years from 2007 to 2017), downloaded from pushshift.io. In my case, I’m using this data as a simulation of text messages, and will show how we can use ClickHouse as a backend for an API. group by a.w, b.total; 0 rows in set. group by a.w, Processed 7.35