What is ClickHouse and why do all projects move to it?
Not all projects move there but if you want fast analytic queries on a few billion rows up to a few petabytes, it's really hard to beat.
Disclaimer: I work for Altinity, which supports ClickHouse.
Analytics are typically append only, so ClickHouse works order of magnitude faster than RDBMS.