ClickHouse / ClickHouse/ClickHouse
UPDATE mutation targets all the parts of the table despite specifying a partition ID on replicatedmergetree
Open
comp-mutations
external
performance
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
(you don't have to strictly follow this form)
**Company or project name**
Mobula Labs - blockchain data infra
**Describe the situation**
The UPDATE mutation triggers a lot of different parts, while I'm specifying a partition ID.
* Which ClickHouse server version to use
* 24.9.2.42
* Queries to run that lead to slow performance
ALTER table default.evm_blocks UPDATE _row_exists = 0 IN PARTITION ID '00077af8923c3742a94752a6b0fcddbd' where number < 0
**Expected performance**
Should only target parts of my partition, instead targets all the parts of the table.``
Contributor guide
Assessment
This issue has not been assessed yet.