Hello! If both tbl_a and tbl_c use tbl_b.id == tbl_a.fk_id == tbl_c.fk_id as affinity key, then I assume it would.
Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 19:17, manueltg89 <manuel.trinidad.gar...@hotmail.com >: > With the following structure, and partitioned cache in the three tables: > > tbl_a tbl_b tbl_c > ----- ------ ----- > aff_a aff_b > > When I make: select * from tbl_a INNER JOIN tbl_b ON tbl_b.id = > tbl_a.fk_id > INNER JOIN tbl_c.fk_id = tbl_b.id > > Should it work and return results always? > > The question is: If tbl_c is collocated with tbl_b and tbl_b is collocated > with tbl_a, should it be collocated tbl_a with tbl_c? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >