[
https://issues.apache.org/jira/browse/FLINK-6595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16408903#comment-16408903
]
yinhua.dai commented on FLINK-6595:
-----------------------------------
[~fhueske]
So that means I need separate to two sql and convert table for the first sql to
a stream and add the proctime attribute again and then execute the second sql?
> 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)
