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 <[email protected]> wrote: > 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 <[email protected]> > *Sent:* Tuesday, January 19, 2021 9:49 AM > *To:* [email protected] > *Subject:* Join between replicated and partitioned caches > > > > *CAUTION:* This email originated outside 24 Hour Fitness. Do not click > links or open attachments unless you recognize the sender and know the > content is safe. > > > > Hello All, > > > > I am using SqlFieldsQuery to execute sql queries and I am setting the > option setLocal to true to process the local data only. What happens if the > sql has a join with a replicated cache? > > > > thank you > > Clay >
