cannot convert from list to string

[Anonymous]

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.

[manodwhb]

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

for tjavrow and tmap.

String.valueOf(row1.col)

or

row1.col.tostring()

[Anonymous]

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

[manodwhb · Accepted solution]

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

[Anonymous]

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