topic Re: Reading list datatype from Cassandra in Talend Studio

Reading list datatype from Cassandra

ragavendrans — Tue, 02 Jan 2018 13:10:47 GMT

Hi,
I need to read LIST datatype data from Cassandra table. Can you please help finding a help material for this please? I tried searching but couldn't find much. Please help.

Thanks
Ragavendran S

Re: Reading list datatype from Cassandra

ragavendrans — Thu, 04 Jan 2018 04:06:42 GMT

Hi,
Can you please help on this scenario?
In one of the column (List datatype) in Cassandra table, I have data like this.
[{Field1:10,Field2:'value1'},{Field1:20,Field2:'value2'}]

I have to process this data which is coming in a single record.
Please help.

Thanks
Ragavendran S

Re: Reading list datatype from Cassandra

Anonymous — Wed, 07 Mar 2018 12:24:20 GMT

Hi,

Did u get any solution for this ? If yes, could you please help me as am facing the same issue .

Regards,

Haritha

Re: Reading list datatype from Cassandra

manodwhb — Wed, 07 Mar 2018 12:40:28 GMT

can you try to extract list data type with tExtractJson?

Re: Reading list datatype from Cassandra

Anonymous — Wed, 07 Mar 2018 13:18:17 GMT

Hi Mano,

Data is actually in arraylist with hashmap in it.

below is the format

[{Field1:10,Field2:'value1'},{Field1:20,Field2:'value2'}]

Re: Reading list datatype from Cassandra

manodwhb — Thu, 08 Mar 2018 10:11:56 GMT

Hi Haritha,

you can do in tmap using index and substring function,can you try.

Re: Reading list datatype from Cassandra

manodwhb — Tue, 03 Apr 2018 14:21:56 GMT

@rchinta,did it help you?