[FLINK-7342] Add support for Regular Expression Operators (RLIKE)

• Type: New Feature
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-deprioritized-minor auto-unassigned
• Assignee: Unassigned
• Reporter: sunjincheng
• Created: 02/Aug/17 03:08
• Updated: 01/Jan/22 22:38

Description

Currently Regular Expression Operators (RLIKE) are not supported. e.g.:

select * from emps name rlike '^(K|G|W)' 

we'll get Error:

Error: Error while executing SQL "select * from emps name rlike '^(K|G|W)'": parse failed: Encountered "rlike" at line 1, column 25.

So, after https://issues.apache.org/jira/browse/CALCITE-1918 fixed. I want add RLIKE supported in flink (TableAPI and SQL).

Reference:
MySql: https://dev.mysql.com/doc/refman/5.7/en/regexp.html#operator_regexp