Re: Join Query on two different caches

Hello! * Yes it is possible. * For the best results your data should be collocated on custNo. * Otherwise you would need distributed joins. Regards, -- Ilya Kasnacheev 2018-05-23 13:26 GMT+03:00 the_palakkaran : > Hi, > > Suppose I have two IgniteCaches customerCache

Join Query on two different caches

Hi, Suppose I have two IgniteCaches customerCache and addressCache, which contains data from Customer table and Account table respectively. Is it possible to execute a sql field JOIN query as below? select * from Customer,Address where custNo = adCustNo; (where Customer and Address are the model