The Art of Not Scanning Everything
This week, while the coffee is slow and the world is loud, I am quietly enjoying a ClickHouse charming Dictionary structure, watching a billion rows find their meaning in a fraction of a second.
Tag: Clickhouse
ClickHouse JOIN dilemmas
In analytical databases, JOINs are often the silent killer of query performance. Today I was diving deep into the different Clickhouse JOIN algorithms and want to share with you my summary.
Discovering the secrets of Clickhouse
These days, I am having a serious columnar affair with my new friend, ClickHouse. Since I have some experience with quite a few other data stores, I notice new features that I once wished were present. Today, I will share with you my reflection on some interesting Clickhouse data types that have grabbed my attention.
When to use Clickhouse and when to use Databricks
We use both ClickHouse and Databricks for different data analytics use cases. A recurring question is often asked: when to use each platform. I’ve created the decision tree below to help developers choose, and would be happy to hear your thoughts.