What is a columnar storage format?

What is a columnar storage format?

Approach: Explain how data is organized on disk by column rather than row.

A storage method where values of the same column are stored together. This allows for better compression and faster analytical queries because only required columns are read from disk.

Follow-up: Name a common file format using this.

Key concepts: parquet, compression, io efficiency.