Prev Next

BigData / Apache Iceberg Interview questions

How does Iceberg achieve schema evolution without rewriting data?

Schema evolution avoids rewriting data because Iceberg never actually relies on a data file's own embedded schema being identical to the table's current schema — instead, every read reconciles an older file's schema against the current one using stable field IDs, filling in appropriate defaults (typically null) for any column that didn't exist when that file was written.

flowchart TD A[Old data file written under Schema v1: field IDs 1,2,3] --> B[Table schema evolved to v2: adds field ID 4] B --> C[Query requests all current columns, including field ID 4] C --> D{Reading old file - does it contain field ID 4?} D -- No --> E[Return null for field ID 4 on rows from this file] D -- Yes, newer file --> F[Return the actual stored value for field ID 4] E --> G[Uniform result set returned across old and new files] F --> G

Because the reconciliation happens per-file at read time based on field IDs (rather than requiring every file to physically conform to one single, current schema), adding a column is purely a metadata operation: the new field ID is registered in the table's current schema, and any file lacking that ID is simply treated as having null for it, with no need to touch the file itself.

The same field-ID-based mechanism handles renames (updating which name maps to an existing ID, with no data change) and compatible type widening (like int to long), while genuinely incompatible changes — changing a column's type in an unsafe, non-widening way — are either disallowed or require an explicit, deliberate data migration, since no metadata-only trick can safely reinterpret data that was physically encoded under a fundamentally different, incompatible type.

What does Iceberg use to reconcile an old file's schema with the current one at read time?
What happens for a column that didn't exist when an older file was written?

More Related questions...

What is Apache Iceberg? What is the purpose of Apache Iceberg? What is a table format, and how does it differ from a file format? What are the key features of Apache Iceberg? What is the architecture of an Iceberg table? What is a snapshot in Apache Iceberg? What is a manifest file? What is a manifest list? What is the table metadata file? What is an Iceberg catalog? What is hidden partitioning? What are partition transforms in Iceberg? What is schema evolution in Iceberg? What is time travel in Apache Iceberg? Which query engines support Apache Iceberg? What file formats does Iceberg use to store data? How do you create an Iceberg table? What is the difference between Iceberg and a Hive table? What are field IDs in Iceberg, and why do they matter? What is ACID compliance in the context of Apache Iceberg? What is the difference between Apache Iceberg and Delta Lake? What is the difference between Apache Iceberg and Apache Hudi? Explain how hidden partitioning differs from Hive-style partitioning? What is a lakehouse, and how does Iceberg enable it? What is partition evolution, and how does it work internally? What is the difference between copy-on-write and merge-on-read in Iceberg? What are positional deletes versus equality deletes? Explain the internal working of Iceberg's snapshot isolation mechanism? What is the REST catalog, and why has it become important? What is the difference between a Hive catalog and a REST catalog? Explain the execution flow of a query against an Iceberg table? How does Iceberg achieve schema evolution without rewriting data? Explain the internal working of manifest-level partition pruning? What is compaction in Iceberg, and why is it needed? How do you perform time travel queries in Iceberg? What is the difference between a snapshot rollback and time travel? Explain how Iceberg handles concurrent writes? What is the role of sequence numbers in Iceberg snapshots? Explain the lifecycle of a write operation (commit) in Apache Iceberg? What are branches and tags in Apache Iceberg? How does Iceberg support upserts via MERGE INTO? What is the small file problem, and how does Iceberg address it? Explain the internal working of column-level statistics in manifest files? What is the difference between Iceberg V1, V2, and V3 table specs? How do you migrate an existing Hive table to Iceberg? What are deletion vectors, and how do they improve on positional delete files? Explain how Iceberg integrates with Apache Spark for reading and writing? What is metadata table querying in Iceberg? How do you troubleshoot slow query planning on a large Iceberg table? Explain the execution flow of building a streaming lakehouse pipeline with Iceberg and Flink?
Show more question and Answers...

Web

Comments & Discussions