Re: Ignite SQL join performance

2017-10-30 Thread Vladimir Ozerov
Hi Ray, Basically, there are two ways: 1) Implement missing feature in H2, submit a patch, wait for new H2 version to release, and then move Ignite to this version 2) Wait for our own execution engine to appear and then implement these join algorithms there. On Mon, Oct 30, 2017 at 9:49 AM, Ray

Ignite SQL join performance

2017-10-30 Thread Ray
Currently the only way to join data is nested loops approach stated in this two tickets. https://issues.apache.org/jira/browse/IGNITE-6201 https://issues.apache.org/jira/browse/IGNITE-6202 So we can anticipate the SQL join performance will degrade a lot after the data size reached certain amount.