You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Dian Fu (JIRA)" <ji...@apache.org> on 2017/07/31 05:26:00 UTC
[jira] [Created] (CALCITE-1911) Support within clause in
MATCH_RECOGNIZE
Dian Fu created CALCITE-1911:
--------------------------------
Summary: Support within clause in MATCH_RECOGNIZE
Key: CALCITE-1911
URL: https://issues.apache.org/jira/browse/CALCITE-1911
Project: Calcite
Issue Type: Bug
Reporter: Dian Fu
Assignee: Julian Hyde
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|https://docs.oracle.com/middleware/1213/eventprocessing/cql-reference/GUID-34D4968E-C55A-4BC7-B1CE-C84B202217BD.htm#CQLLR2119]:
{code}
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
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)