This fork of sstableloader-csv adapts the code to use CQLSSTableWriter instead of the older SSTableSimpleUnsortedWriter. With these changes, tables can be bulk inserted into Cassandra without the use of cassandra-cli. You must specify your schema and insertion queries within separate text files. These filenames must be included as parameters when executing the run.sh script. Sample schema.cql and insert.cql files are included for you. A test csv file is also provided that should work with this code out of the box.
This tool parses CSV files into sstables for Apache Cassandra. It was written for a project involving the need to parse ~75 Million row CSV files.
Run the 'run' script with 5 arguments - <keyspace> <column> <schema_file> <insert_file> <input>
For example:
./run.sh test data schema.cql insert.cql test.csv
- $CASSANDRA_HOME must be set to the location of the apache-cassandra.jar & associated libraries.
- $CASSANDRA_CONFIG must be set to the location of your cassandra.yml config.
The number of columns & names are coded in DataImport.java, you'll need to change these yourself. There isn't also any error handling in the parsing, the data I was handling was known to be error-free.