By default Ignite thinks that data is collocated. You have to tell Ignite that it is not. For example, by adding a parameter to JDBC connection: distributedJoins=true or by using this method SqlQueryFields.setDistributedJoins [1] in java API.
[1] https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/cache/query/SqlFieldsQuery.html#setDistributedJoins-boolean- -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
