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.
