Hmmm. Can I use limit and offset ? Doing limit 10000 by example and continue while insert ount = 10000 ???
Le jeu. 30 mai 2019 à 17:57, Ilya Kasnacheev <[email protected]> a écrit : > Hello! > > I'm afraid you will have to split this query into smaller ones. Ignite > doesn't really have lazy insert ... select, so the result set will have to > be held in heap for some time. > > Regards, > -- > Ilya Kasnacheev > > > чт, 30 мая 2019 г. в 18:36, yann Blazart <[email protected]>: > >> Hello, we have 6 nodes configured with 3Gb heap, 30Gb offheap. >> >> We store lot's of data in some partitioned tables, then we are executing >> some "insert into select... join..." using SqlQueryField (or >> SqlQueryFieldEx). >> >> With tables of 5000 000 lines, we ran in a OOM error, even with lazy set >> to true and skipOnReduceTable. >> >> How can we handle this please ? >> >> Regards. >> >
