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/
