[jira] [Commented] (FLINK-6595) Nested SQL queries do not expose proctime / rowtime attributes

["yinhua.dai (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-6595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16408049#comment-16408049 ] 

yinhua.dai commented on FLINK-6595:
-----------------------------------

I am having a similar issue in Flink 1.4

 

SELECT * FROM

(SELECT id, TUMBLE_END(proctime, interval '1' DAY) FROM t GROUP BY id, TUMBLE(proctime, interval '1' DAY))

GROUP BY TUMBLE(proctime, interval '10' DAY)

 

will compile 'proctime' undefined.

> Nested SQL queries do not expose proctime / rowtime attributes
> --------------------------------------------------------------
>
>                 Key: FLINK-6595
>                 URL: https://issues.apache.org/jira/browse/FLINK-6595
>             Project: Flink
>          Issue Type: Bug
>          Components: Table API & SQL
>            Reporter: Haohui Mai
>            Assignee: Haohui Mai
>            Priority: Major
>             Fix For: 1.3.0
>
>
> We found out that the group windows cannot be applied with nested queries out-of-the-box:
> {noformat}
> SELECT * FROM (
>   (SELECT ...)
> UNION ALL)
>   (SELECT ...)
> ) GROUP BY foo, TUMBLE(proctime, ...)
> {noformat}
> Flink complains about {{proctime}} is undefined.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)