[CALCITE-5858] Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE and REGEXP_SUBSTR functions (enabled in BigQuery library) - ASF JIRA

XML

Word

Printable

JSON

Add support for REGEX_* string functions in BigQuery.

Function descriptions:

REGEXP_CONTAINS: Returns TRUE if input value is a partial match for the regular expression.

REGEXP_EXTRACT: Returns the substring in input value that matches the regular expression. Returns NULL if there is no match.
REGEXP_EXTRACT_ALL: Returns an array of all substrings of input value that match the regular expression. Returns an empty array if there is no match.
REGEXP_INSTR: Returns the lowest 1-based position of a regular expression in an input value.
REGEXP_REPLACE: Returns a STRING where all substrings of input value that match regular expression are replaced with the input replacement.
REGEXP_SUBSTR: Synonym for REGEXP_EXTRACT, returns the substring in input value that matches the regular expression. Returns NULL if there is no match.

More on these functions and their syntax may be found here: BigQuery Doc

is a parent of

CALCITE-5873 Add REGEXP_CONTAINS function (enabled in BigQuery library)

CALCITE-5910 Add REGEXP_EXTRACT and REGEXP_SUBSTR functions (enabled in BigQuery library)

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

CALCITE-5978 Add REGEXP_INSTR function (enabled in BigQuery library)

CALCITE-5979 Add REGEXP_REPLACE function (enabled in BigQuery library)

is related to

CALCITE-3280 Cannot parse query REGEXP_REPLACE in Redshift

(1 is related to)