In the above example, there is only 1 join condition in the SQL, ”Person.orgid = Organization.id “, we can collocate Persons with their organizations by setting “Person.key = new AffinityKey<>(Person.id, Person.orgid)".
But if my join SQL including more than 1 join conditions. such as: "select Person.firstName from Person, \"OrganizationCache\".Organization where Person.orgid = Organization.id and Person.firstName = Organization.name". How to collocate Persons with their organizations? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723p1754.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
