[
https://issues.apache.org/jira/browse/FLINK-9740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Timo Walther updated FLINK-9740:
--------------------------------
Description:
Currently, time-based group windows can be defined using intervals of
milliseconds such as {{.window(Tumble over 10.minutes on 'rowtime as 'w)}}. For
some use cases it might useful to define windows of months (esp. in event-time)
that work even with leap years and other special time cases.
The following should be supported in Table API & SQL:
{{.window(Tumble over 1.month on 'rowtime as 'w)}}
{{.window(Tumble over 1.quarter on 'rowtime as 'w)}}
{{.window(Tumble over 1.year on 'rowtime as 'w)}}
was:
Currently, time-based group windows can be defined using intervals of
milliseconds such as {{.window(Tumble over 10.minutes on 'rowtime as 'w)}}. For
some use cases it might useful to define windows of months (esp. in event-time)
that work even with leap years and other special time cases.
The following should be supported in Table API & SQL:
{{.window(Tumble over 1.month on 'rowtime as 'w)}}
> Support group windows over intervals of months
> -----------------------------------------------
>
> Key: FLINK-9740
> URL: https://issues.apache.org/jira/browse/FLINK-9740
> Project: Flink
> Issue Type: New Feature
> Components: Table API & SQL
> Affects Versions: 1.5.0
> Reporter: Timo Walther
> Priority: Major
>
> Currently, time-based group windows can be defined using intervals of
> milliseconds such as {{.window(Tumble over 10.minutes on 'rowtime as 'w)}}.
> For some use cases it might useful to define windows of months (esp. in
> event-time) that work even with leap years and other special time cases.
> The following should be supported in Table API & SQL:
> {{.window(Tumble over 1.month on 'rowtime as 'w)}}
> {{.window(Tumble over 1.quarter on 'rowtime as 'w)}}
> {{.window(Tumble over 1.year on 'rowtime as 'w)}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
