646 signals · 904 observation events
ClickHouse® is a real-time analytics database management system
v26.7.3.19-stableOpen the original release notes for details.
Original release notes ↗Prereleases and milestones indicate public plans; they are not delivery commitments.
<!-- Related: https://github.com/ClickHouse/ClickHouse/pull/110144 --> ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.
Reverts ClickHouse/ClickHouse#112280 Closes: https://github.com/ClickHouse/ClickHouse/issues/113763 ### Changelog category (leave one): - Not for changelog (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Related: https://github.com/ClickHouse/ClickHouse/pull/112483 --> ### Changelog category (leave one): - Documentation (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/C
The tables based on `StorageSystemPartsBase` (`system.parts`, `system.parts_columns`, `system.projection_parts`, `system.projection_parts_columns`) build the whole result eagerly in `initializePipeline`, so a cancelled or timed out query kept building rows over every storage and part until the very end. In a stress test with ThreadFuzzer this took minutes an
Closes: https://github.com/ClickHouse/ClickHouse/issues/114026 ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md): Fixed `Code: 46. DB::Exception: Unknown function exists. (UNKNOWN_FUNCTION)` thrown when a `PREW
Related: https://github.com/ClickHouse/ClickHouse/pull/113978 Related: https://github.com/ClickHouse/ClickHouse/pull/114056 Related: https://github.com/ClickHouse/ClickHouse/pull/114057 Stateless tests are not allowed to modify the server's data on disk at all (https://github.com/ClickHouse/ClickHouse/pull/113978#pullrequestreview-4891978370): the stateless
Related: https://github.com/ClickHouse/ClickHouse/pull/113925 Related: https://github.com/ClickHouse/ClickHouse/pull/113225 Related: https://github.com/ClickHouse/ClickHouse/issues/113891 ### Changelog category (leave one): - Improvement ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changel
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Related: https://github.com/ClickHouse/ClickHouse/pull/113886 --> Closes: https://github.com/ClickHouse/ClickHouse/issues/114088 ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Chan
<!-- Closes: https://github.com/ClickHouse/ClickHouse/issues/113935 --> Closes: https://github.com/ClickHouse/ClickHouse/issues/113935 ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changel
Related: https://github.com/ClickHouse/NuRaft/pull/123 ## Problem With `nuraft_use_bg_thread_for_snapshot_io` enabled, a Keeper server added to the cluster never joins. The leader's catch-up loop waits indefinitely for a response that cannot arrive, so the configuration change is never committed. The setting is off by default, which is why this has gone unno
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. --> Related: https://github.com/ClickHouse/ClickHouse/pull/101781 Related: https://github.com/ClickHouse/ClickHouse/pull/101750 Related: https://github.com/ClickHouse/ClickHouse/pull/103984 Related: https://github.com/ClickHouse/ClickHouse/
Closes: https://github.com/ClickHouse/ClickHouse/issues/112233 Related: https://github.com/ClickHouse/ClickHouse/issues/114291 The reference vector of an ANN query is extracted only when its array type is `Float64`, `Float32` or `BFloat16` and every element is a `Float64` field. An integer literal such as `[1, 2]` is typed `Array(UInt8)`, so `tryUseVectorSea
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Related: https://github.com/ClickHouse/ClickHouse/pull/113397 --> ### Changelog category (leave one): - CI Fix or Improvement (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/Clic
Reverts ClickHouse/ClickHouse#114326 Depends on https://github.com/ClickHouse/ClickHouse/pull/113397
Closes: https://github.com/ClickHouse/ClickHouse/issues/114411 Related: https://github.com/ClickHouse/ClickHouse/issues/59304 Related: https://github.com/ClickHouse/ClickHouse/pull/110975 Implement the `Cluster` database engine, a follow-up to the `Remote` database engine (#110975). It provides real-time access to the tables of a database on a cluster from t
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Related: https://github.com/ClickHouse/ClickHouse/pull/110166 --> ### Changelog category (leave one): - CI Fix or Improvement (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/Clic
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Related: https://github.com/ClickHouse/ClickHouse/pull/113289 --> ### Changelog category (leave one): - CI Fix or Improvement (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/Clic
<!-- Related: https://github.com/ClickHouse/ClickHouse/issues/93064 --> ### Changelog category (leave one): - CI Fix or Improvement (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): ...
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Closes: https://github.com/ClickHouse/ClickHouse/issues/114612 --> ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://githu
### Changelog category: - New Feature ### Changelog entry [Users can now validate which secondary indices are fully materialized in a data part via the new “secondary_indices_materialized” column in the “system.parts” table.] ### Documentation entry for user-facing changes - [x] Documentation is written (mandatory for new features) # secondary_indices_materi
### Changelog category (leave one): - Improvement ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): Add fields last_error_symbols, last_error_lines to system.errors and system.error_log table. Resolves https://github.co
Builds on top of #103234 (ReadPipeline). Gated by `SET use_reader_executor = 1` (experimental, default off). This commit replaces the matryoshka of `ReadBuffer` wrappers with a `ReaderExecutor` that owns offset mapping, cache decisions, prefetch and decryption in one place. Caches plug in via a uniform `ICacheProvider` / `ICacheHandle` API. ## What this brin
This PullRequest is a part of ClickHouse release cycle. It is used by CI system only. Do not perform any changes with it. <!-- CURSOR_SUMMARY --> --- > [!NOTE] > **Medium Risk** > Touches security-sensitive internal/DDL execution gating by replacing `query_kind` checks with a new server-set flag, which could affect ON CLUSTER/replication/backup behavior if m
### Changelog category (leave one): - New Feature ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): Use new create table transaction resolves https://github.com/ClickHouse/ClickHouse/issues/103155 this needs https://git
Resolves #106219 Implement a new experimental compression codec `LossyQuantile` that encodes floating-point values as K-bit indices into per-group empirical quantile codebooks. **Syntax:** `CODEC(LossyQuantile(bits [, group_size [, stripe_size]]))` The codec accepts parameters: - `bits` (1-8): number of bits per encoded value, controls compression ratio vs.
`database_replicated_allow_only_replicated_engine` rejects table engines that keep their own unreplicated data on disk in a `Replicated` database. Before this change, `Distributed` was also rejected because its optional background `INSERT` queue makes `storesDataOnDisk` return true, even though the queue is a transient send buffer and the table's actual data
Related: https://github.com/ClickHouse/ClickHouse/pull/109592 Related: https://jira.mariadb.org/browse/CONC-834 **Problem.** The file-descriptor poll timeout can silently never expire on a query thread. `ReadBufferFromFileDescriptor::poll` restarts the interrupted `poll` with the full original timeout after `EINTR`, resetting the deadline on every signal. Qu
<!-- Related: https://github.com/ClickHouse/ClickHouse/pull/107074 --> ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.
Pressing **Stop** while a query is running keeps the progress spinner (the hourglass in the Web UI toolbar) spinning indefinitely. `cancel()` invalidates the in-flight request (bumps `request_num`) and aborts the fetch, so the awaiting `postSingle`/`postImpl` path bails out early without calling `finish()`/`clear()` — nothing hides the spinner. This fix stop
This the first which introduces support for ALTER DROP PARTITION on iceberg tables - supports transformations in partition expression e.g - removes only manifests which were present on the moment of execution of a query - does not support catalogs - does not support schema evolution - does not support partition evolution - does not support "mixed manifests",
Closes: https://github.com/ClickHouse/ClickHouse/issues/111291 This PR adds optional all-distinct materialization for automatic cardinality statistics. It is intended for column types where building a full cardinality sketch can be expensive and the data is commonly close to unique. New user-visible MergeTree settings: - `auto_statistics_assume_floats_distin
### Changelog category (leave one): - Improvement ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): Add STREAM UNORDERED modifier: skip the per-snapshot commit-order sort depends on https://github.com/ClickHouse/ClickHo
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. --> Related: https://github.com/ClickHouse/ClickHouse/pull/107366 ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://github
Related: https://github.com/ClickHouse/ClickHouse/pull/105056 ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): Fixe
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Related: https://github.com/ClickHouse/ClickHouse/pull/111775 --> ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://github
> **Series:** **#112871** → #112875 (this), #112872, #112873, #112874, #112876 ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md): Retry a transient Azure `AuthenticationException` (credential/token-acquisition
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Closes: https://github.com/ClickHouse/ClickHouse/issues/NNNNN (auto-closes the issue when this PR is merged into the default branch) Related: https://github.com/ClickHouse/ClickHouse/pull/NNNNN --> Closes: https://github.com/ClickHouse/Clic
Related: https://github.com/ClickHouse/ClickHouse/pull/113022 Fix incorrect result filtering when a `JSONAllValues` text index serializes a comparison constant using a representation that differs from the JSON subcolumn. This includes value-changing coercions such as `IPv4` to `UInt32`, types such as `Bool` whose semantic equality does not imply identical te
`IMergeTreeDataPart::getEstimates` (introduced in #87241) builds the per-part statistics estimates used by part pruning and by `system.parts_columns`. Before this change it always consulted a per-part estimates cache and ignored the `use_statistics_cache` setting (introduced in #88670): a session that sets `use_statistics_cache = 0` still got the cached valu
### Changelog category (leave one): - Not for changelog (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): ... ### Description Comparing two arrays whose element types have no least supe
<!--- A technical comment, you are free to remove or leave it as it is when PR is created The following categories are used in the next scripts, update them accordingly utils/changelog/changelog.py tests/ci/cancel_and_rerun_workflow_lambda/app.py --> ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Ch
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Closes: https://github.com/ClickHouse/ClickHouse/issues/NNNNN (auto-closes the issue when this PR is merged into the default branch) Related: https://github.com/ClickHouse/ClickHouse/pull/NNNNN --> ### Changelog category (leave one): - CI F
<!--- A technical comment, you are free to remove or leave it as it is when PR is created The following categories are used in the next scripts, update them accordingly utils/changelog/changelog.py tests/ci/cancel_and_rerun_workflow_lambda/app.py --> ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Ch
Closes: https://github.com/ClickHouse/ClickHouse/issues/111352 Related: https://github.com/ClickHouse/ClickHouse/issues/111748 ## Motivation `system.query_log` says almost nothing about what the JOINs in a query actually did. Answering questions like "which queries ran a `CROSS` join we didn't expect", "which joins fell back to `grace_hash` and spilled to di
### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a user-readable short description of the changes that goes into CHANGELOG.md): Fix undefined behavior and wrong results in `avg` over `Date`/`DateTime`/`DateTime64`/`Time`/`Time64`: the average is now computed exactly in integer space,
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. Related: https://github.com/ClickHouse/ClickHouse/issues/98898 --> ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://githu
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. --> Related: https://github.com/ClickHouse/ClickHouse/pull/112846 ### Changelog category (leave one): - CI Fix or Improvement (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/Clic
Related: https://github.com/ClickHouse/ClickHouse/pull/112693 ### Changelog category (leave one): - Bug Fix (user-visible misbehavior in an official stable release) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): Fixe
### Changelog category (leave one): - CI Fix or Improvement (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.md) of the changes that goes into CHANGELOG.md): ... ### Description `02950_part_log_bytes_uncompressed` and `02491_part_log
<!-- Linked issues and pull requests. Use full GitHub URLs, one relationship per line; delete the lines you don't need. --> ### Changelog category (leave one): - CI Fix or Improvement (changelog entry is not required) ### Changelog entry (a [user-readable short description](https://github.com/ClickHouse/ClickHouse/blob/master/docs/changelog_entry_guidelines.