You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Flavio Pompermaier (Jira)" <ji...@apache.org> on 2020/05/20 19:41:00 UTC
[jira] [Commented] (FLINK-17852) FlinkSQL support WITH clause in
query statement
[ https://issues.apache.org/jira/browse/FLINK-17852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17112558#comment-17112558 ]
Flavio Pompermaier commented on FLINK-17852:
--------------------------------------------
Can this be related to FLINK-17361 ?
> FlinkSQL support WITH clause in query statement
> -----------------------------------------------
>
> Key: FLINK-17852
> URL: https://issues.apache.org/jira/browse/FLINK-17852
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Reporter: sam lin
> Priority: Major
>
> Many modern SQL language support WITH clause in query statement. e.g.
> ```
> WITH myName AS (
> select * from table where ...
> )
> select column1 from myName
> ```
> e.g. In BeamSQL supports
> `{{query_statement:
> [ WITH with_query_name AS ( query_expr ) [, ...] ]
> query_expr`. }}[https://beam.apache.org/documentation/dsls/sql/calcite/query-syntax/]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)