Jerin John created CALCITE-5858:
-----------------------------------
Summary: Implement BigQuery functions REGEXP_CONTAINS,
REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE and
REGEXP_SUBSTR
Key: CALCITE-5858
URL: https://issues.apache.org/jira/browse/CALCITE-5858
Project: Calcite
Issue Type: New Feature
Reporter: Jerin John
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|https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_contains]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
