[SPARK-27987] Support POSIX Regular Expressions

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 10/Jun/19 01:04
• Updated: 29/Dec/19 12:06

Description

POSIX regular expressions provide a more powerful means for pattern matching than the LIKE and SIMILAR TO operators. Many Unix tools such as egrep, sed, or awk use a pattern matching language that is similar to the one described here.

Operator	Description	Example
~	Matches regular expression, case sensitive	'thomas' ~ '.thomas.'
~*	Matches regular expression, case insensitive	'thomas' ~* '.Thomas.'
!~	Does not match regular expression, case sensitive	'thomas' !~ '.Thomas.'
!~*	Does not match regular expression, case insensitive	'thomas' !~* '.vadim.'

https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP