v.25.12Experimental Feature
Improve INSERT queries
Adds session-level settingaggregate_function_input_formatto improveINSERTqueries into tables withAggregateFunctioncolumns, allowing insertion of data as serialized state, raw values, or arrays. #88088 (Punith Nandyappa Subashchandra).
Why it matters
This feature addresses the complexity of inserting data intoAggregateFunction columns by allowing users to specify the input format. It improves flexibility and efficiency when performing INSERT operations on tables using aggregate functions, enabling better data compatibility and processing.How to use it
Set the session-level settingaggregate_function_input_format to one of the available modes (e.g., serialized state, raw values, or arrays) before executing an INSERT query on a table with AggregateFunction columns. This can be done using a SET statement, for example:SET aggregate_function_input_format = 'Serialized';
INSERT INTO table_name VALUES (...);