script.sh

#!/bin/bash
wget https://raw.githubusercontent.com/academyofdata/inputs/master/movies.csv -O /tmp/movies.csv
wget https://raw.githubusercontent.com/academyofdata/inputs/master/ratings2.csv -O /tmp/ratings_s.csv
wget https://raw.githubusercontent.com/academyofdata/inputs/master/ratings.csv.gz -O /tmp/ratings.csv.gz
gunzip /tmp/ratings.csv.gz
wget https://raw.githubusercontent.com/academyofdata/inputs/master/users.csv -O /tmp/users.csv
cqlsh -e "create keyspace test with replication = {'class':'SimpleStrategy','replication_factor' : 1}"
cqlsh -e "create table test.users ( uid int PRIMARY KEY, age int, gender text, occupation text, zip text)"
cqlsh -e "create table test.movies (  movieid int, title text, genres set<text>, year int, primary key (movieid,year))"
cqlsh -e "create table test.ratings_s ( rmid int, rating double, ruid int,timestamp timestamp,primary key(rmid, rating, ruid))"
cqlsh -e "create table test.ratings( mid int,uid int,rating double,age int,gender text, genres set<text>,occupation int,rating_time timestamp,title text, year text,zip text,PRIMARY KEY (mid, uid, rating)) WITH CLUSTERING ORDER BY (uid ASC, rating DESC)"
cqlsh -e "copy test.movies(movieid, title, genres,year) from '/tmp/movies.csv' with header = true"
cqlsh -e "copy test.ratings_s(ruid, rmid, rating, timestamp) from '/tmp/ratings_s.csv' with header = true"
cqlsh -e "copy test.ratings(uid, age, gender, occupation, zip, rating, rating_time, mid, title, year, genres) from '/tmp/ratings.csv' with header = true"
cqlsh -e "copy test.users(uid,gender,age,occupation,zip) from '/tmp/users.csv' with header = true"