Hello! Do you have a reproducer SQL script to observe that?
Regards, -- Ilya Kasnacheev пн, 8 июн. 2020 г. в 10:46, manueltg89 <manuel.trinidad.gar...@hotmail.com>: > 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/ >