[jira] [Commented] (FLINK-6614) Applying function on window auxiliary function fails

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ 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)