[CALCITE-5911] Add REGEXP_EXTRACT_ALL function (enabled in BigQuery library)

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: Jerin John
• Reporter: Jerin John
• Created: 08/Aug/23 18:53
• Updated: 10/Nov/23 11:34
• Resolved: 31/Aug/23 23:56

Description

Add support for REGEXP_EXTRACT_ALL function from BigQuery.

REGEXP_EXTRACT_ALL(value, regexp)
Returns an array of all substrings of value that match the re2 regular expression, regexp. Returns an empty array if there is no match.

• If the regular expression contains a capturing group ((...)), and there is a match for that capturing group, that match is added to the results. If there are multiple matches for a capturing group, the last match is added to the results.

Issue Links

• is a child of: CALCITE-5858 Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE and REGEXP_SUBSTR functions (enabled in BigQuery library)
• links to: GitHub Pull Request #3387