flink-sql-cookbook

(★ 915)

The Apache Flink SQL Cookbook is a curated collection of examples, patterns, and use cases of Apache Flink SQL. Many of the recipes are completely self-contained and can be run in Ververica Platform as is.

File Explorer

Download Latest Version (.zip)

- CODEOWNERS
- - 01_group_by_window.md
  - 01_group_by_window_tvf.md
  - 01_group_by_window_tvf_result.png
- - 02_watermarks.md
- - 03_group_by_session_window.md
- - 04_over.md
- - 05_top_n.md
- - 06_dedup.md
- - 07_chained_windows.md
- - 08_match_recognize.md
- - 09_cdc_materialized_view.md
- - 10_hopping_time_windows.md
  - 10_hopping_time_windows.png
- - 11_window_top_n.md
  - 11_window_top_n.png
- - 12_lag.gif
  - 12_lag.md
- - 01_create_table.md
- - 02_insert_into.md
- - 03_temporary_table.md
- - 04_where.md
- - 05_group_by.md
- - 06_order_by.md
- - 07_views.md
- - 08_statement_sets.md
- - 09_convert_timezones.gif
  - 09_convert_timezones.md
- - 01_regular_joins.md
- - 02_interval_joins.md
- - 03_kafka_join.md
- - 04_lookup_joins.md
- - 05_star_schema.md
- - 06_lateral_join.md
- - 01_date_time.md
- - 02_union-all.md
- - 03_current_watermark.md
  - 03_current_watermark.png
  - 03_late_data.png
- - 04_override_table_options.md
  - 04_override_table_options.screen01.png
  - 04_override_table_options.screen02.png
  - airports.csv
- - 05_complex_data_types.png
  - 05_expanding_arrays.md
  - 05_joined_unnested_data.png
  - 05_unnested_data.png
- - 06_split_strings_into_maps.md
  - 06_split_strings_into_maps.png
- - 01_python_udfs.md
  - python_udf.py
.gitignore
LICENSE
README.md

# Installation Guide

1. Get the code

git clone https://github.com/ververica/flink-sql-cookbook

Downloads the entire project code from GitHub to your computer.

cd flink-sql-cookbook

Moves into the project folder you just downloaded.

2. Docker

Easy Recommended

Prerequisites

Git Needed to download the project code from GitHub.
Docker Desktop Needed to build and run containers. Install it and keep it running in the background.

⚠️ This is a large repository, so this method may point to an internal sub-package rather than the actual core product. Check the full README as well.

docker compose -f aggregations-and-analytics/09_cdc_materialized_view/docker/docker-compose.yml up -d --build

Runs the command against the services defined in the compose file.

✅ Run docker compose ps to check the containers are Up. If the README mentions a port, open http://localhost:PORT in your browser.