How to retrieve data from Cassandra MAP data type column

One Star

How to retrieve data from Cassandra MAP data type column

Hi,
I have a requirement to retrieve data from Cassandra and the column is a map data type. It holds around 700 key value pairs and it is dynamic. Need to split one column value of Cassandra into multiple columns in SQL table but defining schema for 700 columns which are not static is not possible.
Moderator

Re: How to retrieve data from Cassandra MAP data type column

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to retrieve data from Cassandra MAP data type column

Hi Sabrina,
I have attached the screenshot of my input and what I'm expecting in output.
Input is a Cassandra source and one of the column say col2 is defined as MAP data type.
value of COL2 : {'Rs_BuildingsFloodRe': '69.618', 'Rs_ContentsFloodRe': '69.618', 'Rs_CovBuildings': '69.618', 'Rs_BuildingsDiscounted': '0'}
now I'm trying to retrieve these key value pairs from column COL2  in SQL table as
Rs_BuildingsFloodRe   Rs_ContentsFloodRe   Rs_CovBuildings   Rs_BuildingsDiscounted
69.618                            69.618                            69.618                    0

Let me know if more information is required.
Thanks
One Star

Re: How to retrieve data from Cassandra MAP data type column

Hi,
Is there any way or talend doesn't support this functionality?

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now