v.24.12Improvement

Support ALTER Migration from Object to JSON Type

Official CH changelog text
Support ALTER from Object to JSON, which means you can easily migrate from the deprecated Object type. #71784 (Pavel Kruglov).
Added support for ALTER operations to convert columns from the deprecated Object type to JSON type.

Why it matters

This feature addresses the need to migrate existing columns using the deprecated Object data type to the more modern and supported JSON type, ensuring better compatibility and future-proofing database schemas.

How to use it

Users can apply this feature by executing an ALTER TABLE statement to modify the column type from Object to JSON. For example:

ALTER TABLE table_name MODIFY COLUMN column_name JSON

Related resources

PreviousNext