question

gxeon2019_190087 avatar image
gxeon2019_190087 asked Erick Ramirez answered

How can we map JSON columns to SQL format?

Hi Team

Need helps on Cassandra Json Mapping to SQL. We planning to migrate cassandra to Azure SQL server and wanting to keep the Same JSON Table/Schema Structures in SQL server DB as in Cassandra. But having issues while mapping the JSON columns to SQL format.

Please find below problem statements.

1) here Column1 have 3 different key/value pair in form of array -- > how can we put into single SQL Column or do we need to divide it in 3 different columns of a table ?

Column 1 Colum 2
{ "additionalProp1": "string", "additionalProp1": "string", "additionalProp3": "string"} 1,18,12,34,12,31,21,23,00,00,00,00,00,00,00,00,00,000

2) Do we have any other method where we can extract Cassandra objects structures into SQL format - other than JSON ?

Appreciate your kind help

Kind regards

Gaurav

migration
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

There is no such thing as extracting into "SQL format". You need to transform the data yourself after you've exported it from Cassandra.

Since this isn't a Cassandra issue, I suggest you get help from Azure. Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.