Re: Non Distributed Join between tables

[manueltg89]

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/