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).Why it matters
This feature enables users to define and use parameters withinALTER 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 theALTER 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.