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.
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
