Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-02-27 Thread godfrey he
t;>> >>>>>>> Sorry, 1.10 not support "CREATE VIEW" in raw SQL too. Workaround is: >>>>>>> - Using TableEnvironment.createTemporaryView... >>>>>>> - Or using "create view" and "drop view" in the sql-client. &g

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-02-27 Thread kant kodali
gt;> >>>>>> FLIP-71 will be finished in 1.11 soon. >>>>>> >>>>>> Best, >>>>>> Jingsong Lee >>>>>> >>>>>> On Sun, Jan 19, 2020 at 4:10 PM kant kodali >>>>>> wrote: &g

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-02-27 Thread kant kodali
will be finished in 1.11 soon. >>>>> >>>>> Best, >>>>> Jingsong Lee >>>>> >>>>> On Sun, Jan 19, 2020 at 4:10 PM kant kodali >>>>> wrote: >>>>> >>>>>> I tried the following. >>&

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-02-26 Thread godfrey he
ableEnv.sqlUpdate("CREATE VIEW my_view AS SELECT * FROM sample1 FULL >>>>> OUTER JOIN sample2 on sample1.f0=sample2.f0"); >>>>> >>>>> Table result = bsTableEnv.sqlQuery("select * from my_view"); >>>>> >>>>

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-02-25 Thread kant kodali
sult = bsTableEnv.sqlQuery("select * from my_view"); >>>> >>>> It looks like >>>> https://cwiki.apache.org/confluence/display/FLINK/FLIP-71+-+E2E+View+support+in+FLINK+SQL >>>> Views >>>> are not supported. Can I expect them to be supporte

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-01-20 Thread Jingsong Li
t;>> It looks like >>> https://cwiki.apache.org/confluence/display/FLINK/FLIP-71+-+E2E+View+support+in+FLINK+SQL >>> Views >>> are not supported. Can I expect them to be supported in Flink 1.10? >>> >>> Currently, with Spark SQL when the query g

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-01-20 Thread Jark Wu
t; > Currently, with Spark SQL when the query gets big I break it down into views > and this is one of the most important features my application relies on. is > there any workaround for this at the moment? > > Thanks! > > On Sat, Jan 18, 2020 at 6:24 PM kant kodali <mailto:kanth...@gmail.com>> wrote: > Hi All, > > Does Flink 1.9 support create or replace views syntax in raw SQL? like spark > streaming does? > > Thanks! > > > -- > Best, Jingsong Lee

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-01-20 Thread kant kodali
1+-+E2E+View+support+in+FLINK+SQL >> Views >> are not supported. Can I expect them to be supported in Flink 1.10? >> >> Currently, with Spark SQL when the query gets big I break it down into >> views and this is one of the most important features my application relies >

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-01-20 Thread Jingsong Li
hen the query gets big I break it down into > views and this is one of the most important features my application relies > on. is there any workaround for this at the moment? > > Thanks! > > On Sat, Jan 18, 2020 at 6:24 PM kant kodali wrote: > >> Hi All, >> >&

Re: Does Flink 1.9 support create or replace views syntax in raw sql?

2020-01-19 Thread kant kodali
the moment? Thanks! On Sat, Jan 18, 2020 at 6:24 PM kant kodali wrote: > Hi All, > > Does Flink 1.9 support create or replace views syntax in raw SQL? like > spark streaming does? > > Thanks! >

Does Flink 1.9 support create or replace views syntax in raw sql?

2020-01-18 Thread kant kodali
Hi All, Does Flink 1.9 support create or replace views syntax in raw SQL? like spark streaming does? Thanks!