A while ago, when I was stil part of Ververica, me and some colleagues started this Flink SQL cookbook as an advent calendar. This year, I decided to do something similar again, but a) in the context of Apache Flink(r) for Confluent Cloud and (b) a bit more free-form. Essentially, just one bite-sized tip or trick for Flink SQL practitioners every day leading up to Christmas Eve 2024. I originally created them for an Confluent-internal audience, and just sharing them out here for anyone who is interested.
- Advent of Flink - Day #1
TYPEOF - Advent of Flink - Day #2
EXPLAIN - Advent of Flink - Day #3 Arrays
- Advent of Flink - Day #4 Views
- Advent of Flink - Day #5 Stateful & Stateless Queries
- Advent of Flink - Day #6 State Time-to-Live
- Advent of Flink - Day #7
$rowtime&SOURCE_WATERMARK() - Advent of Flink - Day #8 The Caveats of
CURRENT_WATERMARK() - Advent of Flink - Day #9 A final look at
SOURCE_WATERMARK() - Advent of Flink - Day #10 Lateral Joins
- Advent of Flink - Day #11 Custom Event Time Columns
- Advent of Flink - Day #12 Why does Autopilot not scale up?
- Advent of Flink - Day #13
CASE WHEN - Advent of Flink - Day #14 Late Data Handling
- Advent of Flink - Day #15 Nested Rows
- Advent of Flink - Day #16 Fun with
OVERAggregations - Advent of Flink - Day #17 Reading & Writing Metadata Columns
- Advent of Flink - Day #18 "Expensive" Operators
- Advent of Flink - Day #19
SHOW CREATE TABLE - Advent of Flink - Day #20
TIMESTAMPvsTIMESTAMP_LTZ