[ https://issues.apache.org/jira/browse/FLINK-9740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16712219#comment-16712219 ]
xuqianjin commented on FLINK-9740: ---------------------------------- hi [~twalthr] I'm sorry that I found some details need to be considered when I looked at them last night, so I deleted the uploaded attachment. I plan to resubmit a design today 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 > > 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)