v.18.12New Feature

Added Support for ALTER UPDATE Queries

Added support for ALTER UPDATE queries. #3035
Added support for ALTER UPDATE queries in ClickHouse, enabling users to perform updates on existing data within tables.

Why it matters

This feature allows users to modify existing records in ClickHouse tables, addressing the common need to update data without requiring full table rewrites or manual workarounds. It enhances data management flexibility and simplifies workflows where data correction or adjustments are necessary.

How to use it

Users can apply the feature by executing ALTER TABLE <table_name> UPDATE <column> = <value> WHERE <condition> queries. This syntax enables updating column values for rows that match the specified condition directly.