Setup.MD

1: Commands to run to be able to setup Cassandra

Note: This worked.

docker pull cassandra:latest
docker network create cassandra
docker run --rm -d --name cassandra --hostname cassandra --network cassandra cassandra

docker cp test-setup/data.cql cassandra:/data.cql
docker exec -it cassandra cqlsh -f /data.cql
docker exec -it cassandra cqlsh

2: Commands to run to be able to setup Cassandra

Note: We did not get this setup to work.

Based on the given link: Cassandra Quickstart

Setup

docker pull cassandra:latest

# Start cassandra
docker network create cassandra

docker run --rm -d --name cassandra --hostname cassandra --network cassandra cassandra

Create a file

Check the data.sql file.

Load and run interactive shell

# Load data with CQLSH
docker run --rm --network cassandra -v "$(pwd)/data.cql:/scripts/data.cql" -e CQLSH_HOST=cassandra -e CQLSH_PORT=9042 -e CQLVERSION=3.4.6 nuvo/docker-cqlsh

# Interactive CQLSH
docker run --rm -it --network cassandra nuvo/docker-cqlsh cqlsh cassandra 9042 --cqlversion='3.4.5'

Cleaning up

docker kill cassandra
docker network rm cassandra

Examples of reading/writing data in CQLSH

SELECT * FROM store.shopping_cart;

INSERT INTO store.shopping_cart (userid, item_count) VALUES ('4567', 20);