Status

Current state: "Accepted"

Discussion thread: http://apache-flink-mailing-list-archive.1008284.n3.nabble.com/DISCUSS-Integrating-Flink-Table-API-amp-SQL-with-CEP-td17964.html

...

...

Please keep the discussion on the mailing list rather than commenting on the wiki (wiki discussions get unwieldy fast).

...

The feature will support Row Pattern Recognition syntax in SQL.  In December 2016, ISO released a new version of the international SQL standard (ISO/IEC 9075:2016) including the Row Pattern Recognition for complex event processing. Oracle's SQL has supported this feature in 12cR1. With this extension it is possible to detect complex patterns between rows in a table. In the context of CEP each row can be considered as an event and the events are ordered according to the insertion order. The following shows an example query.

...

Required features in Flink-CEP

...

1. Support .times(from, to) on Pattern
2. Support branching CEP patterns. FLINK-4641
3. Support permutation on Pattern
4. Support .prune(long pruningTimestamp) on NFA
5. IterativeCondition support open() method to compile generated code and not de/serialized with NFA state.
6. Support pattern grouping in Flink CEP

...