ClickHouse 26.1 is here! In this post, you will learn about deduplication of asynchronous inserts with materialized views, new syntax for indexing projections, support for Variant in all functions, and more!

ClickHouse is a leading platform for open-source columnar database technology and real-time analytics. With ClickHouse, developers can delve into documentation, case studies, and performance benchmarks to learn how to build highly scalable and performant analytical systems. It provides tips about ClickHouse's storage engine, query execution, and distributed architecture. Developers can gain insights into their data in real-time, enabling them to make informed decisions and extract  business insights.

ClickHouse

ClickHouse 26.1 brings 25 new features, 43 performance optimizations, and 176 bug fixes. Key improvements include end-to-end deduplication for asynchronous inserts with materialized views, new indexing projection syntax, faster DISTINCT operations on LowCardinality columns, and enhanced introspection tools for MergeTree tables and Keeper. The release also adds Variant type support across all functions, text index improvements with sparseGrams tokenizer, and promotes QBit vector search to beta. Additionally, ClickHouse now offers an open-source Kubernetes operator for automated cluster management.

ClickHouse Release 26.1

Deduplication of asynchronous inserts with materialized views #

Faster DISTINCT over LowCardinality columns #

Introspection and diagnostics for MergeTree tables and Keeper #