Apache Flink - CEP vs SQL detecting patterns

[M Singh]

Hi:

I am looking at the documentation of the CEP and there is way to access patterns which have timeout.  But I could  not find similar capability in the Table and SQL interface detecting patterns.  I am assuming that the CEP interface is more comprehensive and complete than the SQL/Table interface.

Please let me know if I have missed anything.

Thanks

Mans

[Dawid Wysakowicz-2]

Hi Mans,

Yes you are right. That feature is not available in SQL, as there is no such feature in SQL standard. The only addition to SQL standard we introduce so far is the WITHIN clause. We might introduce the timed out patterns some time in the future, but personally I am not aware of such plans.

Best,

Dawid

On 12/04/2019 22:40, M Singh wrote:

Hi:

I am looking at the documentation of the CEP and there is way to access patterns which have timeout.  But I could  not find similar capability in the Table and SQL interface detecting patterns.  I am assuming that the CEP interface is more comprehensive and complete than the SQL/Table interface.

Please let me know if I have missed anything.

Thanks

Mans

[M Singh]

Dawid:

So, what happens when there is a timeout - is there any value/field in the resulting data stream that indicates that this was a timeout ?

Thanks

On Tuesday, April 16, 2019, 10:12:58 AM EDT, Dawid Wysakowicz <[hidden email]> wrote:

Hi Mans,

Yes you are right. That feature is not available in SQL, as there is no such feature in SQL standard. The only addition to SQL standard we introduce so far is the WITHIN clause. We might introduce the timed out patterns some time in the future, but personally I am not aware of such plans.

Best,

Dawid

On 12/04/2019 22:40, M Singh wrote:

Hi:

I am looking at the documentation of the CEP and there is way to access patterns which have timeout.  But I could  not find similar capability in the Table and SQL interface detecting patterns.  I am assuming that the CEP interface is more comprehensive and complete than the SQL/Table interface.

Please let me know if I have missed anything.

Thanks

Mans

[Dawid Wysakowicz-2]

Hi,

Unfortunately those are just ignored. The timed out partial matches are not emitted.

Best,

Dawid

On 20/04/2019 19:49, M Singh wrote:

Dawid:

So, what happens when there is a timeout - is there any value/field in the resulting data stream that indicates that this was a timeout ?

Thanks

On Tuesday, April 16, 2019, 10:12:58 AM EDT, Dawid Wysakowicz [hidden email] wrote:

Hi Mans,

Yes you are right. That feature is not available in SQL, as there is no such feature in SQL standard. The only addition to SQL standard we introduce so far is the WITHIN clause. We might introduce the timed out patterns some time in the future, but personally I am not aware of such plans.

Best,

Dawid

On 12/04/2019 22:40, M Singh wrote:

Hi:

I am looking at the documentation of the CEP and there is way to access patterns which have timeout.  But I could  not find similar capability in the Table and SQL interface detecting patterns.  I am assuming that the CEP interface is more comprehensive and complete than the SQL/Table interface.

Please let me know if I have missed anything.

Thanks

Mans