flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rong Rong (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (FLINK-7342) Add support for Regular Expression Operators (RLIKE)
Date Wed, 31 Oct 2018 03:42:00 GMT

    [ https://issues.apache.org/jira/browse/FLINK-7342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16669563#comment-16669563
] 

Rong Rong commented on FLINK-7342:
----------------------------------

Seems like {{SIMILAR TO}} was already supported in Flink, should we close this ticket or is
there any additional features we need to support using LIKE operator?

> Add support for Regular Expression Operators (RLIKE) 
> -----------------------------------------------------
>
>                 Key: FLINK-7342
>                 URL: https://issues.apache.org/jira/browse/FLINK-7342
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table API &amp; SQL
>            Reporter: sunjincheng
>            Assignee: sunjincheng
>            Priority: Major
>
> 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
(v7.6.3#76005)

Mime
View raw message