[
https://issues.apache.org/jira/browse/FLINK-21803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu updated FLINK-21803:
----------------------------
Component/s: (was: API / Core)
Table SQL / API
> Tumbling / Sliding windows are unaware of daylight savings time
> ---------------------------------------------------------------
>
> Key: FLINK-21803
> URL: https://issues.apache.org/jira/browse/FLINK-21803
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Affects Versions: 1.12.2
> Reporter: Craig Smoothey
> Priority: Major
>
> It is currently possible to specify an "offset" for tumbling / sliding
> windows. The offset is however immutable. This creates a problem for
> aggregations that have to be performed in a timezone which utilises daylight
> savings time for half of the year. For example. If one is aggregating data by
> day in the New York time zone, then for half of the year, the offset is 5
> hours (relative UTC) and for the other half of the year, the offset is 4
> hours (relative UTC). There is no way to construct tumbling / sliding windows
> to specify daylight savings time behaviour. It would be helpful if there was
> a constructor for tumbling / sliding windows to specify the timezone that the
> aggregation must be performed in (default = UTC). The tumbling / sliding
> window would then be required to automatically change the offset depending on
> whether daylight savings time is active or not for the specified time zone.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
