Re: An issue of Ignite In-Menory Sql Grid since version 2.0.0

2017-09-28 Thread Denis Mekhanikov
Sorry for a vague answer, my bad. As I understand, you are trying to collect a tree based on fields typeId and pTypeId. This can be achieved by iteratively collecting objects from cache by typeId field. You can do this by making typeId a key of a cache or by building an SQL index and selecting

Re: An issue of Ignite In-Menory Sql Grid since version 2.0.0

2017-09-26 Thread Denis Magda
Denis Mek., How do you suggest executing the same query without SQL? Please be specific if you advise discontinuing the SQL for the use case. Alex P., Vladimir, What’s the main reason of WITH RECURSIVE removal? Why it worked before and broken now?

Re: Re: An issue of Ignite In-Menory Sql Grid since version 2.0.0

2017-09-25 Thread Denis Mekhanikov
Yes, you are right about that, but Ignite has no intention to support this syntax, it worked in 1.9 by chance. Here, I found a ticket to explicitly forbid it: https://issues.apache.org/jira/browse/IGNITE-5289 So, it's better to use cache directly without SQL in your case. Denis пн, 25 сент.

Re:Re: An issue of Ignite In-Menory Sql Grid since version 2.0.0

2017-09-24 Thread 贺波
Hi! I have executed the recursive sql statement on H2 database,it executes correctly.But it executes error since version 2.0.0.So I think it's a bug of Ingite,not H2.My test demo is in the attachment. At 2017-09-23 00:20:12, "Denis Mekhanikov" wrote: Hi!

Re: An issue of Ignite In-Menory Sql Grid since version 2.0.0

2017-09-22 Thread Denis Mekhanikov
Hi! Internally Ignite uses H2 to process SQL queries. Recursive queries is an experimental feature of H2, so I wouldn't recommend you to use it in production for now. Ignite 2.0 and 2.1 don't seem to support this kind of queries, so the best option for you is to modify your query if possible to

An issue of Ignite In-Menory Sql Grid since version 2.0.0

2017-09-22 Thread 贺波
Hi,I used Apache Ignite in my project for more than a year,from version 1.8.0 to 2.2.0.I use Ignite In-Menory Sql Grid in my project.I use “with as” sql function in my sql,it executes correctly in version 1.9.0,but executes error since version 2.0.0.My sql statement is: with RECURSIVE