Re: Usecase advise for Apache Flink Table API

2023-08-27 Thread Giannis Polyzos
You can also check the apache paimon project https://paimon.apache.org/ (previously known as Flink Table Store). Might help in some scenarios On Mon, Aug 28, 2023 at 5:05 AM liu ron wrote: > Hi, Nirmal > > Flink SQL is standard ANSI SQL and extends upon it. Flink SQL provides > rich Join and Agg

Re: Usecase advise for Apache Flink Table API

2023-08-27 Thread liu ron
Hi, Nirmal Flink SQL is standard ANSI SQL and extends upon it. Flink SQL provides rich Join and Aggregate syntax including Regular Streaming Join, Interval Join, Temporal Join, Lookup Join[2], Window Join[3], unbounded group aggregate[4] and window aggregate[5], and so on. Theoretically, it can su

Usecase advise for Apache Flink Table API

2023-08-27 Thread Nirmal Chhatrala
Hello! We have a use case requirement to implement complex joins and aggregation on multiple sql tables. Today, it is happening at SQLServer level which is degrading the performance of SQLServer Database. Is it a good idea to implement it through Apache Flink Table API for real-time data joins?