[SPARK-39744] Add the REGEXP_INSTR function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 11/Jul/22 13:55
• Updated: 12/Jul/22 16:20
• Resolved: 12/Jul/22 16:20

Description

The function should return the position of the specified occurrence of the regular expression pattern in the input string. If no match is found, returns 0. See other DBMSs:

• MariaDB: https://mariadb.com/kb/en/regexp_instr/
• Oracle: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions129.htm
• DB2: https://www.ibm.com/docs/en/db2/11.5?topic=functions-regexp-instr
• Snowflake: https://docs.snowflake.com/en/sql-reference/functions/regexp_instr.html
• BigQuery: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_instr
• Redshift: https://docs.aws.amazon.com/redshift/latest/dg/REGEXP_INSTR.html
• Exasol DB: https://docs.exasol.com/db/latest/sql_references/functions/alphabeticallistfunctions/regexp_instr.htm
• Vertica: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/RegularExpressions/REGEXP_INSTR.htm
   

Issue Links

• is a clone of: SPARK-39695 Add the REGEXP_SUBSTR function
• links to: [Github] Pull Request #37154 (MaxGekk)