Re: How to contribute to Streaming Table API and StreamSQL

2016-10-13 Thread Fabian Hueske
Hi Juho, Yes, FLINK-4557 is an umbrella issue for windowed aggregations (both for stream and batch) for the Table API (not including SQL). The features are described in FLIP-11 [1]. Note, there is currently a discussion about certain aspects of the proposed syntax [2]. There is a pull request for

Re: How to contribute to Streaming Table API and StreamSQL

2016-10-13 Thread Juho Autio
Hi Fabian! Is this the feature that will also add windowed aggregates to streaming SQL: https://issues.apache.org/jira/browse/FLINK-4557 (Table API Stream Aggregations)? You wrote: > However for the 1.2 release, it we plan to focus on the streaming > Table API and Stream SQL to add support for

Re: How to contribute to Streaming Table API and StreamSQL

2016-06-17 Thread Fabian Hueske
If we want to have it in Stream SQL yes. Although we can also think about extending the Calcite parser ourselves. IMO, it makes sense to talk to them first, also to get more feedback on the feature. 2016-06-17 13:18 GMT+02:00 Jark Wu : > Hi Fabian, > > Yea, we can

Re: How to contribute to Streaming Table API and StreamSQL

2016-06-17 Thread Jark Wu
Hi Fabian, Yea, we can immediately start to work on non-windowed aggregates. But it seems that Calcite’s StreamSQL doesn’t support non-windowed aggregates (also not included in roadmap). So we may need to propose this function back to Calcite community? - Jark Wu > 在

Re: How to contribute to Streaming Table API and StreamSQL

2016-06-17 Thread Fabian Hueske
Hi Jark Wu, I agree about the non-windowed aggregates. If there are actual use cases for this operator, we should definitely support it. Since it does not depend on windows or time, we can immediately start to work on it. In principle, it should be rather easy to implement. However, we have to

Re: How to contribute to Streaming Table API and StreamSQL

2016-06-17 Thread Jark Wu
Hi Fabian, There are a lot of our business are using non-windowed aggregations. And there is a little difference between non-windowed aggregate and Row window operator, as the later is bound to a certain window and emit the result of the N rows preceding for every incoming row. However the

Re: How to contribute to Streaming Table API and StreamSQL

2016-06-16 Thread Fabian Hueske
Hi Jark, thanks for sharing Blink's Streaming Table API. It seems to be close to the DataStream API, while the Table API draft I shared is more similar to Calcite's proposal. You are right, the current draft does not include running (non-windowed) aggregates. We were not sure how useful these are

Re: How to contribute to Streaming Table API and StreamSQL

2016-06-14 Thread Jark Wu
Hi Fabian, It’s great to hear that we are going to start it! I’m glad to share our current Streaming Table API [1]. I find that that all aggregation functions are scoped to the defined window in Flink Stream Table API design [2] and Calcite StreamSQL desgin [3]. I’m thinking that do we need

Re: How to contribute to Streaming Table API and StreamSQL

2016-06-13 Thread Fabian Hueske
Hi Jark, wow, that's good news! You are right, the streaming Table API is currently very limited. In the last month's we changed the internal architecture and put everything on top of Apache Calcite. For the upcoming 1.1 release, we won't add new features to the Table API / SQL. However for the