v.23.8Improvement
Added Server Setting to Limit Array Size for groupArray Function
Added server settingaggregate_function_group_array_max_element_size. This setting is used to limit array size forgroupArrayfunction at serialization. The default value is16777215. #53550 (Nikolai Kochetov).
Why it matters
This setting addresses the issue of excessively large arrays generated bygroupArray by imposing a size limit during serialization, helping to manage memory usage and avoid potential performance degradation or failures caused by overly large array outputs.How to use it
Set the server parameteraggregate_function_group_array_max_element_size to the desired maximum size value (in bytes) to control the maximum allowed size for groupArray results. The default value is 16777215. You can configure this setting in the server's configuration file or dynamically at runtime if supported.