I have around 5 million records of data, which includes JSON data type in our Cassandra DB. I am trying to move the data from Cassandra to MemSQL.
I tried to export data to CSV and import the data, but running into issues due to
- Null or Empty column values
- JSON having comma separated values and CSV having comma separated values
- Large CSV file
due to null column values, and JSON comma separated since the volume is large, it is not working as expected.
Is there any other best way to do this?