CODEWITHSUNDEEP
talend
Ree
Ree

Reputation: 903

Data truncation and null input strings

I am working in Talend and have managed to get data from a CSV file and filter it before putting into a table. The problem I am having now is to do with the length of the data.

This is the red text I get:

For input string: "null"
For input string: "null"
For input string: "null"
Data truncation: Data too long for column 'Street' at row 58
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null"
Data truncation: Data too long for column 'Street' at row 23 
...

etc.

I have changed the length of the data in my schema such that it is propagated everywhere. I really don't know what to do to resolve this.

Upvotes: 2

Views: 3791

Answers (1)

Daniel San
Daniel San

Reputation: 2036

As pointed above, this problem is caused because the output data is longer than the maximum defined length in the database's table. Check the definition and alter it if possible.

Other solution is to output a short version of the data using an expresion like row1.column.substring(0,50) in the output flow.

Upvotes: 1

Related Questions