1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
$data = [
<|dt:1688910000, event:"A"|>,
<|dt:1688910100, event:"B"|>,
<|dt:1688910200, event:"C"|>,
<|dt:1688910300, event:"A"|>,
<|dt:1688910400, event:"C"|>,
<|dt:1688910500, event:"D"|>,
<|dt:1688910500, event:"C"|>,
<|dt:1688910600, event:"B"|>,
<|dt:1688910800, event:"A"|>,
<|dt:1688910900, event:"C"|>,
<|dt:1688911000, event:"B"|>,
];
pragma FeatureR010="prototype";
SELECT *
FROM AS_TABLE($data) MATCH_RECOGNIZE(
ORDER BY CAST(dt as Timestamp)
MEASURES
FIRST(A.dt) as a,
FIRST(B.dt) as b,
FIRST(C.dt) as c
ONE ROW PER MATCH
AFTER MATCH SKIP TO NEXT ROW
PATTERN (
PERMUTE(A, B, C)
)
DEFINE
A as A.event = "A",
B as B.event = "B",
C as C.event = "C"
) AS MATCHED
;
|
