Why it matters

ACID enables mutable Hive tables. Understanding shapes modern Hive apps.

Advertisement

The architecture

Delta files: new + deleted rows per transaction.

Base + delta: query sees base + applied deltas.

Compaction: consolidate deltas periodically.

Hive ACID storageBase fileoriginal dataDelta filesper-transactionCompactionconsolidateACID tables require ORC format and bucketing for correct behavior
ACID mechanics.
Advertisement

How it works end to end

Requirements: managed table, ORC format, bucketed.

Isolation: snapshot isolation typical.

MERGE: UPSERT-like semantics.

Compaction types: minor (merge deltas), major (rewrite base + deltas).