Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1911

Support WITHIN clause in MATCH_RECOGNIZE

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.14.0
    • Component/s: None
    • Labels:

      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
      

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              dian.fu Dian Fu
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: