[CALCITE-5979] Add REGEXP_REPLACE 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: 05/Sep/23 22:17
• Updated: 10/Nov/23 11:34
• Resolved: 30/Oct/23 06:43

Description

Add support for REGEXP_REPLACE function from BigQuery.

REGEXP_REPLACE(value, regexp, replacement)
Returns a STRING where all substrings of value that match regular expression regexp are replaced with replacement.

backslashed-escaped digits (\1 to \9) can be used within the replacement argument to insert text matching the corresponding parenthesized group in the regexp pattern.

Example (added one space between \ \ to override md formatting):

SELECT REGEXP_REPLACE("abc'", "b(.)", "X\ \1") as result;

result

aXc

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)
• is related to: CALCITE-3280 Cannot parse query REGEXP_REPLACE in Redshift
• links to: GitHub Pull Request #3460