[
https://issues.apache.org/jira/browse/FLINK-23181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17381832#comment-17381832
]
Jingsong Lee commented on FLINK-23181:
--------------------------------------
{code:java}
SELECT k, window_start, window_end, COUNT(*) FROM
(
SELECT * FROM TABLE(
HOP(
DATA => TABLE Bid,
TIMECOL => DESCRIPTOR(bidtime),
SLIDE => INTERVAL '1' MINUTES,
SIZE => INTERVAL '1' HOURS))
UNION ALL
SELECT * FROM TABLE(
HOP(
DATA => TABLE Bid,
TIMECOL => DESCRIPTOR(bidtime),
SLIDE => INTERVAL '1' MINUTES,
SIZE => INTERVAL '3' HOURS))
) GROUP BY k, window_start, window_end
{code}
> Add support for multi hop window
> ---------------------------------
>
> Key: FLINK-23181
> URL: https://issues.apache.org/jira/browse/FLINK-23181
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / Planner, Table SQL / Runtime
> Reporter: Aitozi
> Priority: Major
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)