flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (FLINK-6584) Support multiple consecutive windows in SQL
Date Tue, 27 Jun 2017 17:45:01 GMT

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

ASF GitHub Bot commented on FLINK-6584:
---------------------------------------

Github user sunjincheng121 commented on a diff in the pull request:

    https://github.com/apache/flink/pull/4199#discussion_r124335785
  
    --- Diff: flink-libraries/flink-table/src/main/scala/org/apache/flink/table/calcite/RelTimeIndicatorConverter.scala
---
    @@ -349,6 +350,14 @@ class RelTimeIndicatorConverter(rexBuilder: RexBuilder) extends RelShuttle
{
                 isTimeIndicatorType(updatedCall.getOperands.get(0).getType) =>
               updatedCall
     
    +        case BasicOperatorTable.TUMBLE_ROWTIME |
    +            BasicOperatorTable.TUMBLE_PROCTIME |
    +            BasicOperatorTable.HOP_ROWTIME |
    +            BasicOperatorTable.HOP_PROCTIME |
    +            BasicOperatorTable.SESSION_ROWTIME |
    +            BasicOperatorTable.SESSION_PROCTIME if isTimeIndicatorType(updatedCall.getType)
=>
    +          updatedCall
    --- End diff --
    
    Can we remove the condition of `if isTimeIndicatorType(updatedCall.getType) `?


> Support multiple consecutive windows in SQL
> -------------------------------------------
>
>                 Key: FLINK-6584
>                 URL: https://issues.apache.org/jira/browse/FLINK-6584
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table API & SQL
>            Reporter: Timo Walther
>            Assignee: Timo Walther
>
> Right now, the Table API supports multiple consecutive windows as follows:
> {code}
> val table = stream.toTable(tEnv, 'rowtime.rowtime, 'int, 'double, 'float, 'bigdec, 'string)
> val t = table
>   .window(Tumble over 2.millis on 'rowtime as 'w)
>   .groupBy('w)
>   .select('w.rowtime as 'rowtime, 'int.count as 'int)
>   .window(Tumble over 4.millis on 'rowtime as 'w2)
>   .groupBy('w2)
>   .select('w2.rowtime, 'w2.end, 'int.count)
> {code}
> Similar behavior should be supported by the SQL API as well. We need to introduce a new
auxiliary group function, but this should happen in sync with Apache Calcite.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message