Extract Big Tables using tDBInput

Anonymous — Wed, 08 Apr 2020 11:19:11 GMT

Hi Guys,

I need help to solve this problem I'am getting when I try to put data from a tDBInput to a tFileOutputDelimited.

I got this error:

Error: java.lang.OutOfMemoryError: Java heap space

The table I'am trying to extract has about 50 millions of rows (postgresql), I've already tried giving the max to -Xmx but still don't work. Is there any workaround please?

Thank you for your help

Re: Extract Big Tables using tDBInput

manodwhb — Tue, 14 Apr 2020 03:20:49 GMT

I suggest you that you need to try for different combination values and need to see is it giving error or not.

Increase to more and see and those values are based on your RAM size ,you need to set those.

topic Extract Big Tables using tDBInput in Talend Studio

Extract Big Tables using tDBInput

Re: Extract Big Tables using tDBInput