~/talk

Let’s see how fast Impala runs on Iceberg

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

Impala uses a native C++ Iceberg reader and new Iceberg-specific operators to apply positional delete files; a directed distribution mode maps delete-file paths to the nodes that actually read those data files, cutting exchanged rows from ~9.5B to 825M and lowering a simple count query from ~21s to ~12s (≈42% faster). On a 1T-row grouped benchmark with ~70B positional deletes a naïve run rises from 2.5m to 7m15s; build-side batching and parallel sort reduce that to ~5m. Future plans include Roaring Bitmap for compact deletes; TPC-DS 1k compares Impala (≈15.5m) vs Engine X (>20m, ~1.3×).

AI-written summary · about

  1. 0:00Introduction and presenters
  2. 1:14Impala architecture overview
  3. 4:25Iceberg delete strategies
  4. 8:15Performance test setup
  5. 9:21Network transfer bottleneck
  6. 10:45Directed distribution mode
  7. 13:35Zan takes over presentation
  8. 13:561 trillion row challenge
  9. 15:23Iceberg V2 with deletes
  10. 16:53Performance impact of deletes
  11. 17:35Join operator details
  12. 20:44Optimizing join build operator
  13. 22:31Future optimizations
  14. 23:54Exchange operator inefficiency
  15. 24:37Comparison with Engine X
  16. 26:21Q&A and closing
~/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.