Hi, Try to use qry.setDistributedJoins(true). This should always return correct result.
However, it has poor performance as due to intensive data exchange between nodes. By default, Ignite join only the data available locally on each node. Try to collocate your data to get better performance with non distributed joins. сб, 29 сент. 2018 г., 3:39 Skollur <[email protected]>: > I am using Apache Ignite 2.6 version. I have two tables as below i.e > SUMMARY > and SEQUENCE > > SUMMARY-> DW_Id bigint (Primary key) , Sumamry_Number varchar, Account_Type > varchar > SEQUENCE-> DW_Id bigint (Primary key) , Account_Type varchar > > Database and cache has same number of records in both tables. Database JOIN > query returns 1500 counts/records and However IGNITE JOIN returns only 4 > counts and 4 records. Ignite cache is build based on auto generated web > console. Query used is as below. There is no key involved while joining two > cache tables here from two cache.tables. This is simple join based on > value(i.e account type - string). How to get correct value for JOIN in > Ignite? > > SELECT COUNT(*) FROM SUMMARY LIQ > INNER JOIN SEQUENCE CPS ON > LIQ.Account_Type = CPS.Account_Type > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
