[
https://issues.apache.org/jira/browse/FLINK-6614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015550#comment-16015550
]
ASF GitHub Bot commented on FLINK-6614:
---------------------------------------
Github user sunjincheng121 commented on a diff in the pull request:
https://github.com/apache/flink/pull/3930#discussion_r117205976
--- Diff:
flink-libraries/flink-table/src/test/scala/org/apache/flink/table/api/scala/stream/sql/WindowAggregateTest.scala
---
@@ -150,6 +150,35 @@ class WindowAggregateTest extends TableTestBase {
streamUtil.verifySql(sql, expected)
}
+ @Test
+ def testExpressionOnWindowAuxFunction() = {
+ streamUtil.tEnv.registerFunction("weightedAvg", new
WeightedAvgWithMerge)
--- End diff --
We can remove this line or using the `weightedAvg` in sql.
> Applying function on window auxiliary function fails
> ----------------------------------------------------
>
> Key: FLINK-6614
> URL: https://issues.apache.org/jira/browse/FLINK-6614
> Project: Flink
> Issue Type: Bug
> Components: Table API & SQL
> Affects Versions: 1.3.0, 1.4.0
> Reporter: Fabian Hueske
> Assignee: Fabian Hueske
>
> SQL queries that apply a function or expression on a window auxiliary
> function ({{TUMBLE_START}}, {{TUMBLE_END}}, {{HOP_START}}, etc). cannot be
> translated and fail with a {{CodeGenException}}:
>
> {code}
> Exception in thread "main" org.apache.flink.table.codegen.CodeGenException:
> Unsupported call: TUMBLE_END
> {code}
> Example query:
> {code}
> SELECT
> a,
> toLong(TUMBLE_END(rowtime, INTERVAL '10' MINUTE)) AS t,
> COUNT(b) AS cntB
> FROM myTable
> GROUP BY a, TUMBLE(rowtime, INTERVAL '10' MINUTE)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
