TLDR: Fast, Very Very Very Fast, Rich SQL, Good compression algorithms Detail: 1) Rich SQL syntax. There are a lot of in-build functions (including GeoDistances, Uber Hexagons support, time functions, comprehensive math, and many others). Functions could be combined (e.g. with If: SumIf, AvgIf, etc) which is very convenient. 2) Fast. Arrays and MapReduce make CH working LIGHTNING FAST. I was extremely surprised when several GBs of data were processed in under 1 second. 3) Fast. Materialized Views work differently than in other databases, but the correct usage allows instant processing of TBs of data. 4) Efficient. Vast amount of data types and compression algorithms help you to store data extremely efficiently. Make sure to check the docs and choose the best compression types for your tables. You will be very surprised. Overall you see very smart engineers worked on this database. It was made by engineers for engineers.

Clickhouse is a column-oriented DBMS, and it is fault-tolerant and blazingly fast. Sql like syntax makes it super easy to use. The mathematics using behind scenes using vectors and merging algorithms gives the power to it. I like how quickly we can retrieve the data from the database. In Analytics/Reports we require to get/insert the millions of records and Clickhouse fulfills the purpose. Since it is a column-oriented DBMS, it performs things quickly.

The flexibility of choice of engines for your varying needs broad coverage of tests