# Columnar Storage

> A table kept one column at a time. A report reads just the columns it needs.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Column-Oriented Storage, Columnar Database, Column Store

## Think of it like

It is like a class list sorted by subject. All the math marks sit together, so adding them up is quick.

## Definition

Columnar storage keeps each column of a table together on disk. A row store keeps each whole row together instead. A report that needs two columns out of fifty reads only those two. Values in one column look alike, so they also squeeze down well. This makes big scans fast, but writing one row at a time is slow.

## Example

A sales table has 50 columns. A query for total sales by month reads just the date and amount columns, a tiny part of the file.

## Why it matters

It is why warehouses can scan billions of rows in seconds. Less data read means faster and cheaper queries.

## Common mistake

Using it for an app that writes one row at a time. Each small write has to touch every column.

## Three principles

- **Columns together.** Each column is stored on its own.
- **Read less.** Skip the columns a query does not need.
- **Squeezes well.** Like values pack down small.

## Related terms

- [Apache Parquet](https://learn.benibix.com/term/data/apache-parquet)
- [Apache ORC](https://learn.benibix.com/term/data/apache-orc)
- [Apache Arrow](https://learn.benibix.com/term/data/apache-arrow)
- [Online Analytical Processing (OLAP)](https://learn.benibix.com/term/data/olap)
- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Online Transaction Processing (OLTP)](https://learn.benibix.com/term/data/oltp)
- [Row-Oriented Storage](https://learn.benibix.com/term/data/row-oriented-storage)

## Told apart from

- [Row-Oriented vs Columnar Storage](https://learn.benibix.com/compare/row-oriented-vs-columnar-storage): People think row storage and column storage hold different data. They hold the very same table, just laid out two ways on disk. Row storage keeps each record together, so writing one order is fast. Column storage keeps each column together, so adding up one column is fast. Apps use rows. Warehouses use columns.

![The same three-row table stored two ways. In row storage each row's id, city and total sit side by side on disk. In column storage all the ids sit together, then all the cities, then all the totals, so a query for totals reads one block.](https://learn.benibix.com/diagrams/row-vs-column-storage.svg)

---

Source: https://learn.benibix.com/term/data/columnar-storage
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
