Re: Ignite 2.8.1 : Fetched result set was too large.

Thanks Stephen for the quick response. We did tried this option increasing IGNITE_SQL_MERGE_TABLE_MAX_SIZE to 50 in IGNITE SERVER But we are still getting the same exception. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Exception while running Select Query in ignite 2.8.1 - Fetched result set was too large

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 : > Hi, > > We are getting below exception execution join query using Cache. > We

Exception while running Select Query in ignite 2.8.1 - Fetched result set was too large

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.igni

Re: Ignite 2.8.1 : Fetched result set was too large.

In fact, the error message has improved in more recent versions: https://github.com/apache/ignite/blob/2a85925f1705fbad36b5421c0ca5cf9de9a29658/modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/twostep/ReduceIndex.java#L398

Ignite 2.8.1 : Fetched result set was too large.

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.igni