[
https://issues.apache.org/jira/browse/FLINK-23181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17381832#comment-17381832
]
Jingsong Lee edited comment on FLINK-23181 at 7/16/21, 6:53 AM:
----------------------------------------------------------------
{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}
And then planner can generate a MultiWindowAggregate operator to optimize this
pattern.
[~aitozi] What do you think?
was (Author: lzljs3620320):
{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)
