I have the following issue when importing MsSQLServer data into Cassandra:
I need to import several MsSQLServer tables with varying number of fields into a single Cassandra Table with a 'Map' data type field. I'm having trouble combining, for instance, 5 fields of a schema into one object and inserting into the map in Cassandra.
My current approach was trying to use literal statements with bound variables (e.g "Insert into xx (id,map) values ('whatever', {'nonsense': ?});"), but that does not work, and the following error message pops up
- "Invalid map literal for sensors: bind variables are not supported inside collection literals"
Is the correct approach create a Java Object for each of the different MsSQLServer tables and then inserting it as follows:
