twalthr commented on a change in pull request #7070: [FLINK-10625] Documentation for MATCH_RECOGNIZE clause URL: https://github.com/apache/flink/pull/7070#discussion_r232595474
########## File path: docs/dev/table/sql.md ########## @@ -756,6 +796,51 @@ Group windows are defined in the `GROUP BY` clause of a SQL query. Just like que </tbody> </table> +### Match_recognize + +<div markdown="1"> +<table class="table table-bordered"> + <thead> + <tr> + <th class="text-left" style="width: 20%">Operation</th> + <th class="text-center">Description</th> + </tr> + </thead> + <tbody> + <tr> + <td> + <strong>MATCH_RECOGNIZE</strong><br> + <span class="label label-primary">Streaming</span> + </td> + <td> + <p>Search for given event pattern in an incoming stream. For more though description see <a href="streaming/match_recognize.html">Detecting event patterns</a></p> + +{% highlight sql %} +SELECT T.aid, T.bid, T.cid +FROM MyTable +MATCH_RECOGNIZE ( + ORDER BY proctime + MEASURES + A.id AS aid, + B.id AS bid, + C.id AS cid + PATTERN (A B C) + DEFINE + A AS name = 'a', + B AS name = 'b', + C AS name = 'c' +) AS T +{% endhighlight %} + </td> + </tr> + + </tbody> +</table> +</div> + +{% top %} + Review comment: nit: tripple empty line ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services