How to use two continuously window with EventTime in sql

[liujiangang]

      For one sql window, I can register table with event time and use time field in the tumble window. But if I want to use the result for the first window and use another window to process it, how can I do it? Thank you.

[Jark Wu-3]

Hi,

You can use TUMBLE_ROWTIME(...) to get the rowtime attribute of the first window result, and use this field to apply a following window aggregate.

See more https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql.html#group-windows

Best,

Jark

On Tue, 29 Oct 2019 at 15:39, 刘建刚 <[hidden email]> wrote:

      For one sql window, I can register table with event time and use time field in the tumble window. But if I want to use the result for the first window and use another window to process it, how can I do it? Thank you.