flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "yinhua.dai (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (FLINK-6595) Nested SQL queries do not expose proctime / rowtime attributes
Date Thu, 22 Mar 2018 01:28:00 GMT

    [ 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 &amp; 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)

Mime
View raw message