Re: Join between replicated and partitioned caches

2021-01-19 Thread akorensh
Hi, What matters is how the data is finally distributed after all affinity keys (or lack thereof)are taken into account. If you are joining using an affinity key column then it is called a collocated join as each set of data can be fully retrieved from a single node, then added together. If you a

Re: Join between replicated and partitioned caches

2021-01-19 Thread Clay Teahouse
Thanks. How about a join between two partitioned tables with different affinity keys or a join between two tables with one having an affinity key defined and the other with no affinity key explicitly defined? On Tue, Jan 19, 2021 at 11:59 AM Craig Gresbrink wrote: > Since a replicated cache has

RE: Join between replicated and partitioned caches

2021-01-19 Thread Craig Gresbrink
Since a replicated cache has an entire copy of all its data on each server node, the data is local so you can join to it is my understanding. From: Clay Teahouse Sent: Tuesday, January 19, 2021 9:49 AM To: user@ignite.apache.org Subject: Join between replicated and partitioned caches CAUTION: T