Re: [DISCUSS] Support "create [temporary] table" and "create [temporary] view" statements

2020-02-20 Thread Jark Wu
Hi Caizhi, Thanks for raising this. I also think it is a bug in SQL CLI that CREATE VIEW creates a temporary view. We should fix that. If we want to fix it, we have to support create permanent view on TableEnvironment first which is not supported yet. Best, Jark On Fri, 21 Feb 2020 at 11:40,

Re: [DISCUSS] Support "create [temporary] table" and "create [temporary] view" statements

2020-02-20 Thread Jingsong Li
Hi Caizhi, thanks for starting this discussion. There is a FLIP-71 [1] to describe the whole story of view. Sql-cli now implements a wrong way, and a separate way, which should be deprecated and unified to TableEnvironment. > Shall we make it clear and support create table / create temporary

[DISCUSS] Support "create [temporary] table" and "create [temporary] view" statements

2020-02-20 Thread Caizhi Weng
Hi dear Flink developers, I'm quite confused by the "create view" statement in SQL client. >From traditional database we expect that a view behaves just like a table except that it will be computed when used. We also expect that a view should be created under a database just like a table. But