topic Re: how to setting connection timeout in talend in Talend Studio

how to setting connection timeout in talend

sakura99 — Sat, 16 Nov 2024 00:55:46 GMT

Hi all, I was testing the ETL from my sql production to bigdata (hive).

And I found that my records are reduced from 1200 to 28.

What went wrong? Are there any tools to settings the connection timeout in talend?

Any help or ideas will be appreciated.

Re: how to setting connection timeout in talend

Anonymous — Mon, 21 Dec 2020 06:42:56 GMT

Hello,

There is an option and it is only used by talend studio.

Window / Preferences ... / Talend / Performance --> Activate the Timeout for the Database Connection.

You can set a timeout in components using JDBC additional parameters.

What does your job design look like?

Best regards

Sabrina

Re: how to setting connection timeout in talend

sakura99 — Mon, 21 Dec 2020 12:36:53 GMT

is there, at any chance, that the reduction of the row is not caused by talend timeout? What are those things that I have to check?

Re: how to setting connection timeout in talend

Anonymous — Tue, 22 Dec 2020 04:12:49 GMT

Hello,

Is the whole work flow? From above screenshot, the row rate is decreasing obviously after tMap component. What's transformation are you achieving?

Best regards

Sabrina

Re: how to setting connection timeout in talend

sakura99 — Tue, 22 Dec 2020 10:40:16 GMT

from lower case into upper case. The columns is about 20 columns..

Re: how to setting connection timeout in talend

sakura99 — Tue, 22 Dec 2020 13:34:35 GMT

is it any issue about how the tdbinput sql works? e.g : I want to ingest xx_xx an the source column is xx_"xx" is there any treatment (I was using String Handling but produce error)