[
https://issues.apache.org/jira/browse/FLINK-7062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119728#comment-16119728
]
ASF GitHub Bot commented on FLINK-7062:
---------------------------------------
GitHub user dianfu opened a pull request:
https://github.com/apache/flink/pull/4502
[FLINK-7062] [table, cep] Support the basic functionality of MATCH_RECOGNIZE
## What is the purpose of the change
*This pull request adds the basic support of MATCH_RECOGNIZE.*
## Brief change log
*(for example:)*
- *The MATCH_RECOGNIZE clause is transformed to CEP job with the existing
CEP API*
## Verifying this change
This change added tests and can be verified as follows:
- *Added test that validates MATCH_RECOGNIZE is parsed correctly and
expected results are got*
## Does this pull request potentially affect one of the following parts:
- Dependencies (does it add or upgrade a dependency): (no)
- The public API, i.e., is any changed class annotated with
`@Public(Evolving)`: (no)
- The serializers: (no)
- The runtime per-record code paths (performance sensitive): (no)
- Anything that affects deployment or recovery: JobManager (and its
components), Checkpointing, Yarn/Mesos, ZooKeeper: (no)
## Documentation
- Does this pull request introduce a new feature? (yes)
- If yes, how is the feature documented? (JavaDocs)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/dianfu/flink FLINK-7062
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/flink/pull/4502.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #4502
----
commit 34f7704f72cdb9cf0e3808e779b35d72eadb3e7f
Author: Dian Fu <fudian...@alibaba-inc.com>
Date: 2017-08-08T11:10:24Z
[FLINK-7062] [table, cep] Support the basic functionality of MATCH_RECOGNIZE
----
> 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)
