[ https://issues.apache.org/jira/browse/FLINK-17852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17112588#comment-17112588 ]
sam lin commented on FLINK-17852: --------------------------------- [~f.pompermaier]: Nope, this is for SELECT statement, the issue you pointed is CREATE statement. The name after WITH acts like a variable stores the resulting values of sub-sql. > 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 this: > [https://beam.apache.org/documentation/dsls/sql/calcite/query-syntax/] > query_statement: [ WITH with_query_name AS ( query_expr ) [, ...] ] > query_expr. > In presto, supports this as well: > [https://prestodb.io/docs/current/sql/select.html#with-clause] -- This message was sent by Atlassian Jira (v8.3.4#803005)