Columnar storage saves data by column rather than by row. This is highly efficient for analytical queries (OLAP) which typically aggregate a few columns over many rows.
Benefits
- Compression: Similar data types in columns compress very well (10x-50x).
- IO Efficiency: Only read usage columns, ignore the rest.