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

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

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

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

IN Operator not working with sub query on different cache

Hi, I am using apache Ignite v2.9.1 as .Net client server. I have two caches and each cache is belong to separate cache group. Not working query: SELECT * FROM "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON".CommonConstruction Where TableName='common_project