[
https://issues.apache.org/jira/browse/CALCITE-5858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jerin John updated CALCITE-5858:
--------------------------------
Summary: Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL,
REGEXP_INSTR, REGEXP_REPLACE and REGEXP_SUBSTR functions (enabled in BigQuery
library) (was: Implement BigQuery functions REGEXP_CONTAINS, REGEXP_EXTRACT,
REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE and REGEXP_SUBSTR)
> Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR,
> REGEXP_REPLACE and REGEXP_SUBSTR functions (enabled in BigQuery library)
> -----------------------------------------------------------------------------------------------------------------------------------------------
>
> 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)
