Re: Re: flink1.9.0对DDL的支持

2019-09-05 文章 pengcheng...@bonc.com.cn
谢谢你的回答,Wesley Peng.只能在CLI里Create view 还是太不灵活了,期待1.10.


 
发件人: Wesley Peng
发送时间: 2019-09-05 11:52
收件人: user-zh
主题: Re: flink1.9.0对DDL的支持
Hi
 
on 2019/9/5 11:23, pengcheng...@bonc.com.cn wrote:
> 请教一下, 1.flink1.9.0的table API/sql是不是还没有支持Create view?
 
from the official documentation of flink 1.9:
 
Views can also be created within a CLI session using the CREATE VIEW 
statement:
 
CREATE VIEW MyNewView AS SELECT MyField2 FROM MyTableSource;
 
Views created within a CLI session can also be removed again using the 
DROP VIEW statement:
 
DROP VIEW MyNewView;
 
Attention The definition of views in the CLI is limited to the mentioned 
syntax above. Defining a schema for views or escaping whitespaces in 
table names will be supported in future versions.
 
So create view is supported but has the limits.
 
regards.


Re: flink1.9.0对DDL的支持

2019-09-04 文章 Wesley Peng

Hi

on 2019/9/5 11:23, pengcheng...@bonc.com.cn wrote:

请教一下, 1.flink1.9.0的table API/sql是不是还没有支持Create view?


from the official documentation of flink 1.9:

Views can also be created within a CLI session using the CREATE VIEW 
statement:


CREATE VIEW MyNewView AS SELECT MyField2 FROM MyTableSource;

Views created within a CLI session can also be removed again using the 
DROP VIEW statement:


DROP VIEW MyNewView;

Attention The definition of views in the CLI is limited to the mentioned 
syntax above. Defining a schema for views or escaping whitespaces in 
table names will be supported in future versions.


So create view is supported but has the limits.

regards.