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