ClickHouse capabilities for advanced developers

on YouTube ↗53m

" summary

Discusses lesser-known ClickHouse features useful for advanced developers: incremental aggregation and manipulating aggregate-function states, inter-cluster copying, and running queries without a server. Includes practical examples from Yandex service development showing how to maximize ClickHouse performance and capabilities.

AI-written summary · about

" chapters (12)

1. 0:00Introduction
2. 1:54Sampling in ClickHouse
3. 9:25Aggregate function combinators
4. 16:16Intermediate aggregate states
5. 19:48Real-time aggregation
6. 21:09Custom consistency
7. 25:11External memory aggregation
8. 30:39Working with geodata
9. 33:12ML model integration
10. 36:00Log processing with ClickHouse Local
11. 41:05Cluster data replication
12. 44:44Q&A

" related talks

• 44mUnconventional Uses of ClickHouseAleksandr Zaytsev · HighLoad++ Moscow 2018
• 59mEffective Use of ClickHouseAleksey Milovidov · HighLoad++ 2017
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017
• 49mSolving real business cases with ClickHouseDmitriy Cherobaev · Saint HighLoad++ 2025
• 53mClickHouse Is Slowing DownKirill Shvakov · HighLoad++ Moscow 2018
• 42mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Berlin Buzzwords 2023
• 53mClickHouse: blitz meetup (questions and answers)Aleksey Milovidov · HighLoad++ Moscow 2018
• 34mClickHouse® - What is Behind the Fastest Columnar Database?Olena Kutsenko · OSA Con 2022