# Merge-on-read

Glossary, read 10 Nov 2026

**The short answer.** Merge-on-read is a table type where updates and deletes go into small log files and are merged with base files when a query runs or when compaction rewrites them. Writes are fast and data is fresh sooner. Reads pay the merge cost until compaction runs. Hudi calls it MoR.

Hudi's MoR tables write changes as row-based Avro or columnar log files and reconcile them with the base file on a schedule. Without that compaction, read latency grows with the log.

Iceberg's delete files and deletion vectors follow the same idea: record the change cheaply now, fold it into data files later.

## A sourced example

Hudi's table types page walks through a timeline in which compaction at 10:05 produces a new base file version, so that looking at base files alone shows a layout like a copy-on-write table.

## Sources

- Apache Hudi: table and query types: https://hudi.apache.org/docs/table_types (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalakehousecompare.com/glossary/merge-on-read/
