v.21.7New Feature

Support ALTER DELETE Queries for Join Table Engine

Support ALTER DELETE queries for Join table engine. #23260 (foolchi).
Support for ALTER DELETE queries on tables using the Join table engine in ClickHouse.

Why it matters

This feature enables users to perform ALTER DELETE operations directly on Join engine tables, allowing more flexible data management and cleaning without needing to rebuild or replace the join tables manually.

How to use it

Users can now execute ALTER TABLE <table_name> DELETE WHERE <condition> commands on tables created with the Join engine to delete matching rows as specified by the condition.