Jark Wu created FLINK-6834: ------------------------------ Summary: Over window doesn't support complex calculation Key: FLINK-6834 URL: https://issues.apache.org/jira/browse/FLINK-6834 Project: Flink Issue Type: Bug Components: Table API & SQL Reporter: Jark Wu Assignee: Jark Wu Fix For: 1.4.0
The following example {code} val windowedTable = table .window( Over partitionBy 'c orderBy 'rowtime preceding UNBOUNDED_ROW as 'w) .select('c, 'b, ('a.count over 'w) + 1) {code} will throw exception: {code} org.apache.flink.table.api.ValidationException: Expression UnresolvedOverCall(count('a),'w) failed on input check: Over window with alias $alias could not be resolved. at org.apache.flink.table.plan.logical.LogicalNode.failValidation(LogicalNode.scala:143) at org.apache.flink.table.plan.logical.LogicalNode$$anonfun$validate$1.applyOrElse(LogicalNode.scala:89) at org.apache.flink.table.plan.logical.LogicalNode$$anonfun$validate$1.applyOrElse(LogicalNode.scala:83) at org.apache.flink.table.plan.TreeNode.postOrderTransform(TreeNode.scala:72) at org.apache.flink.table.plan.TreeNode$$anonfun$1.apply(TreeNode.scala:46) {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)