v.21.11Improvements

Support ALTER TABLE for Memory Databases in ClickHouse

Support ALTER TABLE for tables in Memory databases. Memory databases are used in clickhouse-local. #30866 (tavplubix).
Support for ALTER TABLE commands has been added to tables within Memory databases, which are commonly used in clickhouse-local.

Why it matters

This feature enables users to modify the schema of Memory database tables in clickhouse-local using ALTER TABLE statements, improving flexibility and usability in local, in-memory data processing scenarios.

How to use it

Users can now apply standard ALTER TABLE commands on tables created in Memory databases while working in clickhouse-local. For example, after creating a table in a Memory database, use an ALTER TABLE statement to add, modify, or drop columns as needed.