Hi Lucky, It seems that I was wrong. You need to increase the value of IgniteSystemProperty#IGNITE_SQL_MERGE_TABLE_MAX_SIZE [1] The default value is 10 000.
[1] https://ignite.apache.org/releases/2.1.0/javadoc/org/apache/ignite/IgniteSystemProperties.html#IGNITE_SQL_MERGE_TABLE_MAX_SIZE Thanks. 2017-09-12 9:50 GMT+03:00 Lucky <[email protected]>: > Hi > I use jdbc to fetch result from cache. > Class.forName("org.apache.ignite.IgniteJdbcThinDriver"); > Connection conn = DriverManager.getConnection("jdbc:ignite:thin://IP"); > ResultSet rs = conn.createStatement().executeQuery(sql); > > And the sql is like this: > select v.id,v.name,v.seq from (selet a.id as id,b.name as name,c.seq as > seq from a inner join b on a.id= b.id left outer join c on a.id=c.id) v > left outer join (select did from d where cid in(Ids) group by did having > count(did)>=3000) w on v.id = d.did where d.did is null > > when 'select did from d where cid in(Ids) group by did having > count(did)>=3000' return few records ,this sql is work,but if it return > 20,000 records(actually it's often return 10 million records),it got this > wrong message:Fetched result set war too large. > > And the whole sql is expected 30,000 records. > Any suggestion? Thanks. > Lucky. > > > >
