Webinar Slides: ClickHouse and the Magic of Materialized Views

By Robert Hodges on June 26th, 2019

Webinar Slides: ClickHouse and the Magic of Materialized Views

Robert Hodges Altinity OperatorClickHouseKuberneteswebinar

 

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

Materialized views are a killer feature of ClickHouse that can speed up queries 200X or more. Our webinar will teach you how to use this potent tool starting with how to create materialized views and load data. We’ll then walk through cookbook examples to solve practical problems like deriving aggregates that outlive base data, answering last point queries, and using AggregateFunctions to handle problems like counting unique values, which is a special ClickHouse feature. There will be time for Q&A at the end. At that point you’ll be a wizard of ClickHouse materialized views and able to cast spells of your own.

Speaker Bio:
Robert Hodges is CEO of Altinity, which offers enterprise support for ClickHouse. He has over three decades of experience in data management spanning 20 different DBMS types. ClickHouse is his current favorite. 😉

Leave a Reply

More Presentations

Webinar Slides. ClickHouse Unleashed 2020: Our Favorite New Features for Your Analytical Applications

Curious what’s new in ClickHouse? This talk is for you! Watch to learn about new features of ClickHouse, ranging from tiered storage to compact MergeTree format to SQL join improvements. Preview new features like object storage and LDAP support planned for the remainder of 2020. We close out, by discussing Altinity Stable Releases and how they help you decide when features are ready for production use. Don’t miss this opportunity to get current on ClickHouse improvements to help you build even better analytics!

Webinar Slides. Adventures in Observability: How In-House ClickHouse Deployment Enabled Instana to Build Better Monitoring for Users

Instana is an Application Performance Monitoring solution that provides complete visibility into complex distributed systems, including ClickHouse servers. In this webinar, we welcome Marcel Birkner and Yoann Buch of Instana. They describe how the Instana team uses ClickHouse to power their solution, lessons they have learned, and how they integrated them back into Instana's own ClickHouse monitoring features. Along the way, you'll learn how to set up Instana on ClickHouse, what important metrics you should track, how ClickHouse is integrated in end-to-end distributed tracing, and what level of automation is available for root cause analysis and alerting.

Webinar Slides. Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale

By Adam Brown and Robert Hodges Slides for the Webinar, presented on June 23, 2020 Webinar recording is available here Mux.com enables content providers to stream video to vast audiences while maintaining pin-point control over performance. Join us as Adam Brown, a co-founder of Mux and video expert, explains the role that ClickHouse plays in content delivery. We'll start with an overview of the Mux platform and the importance of real-time feedback. We'll then discuss key features of ClickHouse that enable it to ingest live session data and provide real-time dashboards to Mux users. Finally, we'll talk a bit about the Mux journey to ClickHouse and lessons learned along the way about how data enables content delivery networks.