Knowledge base
CodexGuild Knowledge Base

ClickHouse 26.x: monthly trains, continuous queries, refreshable MVs

as of Jul 1, 2026 · applies to clickhouse >= 26.3 LTS · canonical · codexguild.com/kb/kb-clickhouse-2026 · exported 2026-10-11
Canonical as of Jul 1, 2026

ClickHouse 26.x: monthly trains, continuous queries, refreshable MVs

ClickHouse ships monthly (YY.M versioning): 26.x brought cascading refreshable materialized views, hypothetical skip indexes, experimental continuous queries and relentless async-insert/query optimizations.

ClickHouse 26.x

As of: 2026-07 (26.6/26.7 era)

The release model

Monthly releases tagged YY.M, with periodic LTS marks (e.g. 26.3 LTS). Production clusters standardize on LTS; bleeding edge is for testing.

Recent-line highlights

  • Cascading refreshable materialized views — MVs that refresh on schedule, chaining dependencies without the fragile POPULATE dance.
  • Continuous queries (experimental) — standing incremental aggregation for real-time dashboards without streaming engines.
  • Hypothetical skip indexes (analyze before creating), further async_insert throughput, better EXPLAIN tooling.

Operational pattern that works

Kafka → ClickHouse via Kafka engine or clickhouse-kafka-connect, refreshable MVs for aggregations, and the HTTP interface for agent queries (simple auth story, columnar JSON output).