[
https://issues.apache.org/jira/browse/FLINK-13731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907815#comment-16907815
]
Jark Wu edited comment on FLINK-13731 at 8/15/19 4:29 AM:
----------------------------------------------------------
Hi [~zhaoshijie], for a workaround, you can convert the timestamp to a unix
timestamp (by +/- offset according to your local time zone).
was (Author: jark):
Hi [~zhaoshijie], for a workaround, you can convert the timestamp to a unix
timestamp (by +/- offset according your local time zone).
> 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)
