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.

Read More
Webinar Slides. Fast Insight from Fast Data. Integrating ClickHouse and Apache Kafka

By Robert Hodges and Mikhail Filimonov
Slides for the Webinar, presented on Jan 21, 2020 
Webinar recording is available here

Apache Kafka is a popular way to load large data volumes quickly to ClickHouse. In this webinar we will cover best practices for integrating Kafka and ClickHouse including setup of Kafka clusters, defining materialized views to pull data into ClickHouse, and organization of target tables. We will also cover alternatives like writing your own connector applications. Altinity is now the community maintainer for ClickHouse Kafka.

Read More
Webinar: A Practical Introduction to Handling Log Data in ClickHouse

December 17, 2019
with Robert Hodges

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.
Watch the recording

Read More
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.

Read More
Webinar: A Practical Introduction to Handling Log Data in ClickHouse

December 17, 2019
with Robert Hodges

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.

Read More