ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrei Aleksandrov <aealexsand...@gmail.com>
Subject Re: Common table expressions preserved as view.
Date Thu, 05 Sep 2019 14:42:02 GMT
Hi,

At the moment SQL views and temporary tables (CTE) don't fully supported 
in Ignite. The CTE syntax will just set the sub-query inside your SQL 
request.

BR,
Andrei

9/5/2019 4:36 PM, kresimir.horvat пишет:
> Hi, I noticed that some common table expressions defined in queries are left
> preserved as views. The first time I noticed this is when I managed to run
> query when CTE name was changed. Seems that in some cases they are kept and
> can be referenced from different sessions (I can see them when I run select
> from INFORMATION_SCHEMA.VIEWS).
> This rises a bit of concern if other users can get data from another user if
> queries are run in parallel, ie. they will both read from view.
>
> In few latest test seems that CTEs preserved as view are all created when
> query is run over rest.
> Can someone, please, give me some explanation how its handled in Ignite?
>
> Thanks in advance!
> Kresimir
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Mime
View raw message