[
https://issues.apache.org/jira/browse/FLINK-6584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16217043#comment-16217043
]
ASF GitHub Bot commented on FLINK-6584:
---------------------------------------
Github user fhueske commented on a diff in the pull request:
https://github.com/apache/flink/pull/4199#discussion_r146350727
--- Diff:
flink-libraries/flink-table/src/main/scala/org/apache/flink/table/validate/FunctionCatalog.scala
---
@@ -401,16 +402,84 @@ class BasicOperatorTable extends
ReflectiveSqlOperatorTable {
ScalarSqlFunctions.LOG,
// EXTENSIONS
- SqlStdOperatorTable.TUMBLE,
- SqlStdOperatorTable.TUMBLE_START,
- SqlStdOperatorTable.TUMBLE_END,
- SqlStdOperatorTable.HOP,
- SqlStdOperatorTable.HOP_START,
- SqlStdOperatorTable.HOP_END,
- SqlStdOperatorTable.SESSION,
- SqlStdOperatorTable.SESSION_START,
- SqlStdOperatorTable.SESSION_END
+ BasicOperatorTable.TUMBLE,
+ BasicOperatorTable.HOP,
+ BasicOperatorTable.SESSION,
+ BasicOperatorTable.TUMBLE_START,
+ BasicOperatorTable.TUMBLE_END,
+ BasicOperatorTable.HOP_START,
+ BasicOperatorTable.HOP_END,
+ BasicOperatorTable.SESSION_START,
+ BasicOperatorTable.SESSION_END,
+ BasicOperatorTable.TUMBLE_PROCTIME,
+ BasicOperatorTable.TUMBLE_ROWTIME,
+ BasicOperatorTable.HOP_PROCTIME,
+ BasicOperatorTable.HOP_ROWTIME,
+ BasicOperatorTable.SESSION_PROCTIME,
+ BasicOperatorTable.SESSION_ROWTIME
)
builtInSqlOperators.foreach(register)
}
+
+object BasicOperatorTable {
--- End diff --
SQL documentation needs to be updated to include the window time function
`TUMBLE_ROWTIME` etc.
> 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
> Priority: Blocker
> Fix For: 1.4.0
>
>
> 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)
