flink1.9.0对DDL的支持

各位大佬：

请教一下， 1.flink1.9.0的table API/sql是不是还没有支持Create view？
       2.BlinkPlanner和flink的planner有什么区别？




[hidden email]

[Wesley Peng-2]

Hi

on 2019/9/5 11:23, [hidden email] 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.

谢谢你的回答，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, [hidden email] 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.