[
https://issues.apache.org/jira/browse/FLINK-6595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16408089#comment-16408089
]
Fabian Hueske commented on FLINK-6595:
--------------------------------------
[~yinhua], the inner query does not forward a proctime attribute.
{code}
SELECT *
FROM
(SELECT id, TUMBLE_END(proctime, interval '1' DAY), TUMBLE_PROCTIME(proctime,
interval '1' DAY) as proctime
FROM t
GROUP BY id, TUMBLE(proctime, interval '1' DAY))
GROUP BY TUMBLE(proctime, interval '10' DAY)
{code}
> 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)
