You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Suhan Mao (Jira)" <ji...@apache.org> on 2020/12/17 04:19:00 UTC

[jira] [Comment Edited] (FLINK-19612) Support CUMULATE window table function in planner

    [ https://issues.apache.org/jira/browse/FLINK-19612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250797#comment-17250797 ] 

Suhan Mao edited comment on FLINK-19612 at 12/17/20, 4:18 AM:
--------------------------------------------------------------

[~jark]  Hi, I'm interested in how we implement this.

Do you plan to set CUMULATE a new keyword in SQL syntax or some reserved enum window name in planner?

In our company, we have a lot of customized window count/sum logic and window fire/purge management. Sometimes it may be complicated that official window function cannot satisfy our requirement in SQL. Then we have to write DataStream API to handle this. 

Is there a way that we can develop customized window table function as a new type of UDF basing on this feature?

Is there a way we can implement it in a more generic way especially for SQL?

 


was (Author: maosuhan):
[~jark]  Hi, I'm interested in how we implement this.

Do you plan to set CUMULATE a new keyword in SQL syntax or some reserved enum window name in planner?

In our company, we have a lot of customized window count/sum logic and window fire/purge management. Sometimes it may be complicated that official window function cannot satisfy our requirement in SQL. Then we have to write DataStream API to handle this. 

Is there a way that we can develop customized window table function basing on this feature?

Is there a way we can implement it in a more generic way especially for SQL?

 

> Support CUMULATE window table function in planner
> -------------------------------------------------
>
>                 Key: FLINK-19612
>                 URL: https://issues.apache.org/jira/browse/FLINK-19612
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API
>            Reporter: Jark Wu
>            Assignee: Jark Wu
>            Priority: Major
>             Fix For: 1.13.0
>
>
> Introduce the CUMULATE customized window table function in planner. And support cumulative windows in window aggregate, etc.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)