ClickHouse Podcast

Welcome to our latest episode, where we delve into the cutting-edge world of data management and analytics. Today, we're exploring how to revolutionize your data workflow by integrating ClickHouse with Docker. Join us as we unlock the secrets to high-speed data handling and master the art of efficient data queries. From installation to insight, we'll guide you through streamlining your analytics p...

Welcome to the ClickHouse podcast! This podcast will explore the world of ClickHouse string functions, from basic operations to advanced manipulations. You will learn essential techniques for efficient data processing in ClickHouse. Whether you're a seasoned developer or a data engineer just starting out, this podcast is your go-to resource for mastering ClickHouse string functions . Each episode...

ClickHouse 24.10: A Powerful Upgrade This podcast will explore the exciting new features and improvements introduced in ClickHouse version 24.10. This version boasts major enhancements in query flexibility, security, and performance. Enhanced JSON support: ClickHouse 24.10 introduces new settings for reading and writing JSON, including options for handling JSON as binary strings and serializing/de...

On this episode, we sit down with Robert Hodges, a key figure in the ClickHouse community and a driving force behind its rise in the U.S., who joins us as our inaugural live guest. His collaboration with Alexander Zaitsev of Altinity has significantly boosted the visibility and adoption of ClickHouse since its open-source release by Yandex in 2016. From their early challenges with Kubernetes to th...

Unlock the secrets of ClickHouse's analytical prowess with our latest episode, where we promise you'll gain unparalleled insights into funnel analysis. Picture yourself boosting conversion rates at your online taco shop by mastering the Window Funnel function—track crucial user events like menu views, cart additions, and purchases all within a specific time frame. Discover how to identify drop-off...

Unlock the secrets to turbocharging your ClickHouse performance with our latest episode, where we promise to transform your taco order queries into a slick, high-speed operation. Through engaging examples and witty analogies, we take you on a journey to master the art of primary keys not as guardians of uniqueness but as champions of query speed. Discover how arranging columns from low to high car...

This episode of the ClickHouse Podcast discusses how to flatten DynamoDB JSON using ClickHouse to set up a scalable, analyzable pipeline. DynamoDB is a key-value and document database, while ClickHouse is a columnar store. This transformation makes it significantly easier to query the data in ClickHouse. The process involves creating multiple Materialized Views that help unpack the nested JSON str...

In this episode of the ClickHouse Podcast , the hosts explore the ReplacingMergeTree table engine in ClickHouse. ReplacingMergeTree is designed to handle mutable data, replacing rows with the same primary key instead of appending new ones. It merges rows based on a defined sorting key, keeping only the latest version and removing outdated ones. This engine is useful for cases like real-time update...

In this podcast episode, we dive into the latest release of ClickHouse and dissect the changelog. ClickHouse version 24.9 introduces significant improvements to security, usability, and performance. New features include multiple authentication methods per user, overlay string functions, and partition-level lightweight deletes. The update includes performance enhancements for JOIN operations, files...

This episode explains how to optimize ClickHouse performance for fast and reliable analytics. The podcast focuses on ClickHouse's unique features, such as columnar storage, full-fledged DBMS capabilities, and distributed architecture, as crucial elements for achieving optimal performance. The hosts dive deep into four specific optimization strategies: designing the database schema, optimizing quer...