[CALCITE-5910] Add REGEXP_EXTRACT and REGEXP_SUBSTR functions (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 17:37
• Updated: 21/Dec/23 22:34
• Resolved: 30/Aug/23 19:51

Description

Add support for REGEXP_EXTRACT and REGEXP_SUBSTR functions from BigQuery.

REGEXP_EXTRACT(value, regexp[, position[, occurrence]])
Returns the substring in value that matches the regular expression regexp. Returns NULL 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 returned. If there are multiple matches for a capturing group, the last match is returned.
• If position is specified, the search starts at this position in value, otherwise it starts at the beginning of value.
• If occurrence is specified, the search returns a specific occurrence of the regexp in value, otherwise returns the first match.

 
REGEXP_SUBSTR(value, regexp[, position[, occurrence]])
Synonym for REGEXP_EXTRACT

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)
• relates to: CALCITE-6172 Allow aliased operators to re-use existing tests
• links to: GitHub Pull Request #3369