View syntax errors from an external CQL script?

I am wondering if there is a simple way to view any syntax errors that may have been present in a .cql script that I run through cqlsh?

I have created several scripts with a huge number of INSERT statements to load data into my Cassandra db. To create the scripts I did a find/replace using notepad++ to prep the file (Yes, in hindsight I should have just wrote a Python script).

I know that there should be 7,500 records after I run the script, but there are only 7,483 - I suspect that some of the INSERTstatements aren't properly formatted (since I hacked the statements together) but I don't get any feedback from cqlsh.

Answers


I suggest trying DataStax DevCenter. It's a free tool (after registering on the website). It's a bit more of an IDE type experience where it will highlight syntax errors as you type. You could try pasting in your giant script and see what it shows.

The other thing I would check is to make sure you don't have any duplicates based on your primary key definition.


Need Your Help

How can I get GCM registered Id with asp.net?

c# android asp.net sql-server google-cloud-messaging

I have an android application which receives registered IDs and sends GCM. When a device registers I would like to take its id and add it to my MSSQL server. How can I get the devices's registered ID

android: how to resize dialog

android layout dialog

I would like to create a dialog-style form which would fill the bigger screen area (left, right, top, bottom padding 10px).