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.

回复