dtUBcq7m

1# connect to cassandra via cqlsh
2cqlsh localhost 9042 --cqlversion 3.4.4
3
4# create keyspace
5CREATE KEYSPACE IF NOT EXISTS mystiko
6WITH REPLICATION = {
7  'class' : 'SimpleStrategy',
8  'replication_factor': 1
9};
10
11# create table
12CREATE TABLE IF NOT EXISTS mystiko.accounts (
13  id TEXT,
14  amount INT,
15  bank TEXT,
16
17  PRIMARY KEY(id)
18);
19
20# bootstramp sample data
21INSERT INTO mystiko.accounts (id, amount, bank) VALUES ('0001', 1000, 'boc');
22INSERT INTO mystiko.accounts (id, amount, bank) VALUES ('0002', 2000, 'boc');
23INSERT INTO mystiko.accounts (id, amount, bank) VALUES ('0003', 3000, 'boc');
24---
25---