v.18.12New Feature
Added Support for ALTER UPDATE Queries
Added support for ALTER UPDATE queries. #3035Why 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 executingALTER TABLE <table_name> UPDATE <column> = <value> WHERE <condition> queries. This syntax enables updating column values for rows that match the specified condition directly.