Re: IN Operator not working with sub query on different cache

[JP]

Continue with previous query

I also tried with distrubutedJoin=true in result no selected rows.


But if am using inner join result is returning.for example query:

SELECT * FROM 
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON".CommonConstruction
AS t1
INNER Join

"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_CONSTRUCTIONPROJECTROLE".ProjectsRole
AS t2
 ON 
 t1.UUID =t2.ProjectId 
 WHERE t2.PersonId = 'a91f8995-2c28-4f33-9587-817749526a55' 
 AND t2.ProjectAccessStatus = 'true' and t2.IsDeleted != 'true'
 AND t1.TableName='common_project'

Thanks.




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/