INSERT query failing in cassandra with .sql file

Question

I have a query in Cassandra

SELECT * FROM "A"."B" WHERE ("systemId" = 'CZ3741X5K8');

It has 4 fields one VARCHAR (systemId is a VARCHAR field) and 4 blob fields.

I have exported the results of the select query into a INSERT .sql file using RazorSQL and it is successful, However If I try to import the same file into another host, it does not import the data into the table.

script.sql:2:SyntaxException: line 1:257 mismatched character '0' expecting '-'

The source server and target server both have same Cassandra and CQL versions i.e.

 [cqlsh 5.0.1 | Cassandra 3.11.4 | CQL spec 3.4.4 | Native protocol v4]

Is there a way to fix it ?

Answer 1

If you are able to export your data to a CSV file, you can easily import it into Cassandra using the DataStax Bulk Loader (DSBulk) tool.

It is freely available for open-source Apache Cassandra users. Here are some references with examples to help you get started quickly:

• Blog - DSBulk Intro + Loading data
• Blog - More DSBulk Loading examples
• Blog - Counting records with DSBulk
• Docs - Loading data examples
• Answered questions - DataStax Community

Cheers!