Hello! Please check out https://lists.apache.org/thread.html/rf9a3f10fb719f9c1e31516992cc624f9898b08857c34b6e5a3a0fc13%40%3Cuser.ignite.apache.org%3E
Regards, -- Ilya Kasnacheev чт, 4 мар. 2021 г. в 08:52, Veena <sriveena.mattapar...@eka1.com>: > 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/ >