jiaan.geng created SPARK-33597:
----------------------------------
Summary: Support REGEXP_LIKE for consistent with mainstream
databases
Key: SPARK-33597
URL: https://issues.apache.org/jira/browse/SPARK-33597
Project: Spark
Issue Type: New Feature
Components: SQL
Affects Versions: 3.1.0
Reporter: jiaan.geng
There are a lot of mainstream databases support regex function REGEXP_LIKE.
Currently, Spark supports RLike and we just need add a new alias REGEXP_LIKE
for it.
*Oracle*:https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Pattern-matching-Conditions.html#GUID-D2124F3A-C6E4-4CCA-A40E-2FFCABFD8E19
*Presto*:https://prestodb.io/docs/current/functions/regexp.html
*Vertica*:https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/RegularExpressions/REGEXP_LIKE.htm?tocpath=SQL%20Reference%20Manual%7CSQL%20Functions%7CRegular%20Expression%20Functions%7C_____5
*Snowflake*:https://docs.snowflake.com/en/sql-reference/functions/regexp_like.html
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
