v.23.10Improvement

Implement Query Parameters Support for ALTER TABLE ... ACTION PARTITION

Implement query parameters support for ALTER TABLE ... ACTION PARTITION [ID] {parameter_name:ParameterType}. Merges #49516. Closes #49449. #55604 (alesapin).
Implemented support for query parameters in ALTER TABLE ... ACTION PARTITION [ID] {parameter_name:ParameterType} commands.

Why it matters

This feature enables users to define and use parameters within ALTER TABLE ... ACTION PARTITION queries, improving flexibility and usability when performing partition-related operations on tables. It solves the limitation of hardcoded values by allowing dynamic parameter passing, making partition actions more customizable and reusable.

How to use it

Users can apply this feature by specifying parameters in the ALTER TABLE ... ACTION PARTITION [ID] query syntax, for example:

ALTER TABLE table_name
ACTION PARTITION 'partition_id'
{
param_name:ParameterType
}


where param_name is the parameter identifier and ParameterType is its data type.