Hi, Ignite 1.6 requires data to be properly collocated in order for joins to work correctly. Namely, data being joined from tables Kc21 and Kc24 must be collocated. See [1] for more details on affinity collocation and [2] for more details on how SQL queries work. Also, take a look at org.apache.ignite.examples.datagrid.CacheQueryExample for correct collocation example.
There is a ticket [3] which will remove this restriction, and hopefully, in will get to Ignite 1.7. You can watch this ticket for progress. Hope this helps, AG --- [1] https://apacheignite.readme.io/docs/affinity-collocation [2] https://apacheignite.readme.io/docs/sql-queries [3] https://issues.apache.org/jira/browse/IGNITE-1232