~/talk

This Impala not only reads, but modifies and optimizes Iceberg tables

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

Impala adds writable Iceberg support: it implements row-level positional deletes (and can read equality deletes), rewrites DELETE/UPDATE as inserts into an Iceberg delete table, and routes rows to multiple sinks with a new merge sync so updates, deletes and inserts can be produced in one plan. Read performance avoids broadcasting by using directed distribution joins. Table maintenance adds OPTIMIZE compaction to merge small files and remove delete files, DROP PARTITION with predicates and transforms, plus ROLLBACK and EXPIRE SNAPSHOTS to reclaim space.

AI-written summary · about

  1. 0:00Introduction and agenda
  2. 1:13Legacy Hive tables limitations
  3. 5:43Apache Iceberg overview
  4. 8:53Apache Impala architecture
  5. 12:33Modification techniques in Iceberg
  6. 17:10Delete update and merge statements
  7. 20:21Table maintenance operations
  8. 25:03Conclusion and Q&A
~/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.