[
https://issues.apache.org/jira/browse/FLINK-9740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16708191#comment-16708191
]
ASF GitHub Bot commented on FLINK-9740:
---------------------------------------
XuQianJin-Stars opened a new pull request #7228: [FLINK-9740][Table API &SQL]
Support group windows over intervals of months
URL: https://github.com/apache/flink/pull/7228
## What is the purpose of the change
*(*This PR is designed to solve the problem of Support group windows over
intervals of months.)*
## Brief change log
*(for example:)*
- *Increase in `DataStreamLogicalWindowAggregateRule.scala` processing logic
of the month*
- *Increase in `DataStreamGroupWindowAggregate.scala` processing logic of
the month*
- *Add `isMonthsIntervalLiteral` and `toMonths` functions to
`expressionutils.scala`*
- *Add the `month` function in `time.java`*
## Verifying this change
*(Please pick either of the following options)*
This change is a trivial rework / code cleanup without any test coverage.
*(or)*
This change is already covered by existing tests, such as *(please describe
tests)*.
*(or)*
This change added tests and can be verified as follows:
*(example:)*
- *I added `TestWindowForMonthsInterval` to `SqlITCase`.*
## Does this pull request potentially affect one of the following parts:
- Dependencies (does it add or upgrade a dependency): (yes / no)
- The public API, i.e., is any changed class annotated with
`@Public(Evolving)`: (yes / no)
- The serializers: (yes / no / don't know)
- The runtime per-record code paths (performance sensitive): (yes / no /
don't know)
- Anything that affects deployment or recovery: JobManager (and its
components), Checkpointing, Yarn/Mesos, ZooKeeper: (yes / no / don't know)
- The S3 file system connector: (yes / no / don't know)
## Documentation
- Does this pull request introduce a new feature? (yes / no)
- If yes, how is the feature documented? (not applicable / docs / JavaDocs /
not documented)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> 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)
