# Apache ORC

> An open, column-based file format from the Hive world. It is close to Parquet.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** ORC, Optimized Row Columnar, ORC File

## Think of it like

It is like Parquet's cousin. It packs a box the same way, with a few small changes.

## Definition

Apache ORC, short for Optimized Row Columnar, is an open file format that stores data by column. It grew up inside the Hive project on Hadoop. A file is cut into large blocks called stripes, each with its own index. Like Parquet, it lets readers skip data they do not need. It is still common where Hive is in use.

## Example

A bank's old Hadoop cluster stores its tables as ORC. New tools on the same cluster can still read those files.

## Why it matters

Many older data lakes are full of ORC files. You will meet it when you work on them.

## Common mistake

Converting every ORC file to Parquet for no reason. Both work well, and the copy costs time and money.

## Three principles

- **By column.** Columns are stored apart.
- **Stripes.** Big blocks, each with an index.
- **Hive roots.** Common in Hadoop setups.

## Related terms

- [Columnar Storage](https://learn.benibix.com/term/data/columnar-storage)
- [Apache Parquet](https://learn.benibix.com/term/data/apache-parquet)
- [Apache Avro](https://learn.benibix.com/term/data/apache-avro)

---

Source: https://learn.benibix.com/term/data/apache-orc
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.
