You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "sunjincheng (JIRA)" <ji...@apache.org> on 2017/08/02 03:09:00 UTC

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

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)