ClickHouse supports the UPDATE statement and is capable running real-time updates as fast as it runs INSERTs. This is possible thanks to the patch parts data structure, which allows quickly applying changes without a significant impact on the SELECT performance. Moreover, due to MVCC (multi-version concurrency control) and snapshot isolation, updates provide ACID properties.Documentation Index
Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
Lightweight updates were first introduced in ClickHouse version 25.7.