[ https://issues.apache.org/jira/browse/FLINK-9740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16712349#comment-16712349 ]
xuqianjin commented on FLINK-9740: ---------------------------------- hi [~twalthr] I have resubmitted this design thanks qianjin > 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 > Assignee: Renjie Liu > Priority: Major > Labels: pull-request-available > Attachments: Discuss [FLINK-9740] Support group windows over > intervals of months.pdf > > > 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)