topic Re: Help Explain "Type mismatch: cannot convert from String to List" in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 08:25:15 GMT

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

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

Anonymous — Thu, 12 Apr 2018 10:55:57 GMT

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

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

Anonymous — Thu, 12 Apr 2018 15:30:09 GMT

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.

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

Anonymous — Thu, 19 Apr 2018 16:09:33 GMT

bump

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

Anonymous — Fri, 20 Apr 2018 17:20:27 GMT

bump

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

Anonymous — Wed, 25 Apr 2018 10:22:42 GMT

Hello,

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

Best regards

Sabrina

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

manodwhb — Wed, 25 Apr 2018 12:39:16 GMT

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

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

manodwhb — Wed, 25 Apr 2018 13:34:39 GMT

@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().

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

Anonymous — Wed, 25 Apr 2018 14:51:41 GMT

@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

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

Anonymous — Wed, 25 Apr 2018 15:00:31 GMT

@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',:{}}
    }
]