Hi, IN operator has some limitations in Ignite, it is recommended to use joins instead [1] As I understand from your second message, with JOIN you get correct results.
[1] https://apacheignite.readme.io/docs/sql-performance-and-debugging#sql-performance-and-usability-considerations On Tue, May 25, 2021 at 1:55 PM JP <[email protected]> wrote: > 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/ >
