Hi All, I have encountered a puzzling join case. I have 3 tables on a cluster of two ignite server nodes: table-A (id + org = primary), replicated id org. <-- affinity other fields
table-B (id, org, add-id=primary key), partitioned id org <- affinity addr-id other fields table-C (id, org, comp-id=primary key), partitioned id org <- affinity comp-id other fields joins between table-A and table-B (on id, and org) succeeds. joins between table-A and table-C (of id and org) succeeds. joins between table-B and table-C (on id and org) fails. all three joins succeed if the cluster has only one server node. Why the join between the partitioned caches fail in a distributed mode? I am using JDBC connection for select statements. The join fails whether dealing with thick or thin client. thanks
