[
https://issues.apache.org/jira/browse/FLINK-6834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16036008#comment-16036008
]
ASF GitHub Bot commented on FLINK-6834:
---------------------------------------
GitHub user wuchong opened a pull request:
https://github.com/apache/flink/pull/4070
[FLINK-6834] [table] Support scalar functions on Over Window
Thanks for contributing to Apache Flink. Before you open your pull request,
please take the following check list into consideration.
If your changes take all of the items into account, feel free to open your
pull request. For more information and/or questions please refer to the [How To
Contribute guide](http://flink.apache.org/how-to-contribute.html).
In addition to going through the list, please provide a meaningful
description of your changes.
- [ ] General
- The pull request references the related JIRA issue ("[FLINK-XXX] Jira
title text")
- The pull request addresses only one issue
- Each commit in the PR has a meaningful commit message (including the
JIRA id)
- [ ] Documentation
- Documentation has been added for new functionality
- Old documentation affected by the pull request has been updated
- JavaDoc for public methods has been added
- [ ] Tests & Build
- Functionality added by the pull request is covered by tests
- `mvn clean verify` has been executed successfully locally or a Travis
build has passed
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/wuchong/flink scalar-function-on-over-window
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/flink/pull/4070.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #4070
----
commit 1d50719632910a4992633551d456182f6b6b4cfd
Author: Jark Wu <[email protected]>
Date: 2017-06-03T15:31:00Z
[FLINK-6834] [table] Support scalar functions on Over Window
----
> 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)
