Re: CTE and Recursive CTE support in SQL
Hello! Try it and see. With regards of Recursive CTE, I think the development priority is MVCC for now. As for H2 features, there might be further limitations on them in Apache Ignite. Regards, -- Ilya Kasnacheev 2018-08-24 10:34 GMT+03:00 piyush : > H2 has limited support for Recursive CTE. > > http://h2database.com/html/advanced.html#recursive_queries > > Does Ignite supports all SQL features which H2 has ? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: CTE and Recursive CTE support in SQL
H2 has limited support for Recursive CTE. http://h2database.com/html/advanced.html#recursive_queries Does Ignite supports all SQL features which H2 has ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: CTE and Recursive CTE support in SQL
When is Recursive CTE planned ? Recursive CTE is super powerful. https://www.postgresql.org/docs/current/static/queries-with.html https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-2017 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
CTE and Recursive CTE support in SQL
When Common Table Expression (CTE) and Recursive CTE are planned to be part of supported SQL syntax ? It would be super productive to have Support for CTE as we can do Graph like Traversals and many complex queries. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: CTE and Recursive CTE support in SQL
Hello! Apache Ignite already has CTE support (but not Recursive CTE). I think that we have inherited it from H2. Regards, -- Ilya Kasnacheev 2018-08-23 15:34 GMT+03:00 piyush : > When Common Table Expression (CTE) and Recursive CTE are planned to be part > of supported SQL syntax ? > > It would be super productive to have Support for CTE as we can do Graph > like > Traversals and many complex queries. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >