How columnar storage actually works (and why ClickHouse is fast)

Why ClickHouse queries billions of rows in milliseconds — columnar storage, compression, and the MergeTree engine explained from first principles.