CASSIEs

CONSISTENCY ONE;
CREATE KEYSPACE james WITH replication = {'class':'SimpleStrategy', 'replication_factor': 1};
describe keyspaces;
describe tables;
use james;
CREATE TABLE james (column1 int PRIMARY KEY, column2 text);
INSERT INTO james (column1, column2) VALUES(42, 'just a test');
SELECT * FROM system_schema.keyspaces;


USE system;
SELECT * FROM system.peers;

select * from cosmopolitans_logs where stamp_id >= '2019-12-14 00:00:00+0000' allow filtering;

CREATE KEYSPACE test WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'};
ALTER KEYSPACE test WITH REPLICATION = {'class' : 'NetworkTopologyStrategy', 'dc1' : 3, 'dc2' : 2};
USE test;
CREATE TABLE users (name text, PRIMARY KEY (name));
INSERT INTO users (name) VALUES ('James');
SELECT * FROM users;


USE test;
SELECT * FROM users;
LIST USERS;