Does Ignite support nested joins for partitioned cache?

[DS]

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/