I have been trying to implement nested joins with or without subquery but unable get right results. My caches are partitioned ,so enabling Allow non-collocated joins check.
P.S. It has been observed that if i am tyring to join 3 tables,i get expected result but for more than 3 tables worries me. Please let me know if i am doing something wrong with query below: SELECT _medical_info.age,_medical_info.name,_medical_info.city_id,_medical_info.weight,_medical_info.blood_group,blood_group_info.universal_donor FROM ( SELECT _person.age,_person.name,_person.city_id,medical_info.blood_group,medical_info.weight FROM ( SELECT person.age,person.name,city.city_id FROM person LEFT JOIN city ON person.city_id = city.city_id ) AS _person LEFT JOIN medical_info ON _person.name = medical_info.name ) AS _medical_info LEFT JOIN blood_group_info ON _medical_info.blood_group = blood_group_info.blood_group -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/