This is huge. It seems to me that it's similar to BigQuery but has many other features that I didn't see in other databases. AggregatingMergeTree is especially

This is huge. It seems to me that it's similar to BigQuery but has many other features that I didn't see in other databases. AggregatingMergeTree is especially one of them and allows incremental aggregation which is a huge gain for analytics services. Also it provides many table engines for different use-cases. You don't even need a commit-log such as Apache Kafka in front of ClickHouse, you can just push the data to TinyLog table and and move data in micro-batches to a more efficient column-oriented table that uses different table engine.