Webinar: A Practical Introduction to Handling Log Data in ClickHouse

By Robert Hodges on November 25th, 2019

Webinar: A Practical Introduction to Handling Log Data in ClickHouse

ClickHouseLog Data

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.

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. 😉

You can find slides for this webinar HERE

Please register below to watch webinar recording.

More Webinars

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

August 6, 2020 with Alexander Zaitsev and Robert Hodges Curious what's new in ClickHouse? This talk is for you! Join us to learn about new features of ClickHouse, ranging from tiered storage to compact MergeTree format to SQL join improvements. We'll also preview new features like object storage and LDAP support planned for the remainder of 2020. Finally, we'll discuss 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!

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

July 9, 2020 with Marcel Birkner, Yoann Buch and Robert Hodges 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.

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

June 23, 2020 with Adam Brown and Robert Hodges 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.