v.23.5Improvement

Add Memory Limit Setting for Key-Value Pair Extraction

Add setting to limit the max number of pairs produced by extractKeyValuePairs, a safeguard to avoid using way too much memory. #49836 (Arthur Passos).
Added a setting to limit the maximum number of key-value pairs produced by the extractKeyValuePairs function in ClickHouse.

Why it matters

This feature prevents excessive memory usage by imposing a safeguard on the number of pairs extracted, protecting users from potential memory overload during query execution.

How to use it

Users can enable this feature by configuring the new setting that limits the maximum number of pairs returned by extractKeyValuePairs. Adjust this setting according to your memory usage requirements to prevent overconsumption.