Re: Flink SQL OVER window

2021-01-29 Thread Patrick Angeles
Thanks, Seth. That did the trick! On Fri, Jan 29, 2021 at 10:51 AM Seth Wiesman wrote: > You need to use TUMBLE_ROWTIME to extract a time attribute from a window, > TUMBLE_END is just a timestamp. > > > https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/queries.html#selecting-g

Re: Flink SQL OVER window

2021-01-29 Thread Seth Wiesman
You need to use TUMBLE_ROWTIME to extract a time attribute from a window, TUMBLE_END is just a timestamp. https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/queries.html#selecting-group-window-start-and-end-timestamps Seth On Fri, Jan 29, 2021 at 9:14 AM Patrick Angeles wrote:

Re: Flink SQL OVER window

2021-01-29 Thread Patrick Angeles
Forgot to mention, I am using Flink 1.12. On Fri, Jan 29, 2021 at 10:11 AM Patrick Angeles wrote: > Fairly new to Flink here so this might be a newbie mistake, but here's the > problem. I created the following table and view: > > >> CREATE TABLE test ( >> >> event_time TIMESTAMP(3), >> >