[
https://issues.apache.org/jira/browse/FLINK-13731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16910177#comment-16910177
]
Jark Wu commented on FLINK-13731:
---------------------------------
Hi, I think proctime attribute should return a timestamp with local time zone,
so the TUMBLE(pt, interval '1' DAY) can align with the session time zone.
In the other hand, I'm also fine with supporting TUMBLE(dateTime, interval,
time), as this is supported in Calcite and useful when we want the window start
time is from "00:20".
> flink sql support window with alignment
> ---------------------------------------
>
> Key: FLINK-13731
> URL: https://issues.apache.org/jira/browse/FLINK-13731
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Affects Versions: 1.9.0
> Reporter: zzsmdfj
> Priority: Major
>
> for now, sql:
> {code:java}
> // code placeholder
> SELECT COUNT(*) GROUP BY TUMBLE(pt, interval '1' DAY, time '08:00:00')
> {code}
> not supported in flink sql, when rowtime is processTime, the window is
> assigned by UTC time, it is not correct day window when i was in specified
> time zone.
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
