[ https://issues.apache.org/jira/browse/FLINK-7062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16121283#comment-16121283 ]
ASF GitHub Bot commented on FLINK-7062: --------------------------------------- Github user dianfu commented on the issue: https://github.com/apache/flink/pull/4502 @kl0u @dawidwys @wuchong It will be great if you could take a look at this PR. This PR add the basic support for cep on sql. Thanks in advance. :) > Support the basic functionality of MATCH_RECOGNIZE > -------------------------------------------------- > > Key: FLINK-7062 > URL: https://issues.apache.org/jira/browse/FLINK-7062 > Project: Flink > Issue Type: Sub-task > Components: CEP, Table API & SQL > Reporter: Dian Fu > Assignee: Dian Fu > > In this JIRA, we will support the basic functionality of {{MATCH_RECOGNIZE}} > in Flink SQL API which includes the support of syntax {{MEASURES}}, > {{PATTERN}} and {{DEFINE}}. This would allow users write basic cep use cases > with SQL like the following example: > {code} > SELECT T.aid, T.bid, T.cid > FROM MyTable > MATCH_RECOGNIZE ( > MEASURES > A.id AS aid, > B.id AS bid, > C.id AS cid > PATTERN (A B C) > DEFINE > A AS A.name = 'a', > B AS B.name = 'b', > C AS C.name = 'c' > ) AS T > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)