~/talk

Flink SQL in 2020: Time to show off!

Talkat Flink Forward Virtual 2020 · 2020-04-22..04-24· [data-engineering]
github:twalthr
slides:none on file

Demo shows a Docker Compose Flink cluster (JobManager/TaskManagers), Hive metastore, Kafka, MySQL and S3 (MinIO) running live and succeeding: a Kafka→S3 CSV snapshot job writes ~50 pages, batch and streaming use the same SQL, and a tumbling window query runs identically in batch and streaming. The demo exercises temporal table joins, enrichment lookups to MySQL, interval joins with five‑minute state, MATCH_RECOGNIZE CEP, materialized views written to Kafka/MySQL with flush 2s/1000 rows, and cites ~25 open FLIPs for ongoing work.

AI-written summary · about

  1. 0:00Introduction and overview
  2. 1:08Streaming SQL basics
  3. 8:17Demo environment setup
  4. 14:04Live demo begins
  5. 17:36Using Hive catalog
  6. 19:47Snapshot to S3 export
  7. 21:39Batch vs streaming execution
  8. 24:15Windowed aggregations
  9. 25:49Joining tables
  10. 34:11Pattern recognition
  11. 37:15Materialized views
  12. 40:52Current Flink SQL features
  13. 42:22Future developments
  14. 45:19Change data capture
  15. 45:40Summary 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.