Reading list datatype from Cassandra

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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download