Hi Bob, It's hard to tell how to collocate your data because it's not clear what this query is doing. Can you describe?
Generally that's right, you can collocate by a single field only, otherwise the data will end up on different nodes. If the data in two caches can't be collocated, you can also switch one of the caches to REPLICATED mode. Replicated caches don't need collocation, but they replicate all the data to all nodes. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-join-query-return-different-result-under-the-same-data-when-having-different-ignite-instance-tp6433p6478.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
