[FLINK-13999] Correct the documentation of MATCH_RECOGNIZE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.2, 1.9.1
• Fix Version/s: 1.8.3, 1.9.2, 1.10.0
• Component/s: Documentation
• Labels: pull-request-available
• Assignee: Dian Fu
• Reporter: Dian Fu
• Created: 07/Sep/19 05:40
• Updated: 14/Oct/19 14:39
• Resolved: 14/Oct/19 14:39

Description

Regarding to the following example in the doc:

SELECT *
FROM Ticker
    MATCH_RECOGNIZE (
        PARTITION BY symbol
        ORDER BY rowtime
        MEASURES
            FIRST(A.rowtime) AS start_tstamp,
            LAST(A.rowtime) AS end_tstamp,
            AVG(A.price) AS avgPrice
        ONE ROW PER MATCH
        AFTER MATCH SKIP TO FIRST B
        PATTERN (A+ B)
        DEFINE
            A AS AVG(A.price) < 15
    ) MR;

Given the inputs shown in the doc, it should be:

 symbol       start_tstamp       end_tstamp          avgPrice
=========  ==================  ==================  ============
ACME       01-APR-11 10:00:00  01-APR-11 10:00:03     14.5

instead of:

 symbol       start_tstamp       end_tstamp          avgPrice
=========  ==================  ==================  ============
ACME       01-APR-11 10:00:00  01-APR-11 10:00:03     14.5
ACME       01-APR-11 10:00:04  01-APR-11 10:00:09     13.5

Issue Links

• links to: GitHub Pull Request #9893