flink-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From LiYue <liyue2...@gmail.com>
Subject Timezone offset on daily time window grouping using SQL
Date Mon, 19 Mar 2018 03:45:54 GMT
Hello team,
	In DataStream API , a time offset can be specified like this:

input
.keyBy(<key selector>)
.window(TumblingEventTimeWindows.of(Time.days(1), Time.hours(-8)))

Is their any way to specify a time offset on SQL?
My sql looks like:

SELECT * from table
GROUP BY TUMBLE(`timestamp`,INTERVAL '1’ DAY)

Thanks !
LiYue
tig.jd.com
Mime
View raw message