Cassandra Commands

Cassandra DB:

docker -v

docker-compose -v

docker run \
    --name cassandra \
    -p 7000:7000 \
    -p 9042:9042 \
    -v clocal:/bitnami \
    -d bitnami/cassandra:latest
	
docker logs -f cassandra

docker stop cassandra

docker rm cassandra

docker-compose config --services

docker exec -it cassandratest-cassandra-1 bash

ls -ltrs

/opt/bitnami/cassandra/bin/cqlsh -u cassandra -p cassandra

CREATE KEYSPACE IF NOT EXISTS cycling
  WITH REPLICATION = {
   'class' : 'SimpleStrategy',
   'replication_factor' : 1
  };


DESCRIBE keyspaces;

use cycling;

DROP TABLE IF EXISTS cycling.cyclist_name;

CREATE TABLE cycling.cyclist_name (
  id UUID PRIMARY KEY,
  lastname text,
  firstname text,
  details_ map
);

INSERT INTO cycling.cyclist_name (id, lastname, firstname, details_) VALUES (e7cd5752-bc0d-4157-a80f-7523add8dbcd, 'VAN DER BREGGEN', 'Anna', {'details_age':'35', 'details_bday':'27/07/1980', 'details_nation':'AUSTRALIA'});
INSERT INTO cycling.cyclist_name (id, lastname, firstname, details_) VALUES (e7ae5cf3-d358-4d99-b900-85902fda9bb0, 'FRAME', 'Alex', {'details_age':'54', 'details_bday':'27/07/1961', 'details_nation':'ITALY'});
INSERT INTO cycling.cyclist_name (id, lastname, firstname, details_) VALUES (220844bf-4860-49d6-9a4b-6b5d3a79cbfb, 'TIRALONGO', 'Paolo', {'details_age':'23', 'details_bday':'27/07/1992', 'details_nation':'CANADA'});
INSERT INTO cycling.cyclist_name (id, lastname, firstname, details_) VALUES (6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47, 'KRUIKSWIJK', 'Steven', {'details_age':'23', 'details_bday':'27/07/1992', 'details_nation':'GERMANY'});
INSERT INTO cycling.cyclist_name (id, lastname, firstname, details_) VALUES (fb372533-eb95-4bb4-8685-6ef61e994caa, 'MATTHEWS', 'Michael', {'details_age':'28', 'details_bday':'27/07/1987', 'details_nation':'NETHERLANDS'});


DROP TABLE IF EXISTS cycling.cyclist_races;
DROP TYPE IF EXISTS cycling.race;

CREATE TYPE cycling.race (
   race_title text,
   race_date timestamp,
   race_time time);

CREATE TABLE cycling.cyclist_races (
  id UUID PRIMARY KEY,
  lastname text,
  firstname text,
  races list> );

INSERT INTO cycling.cyclist_races (id,races) VALUES (
   e7ae5cf3-d358-4d99-b900-85902fda9bb0,
   [ { race_title:'17th Santos Tour Down Under Aalburg', race_date:'2017-04-14',race_time:'07:00:00' },
     { race_title:'17th Santos Tour Down Under Gelderland', race_date:'2017-04-14', race_time:'08:00:00' } ]);

INSERT INTO cycling.cyclist_races (id, lastname, firstname, races) 
VALUES (
	e7cd5752-bc0d-4157-a80f-7523add8dbcd, 'VAN DER BREGGEN', 'Anna', 
	[ {race_title:'Festival Luxembourgeois du cyclisme feminin Elsy Jacobs - Prologue - Garnich > Garnich',race_date:'2017-04-14',race_time:'08:00:00'},
		{race_title:'Festival Luxembourgeois du cyclisme feminin Elsy Jacobs - Stage 2 - Garnich > Garnich',race_date:'2017-04-14',race_time:'06:00:00'},
		{race_title:'Festival Luxembourgeois du cyclisme feminin Elsy Jacobs - Stage 3 - Mamer > Mamer',race_date:'2017-04-14',race_time:'10:00:00'} ]);

UPDATE cycling.cyclist_races
	SET 
    lastname = 'FRAME',
    firstname = 'Alex',
    races[1] = { race_time:'06:00:00'}
		WHERE id = e7ae5cf3-d358-4d99-b900-85902fda9bb0;
		
		
DESCRIBE TYPES;

DESCRIBE TABLES;

SELECT * from cycling.cyclist_name;

SELECT lastname, races FROM cycling.cyclist_races WHERE id = e7ae5cf3-d358-4d99-b900-85902fda9bb0;


Ref:
https://2much2learn.com/setting-up-cassandra-with-docker/

CREATE KEYSPACE IF NOT EXISTS museum
  WITH REPLICATION = {
   'class' : 'SimpleStrategy',
   'replication_factor' : 1
  };
DESCRIBE keyspaces;
use museum;
DROP TABLE IF EXISTS museum.museum_name;
CREATE TABLE museum.museum_name (
  id int PRIMARY KEY,
  name text,
  country text,
);

INSERT INTO museum.museum_name (id, name, country) VALUES(ed865d88-81de-36ec-84c5-a6ec8f3ffc57, 'Smithsonian Institution', 'Washington');
INSERT INTO museum.museum_name(id, name, country) VALUES(3d1c3aae-1437-3bd2-b76b-28305ed13c2a, 'Le Louvre', 'Paris');
INSERT INTO museum.museum_name(id, name, country) VALUES(1b273966-b60b-3504-9c52-19f8ef70b712, 'The Acropolis Museum', 'Greece');

SELECT * from museum.museum_name;

CREATE KEYSPACE IF NOT EXISTS meme
  WITH REPLICATION = {
   'class' : 'SimpleStrategy',
   'replication_factor' : 1
  };
DESCRIBE keyspaces;
use meme;

DROP TABLE IF EXISTS meme.vmeme;
CREATE TABLE meme.vmeme (
  id int PRIMARY KEY,
  movie_name text,
  dialogue text,
);

INSERT INTO meme.vmeme (id, name, country) VALUES(ed865d88-81de-36ec-84c5-a6ec8f3ffc57, 'Winner', '<dialogue should come here>');

SELECT * from meme.meme;

SELECT * from meme.meme where movie_name = 'Winner' allow filtering;

INSERT INTO meme.vmeme (id, movie_name, dialogue) VALUES(1, 'Winner', 'Athu pona maasam ,naan sonnathu entha maasam.');
INSERT INTO meme.vmeme (id, movie_name, dialogue) VALUES(2, 'Thailainagaram', 'Yey.Enna vechu comedy geemedy oonum pannaliye!');
INSERT INTO meme.vmeme (id, movie_name, dialogue) VALUES(3, 'Friends', 'Anniyae pudunga vaenam');

CREATE CUSTOM INDEX vmeme_dialogue_idx ON meme.vmeme (dialogue) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'CONTAINS', 'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'case_sensitive': 'false'};

CREATE CUSTOM INDEX employee_firstname_idx ON bth.employee (firstname) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'CONTAINS', 'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'case_sensitive': 'false'};


https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/queriesTOC.html

https://stackoverflow.com/questions/43838772/how-to-enable-user-defined-functions-in-docker-instance-of-cassandra