v.24.9Improvement

Restore Mode Fix for External Table Engines and Functions in ClickHouse

Official CH changelog text
Restore mode that replaces all external table engines and functions to the Null engine (restore_replace_external_engines_to_null, restore_replace_external_table_functions_to_null settings) was failing if table had SETTINGS. Now it removes settings from table definition in this case and allows to restore such tables. #69253 (Ilya Yatsishin).
Fixed restore mode for tables with external engines or functions set to Null engine that previously failed when tables had SETTINGS defined by removing these settings during restore.

Why it matters

The feature ensures that when using restore mode with the settings restore_replace_external_engines_to_null and restore_replace_external_table_functions_to_null, tables that include SETTINGS no longer cause restore failures. This improves robustness and usability when restoring tables involving external engines or functions by safely removing incompatible settings.

How to use it

Enable the restore mode with the settings restore_replace_external_engines_to_null and/or restore_replace_external_table_functions_to_null. When restoring tables configured with external engines or functions that include SETTINGS, the settings will automatically be removed to allow successful restoration.

Related resources

PreviousNext