You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Lucky <wa...@163.com> on 2017/09/19 02:10:06 UTC
回复: Fetched result set too large
I see the document you refer to.but I don't know how to set this property value.
I excepted to use java code .
Is there any example?
Thanks.
Lucky
2017年09月18日 22:50,Вячеслав Коптилин<sl...@gmail.com> :
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 <wa...@163.com>:
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.
回复: Fetched result set too large
Posted by Lucky <wa...@163.com>.
I see.
Thanks a lot!
2017年09月19日 13:49,slava.koptilin<sl...@gmail.com> :
Hi Lucky,
You just need to start grid with -DIGNITE_SQL_MERGE_TABLE_MAX_SIZE=30000 JVM
flag.
Thanks,
Slava.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: 回复: Fetched result set too large
Posted by "slava.koptilin" <sl...@gmail.com>.
Hi Lucky,
You just need to start grid with -DIGNITE_SQL_MERGE_TABLE_MAX_SIZE=30000 JVM
flag.
Thanks,
Slava.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/