Reading list datatype from Cassandra

Highlighted
Four Stars

Reading list datatype from Cassandra

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
Four Stars

Re: Reading list datatype from Cassandra

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
Four Stars

Re: Reading list datatype from Cassandra

Hi,

 

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

Regards,

Haritha

Forteen Stars

Re: Reading list datatype from Cassandra

can you try to extract list data type with tExtractJson?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Reading list datatype from Cassandra

Hi Mano,

Data is actually in arraylist with hashmap in it.

below is the format

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

Forteen Stars

Re: Reading list datatype from Cassandra

Hi Haritha,

 

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Reading list datatype from Cassandra

@haritharamini,did it help you?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog