topic How to retrieve data from Cassandra MAP data type column in Talend Studio

How to retrieve data from Cassandra MAP data type column

Anonymous — Sat, 16 Nov 2024 10:24:03 GMT

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.

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

Anonymous — Tue, 13 Sep 2016 09:56:37 GMT

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

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

Anonymous — Thu, 15 Sep 2016 09:17:52 GMT

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

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

Anonymous — Mon, 19 Sep 2016 09:01:52 GMT

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