Update and Delete in Clickhouse

Update command

ALTER TABLE <table_name> UPDATE col1 = expr1, ... WHERE <filter>;

Delete command

ALTER TABLE <table_name> DELETE WHERE <filter>;

Reference

Updates and Deletes in ClickHouse