v.21.9Improvement
Updated extractAllGroupsHorizontal to allow setting upper limit on matches per row
Updated extractAllGroupsHorizontal - upper limit on the number of matches per row can be set via optional third argument. #26961 (Vasily Nemkov).Why it matters
This feature allows users to control and limit the number of regex match groups returned byextractAllGroupsHorizontal per row, preventing excessive data extraction and improving query performance and resource usage.How to use it
Users can callextractAllGroupsHorizontal with an optional third argument specifying the maximum number of matches to extract per row. For example: extractAllGroupsHorizontal(text, pattern, max_matches), where max_matches is an integer defining the upper limit.