Dylan He created FLINK-35963:
--------------------------------
Summary: Add REGEXP_SUBSTR function
Key: FLINK-35963
URL: https://issues.apache.org/jira/browse/FLINK-35963
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Reporter: Dylan He
Add REGEXP_SUBSTR function.
----
Returns the first substring in {{str}} that matches {{regex}}.
Example:
{code:sql}
> SELECT REGEXP_SUBSTR('Steven Jones and Stephen Smith are the best players',
> 'Ste(v|ph)en');
Steven
> SELECT REGEXP_SUBSTR('Mary had a little lamb', 'Ste(v|ph)en');
NULL
{code}
Syntax:
{code:sql}
REGEXP_SUBSTR(str, regex)
{code}
Arguments:
* {{str}}: A STRING expression to be matched.
* {{regex}}: A STRING expression with a pattern.
Returns:
A STRING.
In case of a malformed {{regex}} the function returns an error.
If either argument is NULL or the pattern is not found, the result is NULL.
See also:
*
[Spark|https://spark.apache.org/docs/3.5.1/sql-ref-functions-builtin.html#string-functions]
*
[Databricks|https://docs.databricks.com/en/sql/language-manual/functions/regexp_substr.html]
*
[MySQL|https://dev.mysql.com/doc/refman/8.4/en/regexp.html#function_regexp-substr]
*
[PostgreSQL|https://www.postgresql.org/docs/16/functions-matching.html#FUNCTIONS-POSIX-REGEXP]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
