Hi, We are getting below exception execution join query using Cache. We are using left outer join on two tables one with 2lakh rows and another with 80K and output has around 60K rows with various where conditions.
Cache.executequery() is returning below exception. Error: class org.apache.ignite.IgniteException: Fetched result set was too large. exception javax.cache.CacheException: Failed to run reduce query locally. Failed to execute SQL query. General error: "class org.apache.ignite.IgniteException: Fetched result set was too large."; SQL statement: We are using Ignite persistence enabled cache and tried lazy loading and enforce join order options already. Tried executing the join query in dbeaver and got same exception. Will increasing RAM helps or is there any other solution to it. Please suggest. Thanks in advance. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
