A quick question on Ignite's B+ tree implementation

2017-09-22 Thread John Wilson
Hi, The internal nodes of a B+ tree, by definition, store only keys while the leaf nodes store (or hold pointer to) the actual data. The documentation here, https://apacheignite.readme.io/docs/memory-architecture, states that each index node (including internal nodes) store information to access

Re: Ignite Server start failing with the exception with Ignite 2.1.0

2017-09-22 Thread Denis Mekhanikov
Hi! Could you describe your scenario in more detail? What configuration do your nodes have and in what order do you start them? Do some nodes go down during the deployment? What environment do you have? Situation that you described sounds too simple to cause any problems. Denis чт, 21 сент.

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

Re:Re: Join with subquery in 1.9 or 2.0

2017-09-22 Thread 贺波
Hi, Your demo is different from my.Mine is an example of recursive,using "with as"function.My test demo is in the attachment.package userlist; import java.util.List; import org.apache.ignite.Ignite; import org.apache.ignite.IgniteCache; import org.apache.ignite.cache.CacheAtomicityMode;

Re: Join with subquery in 1.9 or 2.0

2017-09-22 Thread Andrey Mashenkov
Hi, I can't reproduce the issue neither on 1.9 nor 2.0 nor 2.1 version. PFA repro attached. Would you please check if I've missed smth? On Wed, Sep 20, 2017 at 1:41 PM, Andrey Mashenkov < andrey.mashen...@gmail.com> wrote: > Hi, > > Looks like a bug. > > Would you please share a full

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

Re: Using ignite with spark

2017-09-22 Thread Patrick Brunmayr
Hello Val First of all thx for this answer. Let me explain our use case. *What we are doing* Our company is a monitoring solution for machines in the manufacturing industry. We have a hardware logger attached to each machine wich collects up to 6 different metrics ( like power, piece count ).