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
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.