Apache Iceberg™ v3, now authorized by the Apache Iceberg™ group, introduces superior new options and knowledge varieties. Iceberg v3 contains main enhancements comparable to deletion vectors, row lineage, and new varieties for semi-structured knowledge and geospatial use instances. These options enable clients to effectively course of and question knowledge. Moreover, these enhancements are constant throughout Delta Lake, Apache Parquet, and Apache Spark™, so clients can interoperate between Delta and Apache Iceberg™ with out rewriting knowledge or row-level delete information.
On this weblog submit, we cowl the latest developments in Iceberg v3:
- Deletion Vectors
- Row Lineage
- Semi-Structured Knowledge and Geospatial Sorts
- Interoperability throughout Delta Lake, Apache Parquet, and Apache Spark
Deletion Vectors
Iceberg v3 introduces a brand new format for row-level deletes to enhance learn efficiency: deletion vectors. Row-level deletes considerably cut back write amplification by optimizing how deleted rows are saved and tracked — resulting in quicker ETL and ingestion. In Iceberg v2, engines weren’t required to compact delete information collectively throughout writes. The intent was for purchasers to make use of asynchronous upkeep. Nonetheless, many purchasers didn’t schedule upkeep providers, so their tables had too many unmaintained delete information. That led to sluggish learn efficiency when engines needed to merge many row-level delete information on learn.
Iceberg v3 introduces a brand new deletion vector format and new compaction necessities for delete information. This new format avoids translation between Parquet information and in-memory representations used to use the deletes. Moreover, engines should keep a single deletion vector per file at write time. This requirement improves efficiency and statistics on knowledge information. This additionally makes it simple to check earlier and present deletes, which simplifies processing a desk’s row-level modifications as a stream.
Row Lineage
One other main Iceberg v3 characteristic is row lineage, used to simplify incremental processing. With row lineage, engines discover row-level modifications by matching variations of rows throughout commits.
Iceberg v3 introduces row lineage utilizing row-level metadata: a row ID and the sequence quantity when the row was final modified or added. The IDs establish the identical row throughout variations. Sequence numbers annotate when rows had been final modified – not simply relocated between information. This permits engines to course of modifications selectively, simplifying downstream updates with quicker and cheaper workflows.
Row ID data is particularly useful when mixed with incremental processing objects like materialized views. These objects are optimized to compute solely new or modified knowledge because the final processing cycle.
Semi-Structured Knowledge and Geospatial Sorts
Iceberg v3 additionally provides new knowledge varieties for semi-structured knowledge and geospatial knowledge.
Semi-structured knowledge is difficult to retailer as a result of it has various schemas, which don’t match into structured desk columns. One workaround is to extract particular person fields from this knowledge right into a structured format. Nonetheless, this creates extraordinarily broad tables with many columns and NULL values attributable to inconsistent schemas. One other different is to retailer JSON in string columns. Sadly, this leads to poor learn efficiency as a result of engines should parse knowledge from these strings. With out semi-structured knowledge varieties, engines can not push down filters, so they should learn each row in each knowledge file. Iceberg v3 introduces VARIANT
to characterize semi-structured knowledge effectively. VARIANT
encodes the construction of the info to enhance efficiency whereas sustaining schema flexibility.
Equally, geospatial knowledge — data related to places on the Earth’s floor like roads, parks, or metropolis boundaries — can be laborious to work with and question effectively. With out geospatial varieties, clients had to make use of binary columns to retailer geodata places. Nonetheless, this illustration didn’t help geographic looking out, since binary columns can’t be filtered to search out objects inside a given space. Iceberg v3 solves this downside by introducing new geometry and geography knowledge varieties. Geometry varieties are for planar spatial knowledge, whereas geography varieties are for world knowledge accounting for the curvature of the earth. With these varieties, clients simply discover knowledge utilizing bounding containers that characterize geographic areas and effectively find geospatial objects.
Interoperability with Delta Lake, Apache Parquet, and Apache Spark™
Iceberg v3’s new options and knowledge varieties broaden performance and enhance efficiency. These Apache Iceberg options are additionally necessary as a result of they push interoperability amongst lakehouse codecs.
Traditionally, clients have been pressured to decide on between two of the preferred lakehouse codecs: Delta Lake and Apache Iceberg. It is because most platforms help just one format. Rewriting knowledge will be expensive and impractical at scale, making this alternative long-term. The codecs are very related: each are metadata layers on prime of Parquet knowledge information to supply desk semantics. Nonetheless, small variations within the desk codecs trigger points for purchasers.
Iceberg v3 unifies the info layer throughout codecs. With knowledge unification, clients can interoperate throughout Delta and Iceberg without having to rewrite knowledge or delete information. It is because Iceberg v3’s options have appropriate implementations throughout Delta Lake, Apache Parquet, and Apache Spark:
- Deletion vectors use the identical binary encodings throughout desk codecs
- Row-level lineage in Iceberg v3 is appropriate with row monitoring in Delta Lake
VARIANT
and geodata varieties are being developed within the upstream Apache Parquet and Apache Spark™ communities, which extends to Apache Iceberg and Delta Lake
By having appropriate options throughout open-source tasks, Iceberg v3 avoids forcing clients into selecting a format. As a substitute, clients can interoperate freely between codecs on one copy of their knowledge.
Study Extra About Iceberg v3
Iceberg v3 strikes the whole trade ahead to a extra performant, succesful, and interoperable world. We’re integrating Iceberg v3 into the Databricks Knowledge Intelligence Platform and look ahead to different distributors adopting Iceberg v3. Open-source is a core worth at Databricks, the place we actively contribute options comparable to deletion vectors to Iceberg v3. To foster a thriving open supply group, we help and encourage contributions to Apache Iceberg. For brand new contributors, we advocate beginning with a “good first problem”.
To study how we plan to combine Iceberg v3 options into our managed desk providing and the way forward for open desk codecs, register for the Knowledge and AI Summit on June 9-12, 2025.