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 <jik...@suntecsbs.com>: > 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 classes) > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >