[jira] [Created] (SPARK-39744) Add the REGEXP_INSTR function

["Max Gekk (Jira)" <ji...@apache.org>]

Max Gekk created SPARK-39744:
--------------------------------

             Summary: Add the REGEXP_INSTR function
                 Key: SPARK-39744
                 URL: https://issues.apache.org/jira/browse/SPARK-39744
             Project: Spark
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 3.4.0
            Reporter: Max Gekk
            Assignee: Max Gekk
             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