You have to collocate Persons with their organizations, so that all the Persons for any given Organization reside on the same node with that Organization.
Read more here: https://apacheignite.readme.io/docs/affinity-collocation Sergi 2015-10-27 18:29 GMT+03:00 iceguo <[email protected]>: > I had started 2 Ignite nodes, and put table "Person" and "Organization" to > these 2 Ignite nodes with all cache mode is ”Partitioned“, > > then I did a cross-cache SQL joins as following: > "select Person.firstName from Person, \"OrganizationCache\".Organization > where Person.orgid = Organization.id and Organization.name = ?". > > then I found the result in incomplete, it losted almost half results. > > When I use cache mode is "replicated" or I use only one node, the result is > complete. > > I want to know how to get the complete result between two PARTITIONED data > sets with "Partitioned" cache mode. > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
