Contiguity in SQL vs CEP

[Tejas]

There's 3 different types of Contiguity defined in the CEP documentation [1]
looping + non-looping -- Strict, relaxed and non deterministic relaxed.
There's no equivalent in the SQL documentation [2]. Can someone shed some
light on what's achievable in SQL and what isn't ? It seems as if SQL default if I define a pattern such as
(A B+ C) is the strict mode.
Related question : if relaxed mode is possible then when keeping state using
sql are the non-matching events dropped from the state ?


[1]
https://ci.apache.org/projects/flink/flink-docs-stable/dev/libs/cep.html#combining-patterns
<https://ci.apache.org/projects/flink/flink-docs-stable/dev/libs/cep.html#combining-patterns> 
[2]
https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/streaming/match_recognize.html#defining-a-pattern



--
Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/

[Dawid Wysakowicz-2]

Hi,

MATCH_RECOGNIZE clause in SQL standard does not support different
contiguities. The MATCH_RECOGNIZE always uses the strict contiguity.

Best,

Dawid

On 21/04/2021 00:02, tbud wrote:

> There's 3 different types of Contiguity defined in the CEP documentation [1]
> looping + non-looping -- Strict, relaxed and non deterministic relaxed.
> There's no equivalent in the SQL documentation [2]. Can someone shed some
> light on what's achievable in SQL and what isn't ?
> Related question : It seems as if SQL default if I define a pattern such as
> (A B+ C) is the relaxed mode. if this is true then when keeping state using
> sql are the non-matching events dropped from the state ?
>
>
> [1]
> https://ci.apache.org/projects/flink/flink-docs-stable/dev/libs/cep.html#combining-patterns
> <https://ci.apache.org/projects/flink/flink-docs-stable/dev/libs/cep.html#combining-patterns>  
> [2]
> https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/streaming/match_recognize.html#defining-a-pattern
>
>
>
> --
> Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/

[Tejas]

Hi,
In that case what's the difference between reluctant quantifier like (B*?)
in SQL and relaxed contiguity in CEP ?



--
Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/