You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by piyush <co...@gmail.com> on 2018/08/23 12:34:46 UTC
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
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <co...@gmail.com>:
> 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
Posted by piyush <co...@gmail.com>.
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
Posted by piyush <co...@gmail.com>.
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/
Re: CTE and Recursive CTE support in SQL
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <co...@gmail.com>:
> 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/
>