Hi Val, thanks for the reply. I'll try again and let you know if I missed something.
By "Ignite is not optimized for join", I mean currently Ignite only supports nest loop join which is very inefficient when joining two large table. Please refer to these two tickets for details. https://issues.apache.org/jira/browse/IGNITE-6201 https://issues.apache.org/jira/browse/IGNITE-6202 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/