News
News
What changed in ClickHouse and around it — releases, acquisitions, events — with a line on why it matters.
- release-notesClickHouse 26.10: function composition, joins on any condition and a long upgrade checklist26.10 adds the f | g composition operator, Trino-style SQL, JOIN on arbitrary ON conditions, experimental LATERAL JOIN, Overlay databases and top-K filtering for GROUP BY LIMIT, and ships 37 backward-incompatible changes, from a seccomp filter at startup to arrayCount returning UInt64.
- release-notesClickHouse 26.9: LIMIT AFTER/UNTIL, incremental refreshable views and ZSTD by default26.9 adds boundary-based LIMIT, APPEND INCREMENTAL refreshes, DISTINCT spilling and scoped tokens, and changes the default compression from LZ4 to ZSTD(3) while removing the old analyzer, WINDOW VIEW and CatBoost.
- release-notesClickHouse 26.8 LTS: pipe syntax, background queries and a faster GROUP BYThe 26.8 long-term-support release adds pipe SQL, queries that survive a dropped connection, IEJoin, new text tokenizers and an adaptive GROUP BY, and changes max_insert_threads to auto.
- release-notesClickHouse 26.7: EXPLAIN ANALYZE, leaner joins and a stricter S3 credential model26.7 finally gives you EXPLAIN ANALYZE, makes hash joins smaller and faster, speeds up decompression on every scan, and changes two defaults you must plan for: S3 credentials and insert deduplication.
- release-notesClickHouse 26.6: hypothetical indexes, first continuous queries, and a data-loss footgun closed26.6 lets you test a skip index before building it, runs the first continuous queries over MergeTree, makes Keeper about twice as fast, and changes three defaults: insert deduplication, the x86 baseline and REPLACE PARTITION.