[GitHub] [spark] yaooqinn edited a comment on pull request #31488: [SPARK-34376][SQL] Support regexp as a SQL function

[GitBox <gi...@apache.org>]

yaooqinn edited a comment on pull request #31488:
URL: https://github.com/apache/spark/pull/31488#issuecomment-774180250


   > Adding it looks okay.  Any other DBMS supports the func?
   
   I found many others support only the form `subject RLIKE/REGEX pattern` and with a synonym `REGEXP_LIKE(subject, pattern)` used as a function.
   https://dev.mysql.com/doc/refman/8.0/en/regexp.html#operator_regexp
   
   https://docs.snowflake.com/en/sql-reference/functions-regexp.html snowflake also has RLIKE(a, b, c) 😂
   
   https://www.postgresql.org/docs/9.0/functions-string.html in Postgres it is `regexp_matches(string text, pattern text [, flags text])` 😂
   
   For the situation that we have in Spark now, I hope we can get this function in, as we already have `rlike` as SQL regular functions.
   
   And in real-world cases, users may always deploy Spark and Hive together, this small change can remove a big barrier for miraging Hive to Spark SQL, which is very likely to happen all around the world these days. For example, I am going to migrating 20k hive jobs to Spark next month after the Chinese new year festival 😀
   
    
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



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