topic Re: cannot convert from list to string in Talend Studio

cannot convert from list to string

Anonymous — Sat, 16 Nov 2024 06:05:07 GMT

Hi,

Iam using Talend openstudio with bigdata .Here my source is Cassandra target is sql server.When iam trying to map List type column in source to varchar type in target iam getting below erro

cannot convert from list to string.

Can you please help me how to convert List type to string.

Re: cannot convert from list to string

manodwhb — Fri, 12 Apr 2019 09:15:52 GMT

@ruthvi ,you can convert using tjavarow or tmap or tconverttype,

for tjavrow and tmap.

String.valueOf(row1.col)

row1.col.tostring()

Re: cannot convert from list to string

Anonymous — Fri, 12 Apr 2019 09:34:40 GMT

Thankyou so much..
String.valueof(row1.col) is working for me now.Can you tell me why iam getting nullpointer exception while loading data into target i.e sqlserver.For tlogrow the data is coming fine

Re: cannot convert from list to string

manodwhb — Fri, 12 Apr 2019 09:37:53 GMT

@ruthvi ,some of the records may have the null values in that column ,in DB side it would be not null constrain is there.

Re: cannot convert from list to string

Anonymous — Fri, 12 Apr 2019 10:10:14 GMT

Yes, the problem is with database schema.
Thankyou for quick response.