Altinity
ClickHouse Leading Service Provider

ClickHouse Webinars

Posts tagged Materialized views
Upcoming Webinar: Introduction to the Mysteries of ClickHouse Replication

July 31, 2019
By Robert Hodges

Built-in replication is a powerful ClickHouse feature that helps scale data warehouse performance as well as ensure high availability. This webinar will introduce how replication works internally, explain configuration of clusters with replicas, and show you how to set up and manage ZooKeeper, which is necessary for replication to function. We'll finish off by showing useful replication tricks, such as utilizing replication to migrate data between hosts. Join us to become an expert in this important subject!

Register here

Read More
Webinar: ClickHouse and the Magic of Materialized Views

June 26, 2019
By Robert Hodges and Altinity Engineering Team
Speaker: Robert Hodger, Altinity CEO
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.

Read More