v.21.11Improvements
Support ALTER TABLE for Memory Databases in ClickHouse
SupportALTER TABLEfor tables inMemorydatabases. Memory databases are used inclickhouse-local. #30866 (tavplubix).
Why it matters
This feature enables users to modify the schema ofMemory 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 standardALTER 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.