Re: Nested TUMBLE/HOP/SESSION windows

2017-05-18 Thread Julian Hyde
By the way, a principle I would follow when composing windows is that all that comes out of a query is simply data values. I don’t think this is controversial. But I don’t want anyone to suggest that we pass fuzzy concepts like “window instances” from sub-query to enclosing query. Julian >

Re: Nested TUMBLE/HOP/SESSION windows

2017-05-18 Thread Julian Hyde
Have you considered using TUMBLE_START? This is an inclusive bound, so you should be able to compose windows. It’s possible that TUMBLE_START isn’t returning the right value yet, e.g. see

Nested TUMBLE/HOP/SESSION windows

2017-05-17 Thread Timo Walther
Hi everyone, we are very happy to support TUMBLE/HOP/SESSION in our upcoming Flink 1.3 release. However, there are some problems regarding nested window queries that we would like to discuss with the Calcite community. Take the following query: SELECT rowtime, SUM(x) FROM ( SELECT