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 obj
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?
https://issues.apache.org/jira/browse/IGNITE-
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 сент. 2017
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!
Internally Ignite uses H2
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 av
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