webinar
Webinar: A Fast Intro to Fast Query with ClickHouse
Join us on March 6 at 6 pm GMT / 1 pm EST / 10am PST
Extracting business insight from massive pools of machine-generated data is the central analytic problem of the digital era. ClickHouse data warehouse addresses the problem with sub-second SQL query response on petabyte-scale data sets. In this talk we'll discuss the features that make ClickHouse increasing popular, show you how to install it, and teach you enough about how ClickHouse works so you can try it out on real problems of your own. We'll have cool demos (of course) and gladly answer your questions at the end.
Webinar: ClickHouse on Kubernetes!
Join us on April 16, 2019 3 pm GMT / 10 am EST / 7am PST
Data services are the latest wave of applications to catch the Kubernetes bug. Altinity is pleased to introduce the ClickHouse operator, which makes it easy to run scalable data warehouses on your favorite Kubernetes distro. This webinar shows how to install the operator and bring up a new data warehouse in three simple steps. We also cover storage management, monitoring, making config changes, and other topics that will help you operate your data warehouse successfully on Kubernetes. There is time for demos and Q&A, so bring your questions. See you online!
REGISTER HERE
Webinar: Analyzing Billion Row Datasets with ClickHouse
Join us on June 5, 2019 6 pm GMT / 1 pm EST / 10 am PST
This talk shows how to get sub-second response from datasets containing a billion rows or more. We'll start with defining schema and loading quickly data in parallel. We will then introduce tricks like LowCardinality datatype, ASOF joins, and materialized views that can reduce query response to thousandths of seconds. Finally we'll show you metrics and logging to analyze query performance. After this talk you'll be ready for your first billion rows and many more afterwards.
Watch recording here
Introduction to the Mysteries of ClickHouse Replication
Join us on July 31, 2019 6 pm GMT / 1 pm EST / 10 am PST
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!
Recording is available here
Webinar: Altinity Cluster Manager. ClickHouse Management for Kubernetes and Cloud
Join us on August 21, 2019 6 pm GMT / 1 pm EST / 10 am PST
Simplified management is a prerequisite for running any data warehouse at scale. Altinity is developing a new web-based console for ClickHouse called the Altinity Cluster Manager. It's now in beta and offers simplified operation of ClickHouse installations for users. In this webinar we introduce the ACM and demonstrate use on Kubernetes as well as Amazon Web Services. Attendees are welcome to sign up as beta testers and provide feedback. Please join us to see the future of Clickhouse management!
Recording is available here
Webinars: Secrets of ClickHouse Query Performance. September 11 or 17
September 11 or 17 , 2019
with Robert HodgesClickHouse is famous for speed.
That said, you can almost always make it faster! This webinar uses examples to teach you how to deduce what queries are actually doing by reading the system log and system tables. We'll then explore standard ways to increase query speed: data types and encodings, filtering, join reordering, skip indexes, materialized views, session parameters, to name just a few. In each case we'll circle back to query plans and system metrics to demonstrate changes in ClickHouse behavior that explain the boost in performance. We hope you'll enjoy the first step to becoming a ClickHouse performance guru!
This topic is so important, that we decided to do this webinar twice! Read more to pick your time.
Webinar: Adding Fast Analytics to MySQL Applications with ClickHouse
October 10 , 2019
with Robert Hodges
Successful MySQL applications have a very common scale problem: how to provide analytics when data grows too large for MySQL to handle. Fortunately, there is a good answer. ClickHouse is a popular, open source column store you can use to add fast analytics to MySQL applications. We'll start with an introduction to ClickHouse for MySQL users showing familiar SQL syntax and table engine design. We'll then walk through important features like support for MySQL wire protocol, ability to read data directly from MySQL tables, and different ways to move data from MySQL into ClickHouse. Finally, we'll touch on design approaches that allow you to extend MySQL applications with analytics that can handle billions of rows.
Watch here
Webinar: Tips and tricks every ClickHouse user should know
December 3 , 2019
with Robert Hodges
New users of ClickHouse love the speed but may run into a few surprises when designing applications. Column storage turns classic SQL design precepts on their heads. This talk shares our favorite tricks for building great applications. We'll talk about fact tables and dimensions, materialized views, codecs, arrays, and skip indexes, to name a few of our favorites. We'll show examples of each and also reserve time to handle questions. Join us to take your next step to ClickHouse guruhood!
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
Webinar: Fast Insight from Fast Data: Integrating ClickHouse and Apache Kafka
January 21, 2020
with Robert Hodges
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. Our lead Kafka engineer Mikhail Filimonov will be in the webinar to share the latest tips for successful Kafka use. Please join us and bring your questions!