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

Support WITHIN clause in MATCH_RECOGNIZE

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.14.0
    • None

    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

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

            Dates

              Created:
              Updated:
              Resolved: