Webinar Slides. ClickHouse Materialized Views: The Magic Continues

By Robert Hodges
Slides for the Webinar, presented on Feb 26, 2020
Webinar recording is available here

Materialized views are the killer feature of ClickHouse, and the Altinity 2019 webinar on how they work was very popular. Join this updated webinar to learn how to use materialized views to speed up queries hundreds of times. We’ll cover basic design, last point queries, using TTLs to drop source data, counting unique values, and other useful tricks. Finally, we’ll cover recent improvements that make materialized views more useful than ever.

Webinar: A Practical Introduction to Handling Log Data in ClickHouse

Webinar: A Practical Introduction to Handling Log Data in ClickHouse

Log messages are one of the most important types of application data. ClickHouse is very good at storing log data; many SaaS applications use it under the covers. In this webinar we will show examples of different application logs and how to design tables to store them. Options include using typed columns, strings, JSON, or key-value pair arrays. We’ll also discuss how materialized columns to improve filter speed, as well as techniques to tune index granularity for wide rows.

Webinar Slides. A Practical Introduction to Handling Log Data in ClickHouse

By Robert Hodges and Altinity Engineering Team
Slides for the Webinar, presented on Dec 17, 2019 
Webinar recording is available here

Log messages are one of the most important types of application data. ClickHouse is very good at storing log data; many SaaS applications use it under the covers. In this webinar we will show examples of different application logs and how to design tables to store them. Options include using typed columns, strings, JSON, or key-value pair arrays. We’ll also discuss how materialized columns to improve filter speed, as well as techniques to tune index granularity for wide rows. This is the first in a series of webinars on log management. Future webinars will cover tools to load data as well as techniques to retrieve log information efficiently.