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). In a partitioned massively parallel database system, the storage format and sorting algorithm may not be optimized for that operation as we are reading multiple partitions in parallel.
40 
Let's personalize your content