[jira] [Created] (FLINK-7062) Support the basic functionality of MATCH_RECOGNIZE

["Dian Fu (JIRA)" <ji...@apache.org>]

Dian Fu created FLINK-7062:
------------------------------

             Summary: Support the basic functionality of MATCH_RECOGNIZE
                 Key: FLINK-7062
                 URL: https://issues.apache.org/jira/browse/FLINK-7062
             Project: Flink
          Issue Type: 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)