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/
