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/
