(DEPRECATED) Apache Flink User Mailing List archive.

RE: FlinkCEP and SQL?

Posted by Esa Heikkinen (TAU) on
URL: http://deprecated-apache-flink-user-mailing-list-archive.369.s1.nabble.com/FlinkCEP-and-SQL-tp27066p27209.html

Is there any good scientific papers about using SQL MATCH_RECOGNIZE in Flink and CEP ?

The only one good paper about Flink and CEP that I have received was “Efficient Pattern Matching over Event Streams” (SIGMOD 2008). Its SASE+ Event Pattern Language (EPL) is best I have met. I have been told that FlinkCEP is based on this.

BR Esa

From: Fabian Hueske <[hidden email]>
Sent: Thursday, April 11, 2019 11:33 AM
To: Esa Heikkinen (TAU) <[hidden email]>
Cc: Dian Fu <[hidden email]>; jincheng sun <[hidden email]>; [hidden email]
Subject: Re: FlinkCEP and SQL?

Hi Esa,

Flink's implementation of SQL MATCH_RECOGNIZE is based on it's CEP library, i.e., they share the same implementation.

Best, Fabian

Am Do., 11. Apr. 2019 um 10:29 Uhr schrieb Esa Heikkinen (TAU) <[hidden email]>:

Hi

Is SQL CEP based (old) FlinkCEP at all and are SQL CEP and FlinkCEP completely separate ?

BR Esa

From: Dian Fu <[hidden email]>
Sent: Thursday, April 4, 2019 2:37 PM
To: Esa Heikkinen (TAU) <[hidden email]>
Cc: jincheng sun <[hidden email]>; [hidden email]
Subject: Re: FlinkCEP and SQL?

Should the all sources be combined into one big table before operations with SQL CEP?

Yes, you should combine them into one table/stream.

Regards,

Dian

在 2019年4月4日，下午7:11，Esa Heikkinen (TAU) <[hidden email]> 写道：

Hi

Thank you for the information. How this SQL CEP is applicable for situation where there are many sources with different type of events ? Should the all sources be combined into one big table before operations with SQL CEP?

BR Esa

From: jincheng sun <[hidden email]>
Sent: Thursday, April 4, 2019 1:05 PM
To: Esa Heikkinen (TAU) <[hidden email]>
Cc: [hidden email]
Subject: Re: FlinkCEP and SQL?

Hi BR Esa,

CEP is available in Flink SQL, Please the detail here: https://ci.apache.org/projects/flink/flink-docs-release-1.7/dev/table/sql.html#pattern-recognition

Best,

Jincheng

Esa Heikkinen (TAU) <[hidden email]> 于2019年4月4日周四下午4:44写道：

Hi

What is the situation of FlinkCEP and SQL?

Is it already possible to use SQL in CEP?

Is there any example cases where SQL is used in CEP?

BR Esa