[
https://issues.apache.org/jira/browse/FLINK-6614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16014120#comment-16014120
]
ASF GitHub Bot commented on FLINK-6614:
---------------------------------------
GitHub user fhueske opened a pull request:
https://github.com/apache/flink/pull/3930
[FLINK-6614] [table] Fix translation of group auxiliary functions (e.g.,
TUMBLE_END).
When translating group auxiliary functions, we only check the root
expressions of a projection but do not dig into `RexCall`s and check if these
functions are used in their operands.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/fhueske/flink tableAuxExpr
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/flink/pull/3930.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 #3930
----
----
> 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)
