[CALCITE-1911] Support WITHIN clause in MATCH_RECOGNIZE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Labels: match
• Assignee: Julian Hyde
• Reporter: Dian Fu
• Created: 31/Jul/17 05:25
• Updated: 02/Oct/17 14:31
• Resolved: 25/Aug/17 01:58

Description

Window is an important feature for pattern detection, it defines the time duration for the events to match a pattern. Here is an example from doc:

SELECT T.Ac2, T.Bc2, T.Cc2 
    FROM S
    MATCH_RECOGNIZE(
        MEASURES A.c2 as Ac2, B.c2 as Bc2, C.c2 as Cc2
        PATTERN (A (B+ | C)) within 3000 milliseconds 
        DEFINE 
            A as A.c1=10 or A.c1=25, 
            B as B.c1=20 or B.c1=15 or B.c1=25, 
            C as C.c1=15
    ) as T