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.
