[
https://issues.apache.org/jira/browse/CALCITE-5858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jerin John reassigned CALCITE-5858:
-----------------------------------
Assignee: Jerin John
> 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
> Assignee: Jerin John
> Priority: Major
>
> 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)
