~/talk

Apache Iceberg Planning Explained

Talkat Community Over Code EU 2024 · 2024-06-03..06-05· [data-engineering]
links:none on file
slides:none on file

Apache Iceberg stores table state as a persistent tree of root metadata, snapshots, manifest lists and manifests so planners filter metadata before touching data. Benchmarks use a table with 10 million partitions and 20 million data files (15 cols, bounds on 6), producing ~850 manifests (~7 GB). Local planning finds partition-aligned queries in ~0.25 seconds, distributed planning finds handful of files in ~2.5s but full scans hit Spark serialization (~20s) overhead. Adding 10M delete files (68 delete manifests, ~500 MB) costs seconds for delete indexing; local planning remains fast for partition-aligned queries.

AI-written summary · about

  1. 0:00Introduction to Apache Iceberg
  2. 0:31Key metadata concepts in Iceberg
  3. 3:00Metadata evolution and structural sharing
  4. 5:49Planning overview without delete files
  5. 8:39Two-stage planning process explained
  6. 10:27Benchmarking planning performance
  7. 12:11Highly selective query results
  8. 13:18Distributed planning performance
  9. 15:25Planning with delete files
  10. 18:40Performance with delete files
  11. 20:28Key takeaways and summary
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.