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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Shang Yuanchun (Jira)
sunjincheng created FLINK-7342:
----------------------------------

             Summary: Add support for Regular Expression Operators (RLIKE)
                 Key: FLINK-7342
                 URL: https://issues.apache.org/jira/browse/FLINK-7342
             Project: Flink
          Issue Type: Bug
          Components: Table API & SQL
            Reporter: sunjincheng
            Assignee: sunjincheng


Currently Regular Expression Operators (RLIKE)  are not supported. e.g.:
{code}
select * from emps name rlike '^(K|G|W)'
{code}
we'll get Error:

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

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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)