You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Jingsong Lee (Jira)" <ji...@apache.org> on 2021/07/16 06:54:00 UTC
[jira] [Comment Edited] (FLINK-23181) Add support for multi hop
window
[ 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)