You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (Jira)" <ji...@apache.org> on 2022/07/06 11:54:00 UTC

[jira] [Commented] (SPARK-39695) Add the REGEXP_SUBSTR function

    [ https://issues.apache.org/jira/browse/SPARK-39695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17563179#comment-17563179 ] 

Apache Spark commented on SPARK-39695:
--------------------------------------

User 'MaxGekk' has created a pull request for this issue:
https://github.com/apache/spark/pull/37101

> Add the REGEXP_SUBSTR function
> ------------------------------
>
>                 Key: SPARK-39695
>                 URL: https://issues.apache.org/jira/browse/SPARK-39695
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 3.4.0
>            Reporter: Max Gekk
>            Assignee: Max Gekk
>            Priority: Major
>             Fix For: 3.4.0
>
>
> The function should search a string for a regular expression pattern and returns it or NULL of it is not found. See other DBMSs:
> - Oracle: https://docs.oracle.com/cd/B12037_01/server.101/b10759/functions116.htm
> - DB2: https://www.ibm.com/docs/en/db2/11.5?topic=functions-regexp-substr
> - Snowflake: https://docs.snowflake.com/en/sql-reference/functions/regexp_substr.html
> - BigQuery: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_substr
> - Redshift: https://docs.aws.amazon.com/redshift/latest/dg/REGEXP_SUBSTR.html
> - MariaDB: https://mariadb.com/kb/en/regexp_substr/
> - Exasol DB: https://docs.exasol.com/db/latest/sql_references/functions/alphabeticallistfunctions/regexp_substr.htm
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org