Help Explain "Type mismatch: cannot convert from String to List"

[Anonymous]

New to Talend. Edit schema from source shows Type as "List", destination as "List". Please explain message.

[Anonymous]

Hello,

Which talend component are you using? What does your input source look like? More information will be helpful for us to address your issue.

Best regards

Sabrina

[Anonymous]

I have a tCassandraInput in which I have retrieved schema for column family "cfX". Edit schema -> Column "cY" Type is "List", DB Type "List". tCassandraInput connected to tNormalize with Row (Main). tNormalize Edit schema: Input-Main: Column "cY" Type is "List", DB Type "List"; Output: Column "cY" Type is "List". tNormalize has output Row (Main) to tFileOutputDelimited. Same settings there, "List" to "List". Error is shown on tNormalize.

I have encountered this before, and not really understood why "String" appears in the error message, or where to research or how to proceed.

[Anonymous]

bump

[Anonymous]

bump

[Anonymous]

Hello,

Could you please indicate on which talend build version you got this issue? We will make a testing on it.

Best regards

Sabrina

[manodwhb]

@TWOF,i belive you were getting this on tNormalize component. could you please let me know what exactly are you doing in tNormalize component?

[manodwhb · Accepted solution]

@TWOF,i have verified that List data type is not working in tNormalize,since i suggest you to convert list to sting to use tNormalize component. to covert sting you can use tConvertType or in tmap use toString().

[Anonymous]

---

@xdshiwrote:

Hello,

Could you please indicate on which talend build version you got this issue? We will make a testing on it.

Best regards

Sabrina

---

Talend version 6.5

[Anonymous]

---

@manodwhbwrote:

@TWOF,i belive you were getting this on tNormalize component. could you please let me know what exactly are you doing in tNormalize component?

---

I was attempting to extract a nested / deep list from Cassandra into usable form (separate columns would be nice) which is difficult to parse due to lack of available delimiters, see below. This one column contains data, and lists within lists. Currently working with Talend support for a solution.

column_nested_data
[
    {
    number:1
    data1:NULL
    data2:NULL
    otherstuff:false
    a_set_of_data{'3,5'}
    another_set{4,6}
    a_nested_set{{5,7}
        type:a
        color:{'3':'6'}}
    more:{'4',:{}}
    }
]