v.23.12Improvement

Allow Overwriting max_partition_size_to_drop and max_table_size_to_drop at Query Time

Allow to overwrite max_partition_size_to_drop and max_table_size_to_drop server settings in query time. #57452 (Jordi Villar).
Allow overriding max_partition_size_to_drop and max_table_size_to_drop server settings dynamically at query time.

Why it matters

This feature enables users to temporarily modify the limits that control the maximum partition and table sizes allowed to be dropped in a query, providing more flexibility and control without requiring server restarts or permanent configuration changes.

How to use it

Users can override the settings by specifying max_partition_size_to_drop and max_table_size_to_drop as query-level settings, for example using the SET clause in SQL or passing them as client settings during query execution.