Mailing-List: contact dev-help@flink.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@flink.apache.org
Date: Mon, 3 Jul 2017 03:27:00 +0000 (UTC)
From: "Dian Fu (JIRA)" <jira@apache.org>
To: dev@flink.apache.org
Message-ID: <JIRA.13084108.1499052364000.156518.1499052420053@Atlassian.JIRA>
In-Reply-To: <JIRA.13084108.1499052364000@Atlassian.JIRA>
References: <JIRA.13084108.1499052364000@Atlassian.JIRA> <JIRA.13084108.1499052364882@jira-lw-us.apache.org>
Subject: [jira] [Created] (FLINK-7062) Support the basic functionality of
 MATCH_RECOGNIZE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 03 Jul 2017 03:27:06 -0000

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)