I have three tables in Apache Ignite, each table has a affinity key to other table, when I make a join between tables with direct relations this works perfectly, but if I make a non distributed join between three tables this return empty, is normal this behaviour?, Could I make in another way?
tbl_a tbl_b tbl_c ----- ------ ----- aff_b aff_b When I make: select * from tbl_a INNER JOIN tbl_b ON tbl_a.id = tbl_a.fk_id = tbl_b.id -> All OK When I make: select * from tbl_a INNER JOIN tbl_b ON tbl_a.id = tbl_a.fk_id = tbl_b.id INNER JOIN tbl_c.fk_id = tbl_b.id -> Return empty results. Thanks in advance. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
