bzUFPJef

1CREATE TABLE IF NOT EXISTS test (
2   id uuid,
3   tpe text,
4   data map<text, text>,
5   PRIMARY KEY (id, tpe)
6 ) WITH
7 compaction = {'class': 'LeveledCompactionStrategy'}
8 AND
9 compression = { 'sstable_compression' : 'SnappyCompressor' };
10	
11UPDATE test SET data[?]=? WHERE id=? AND tpe=?
12UPDATE test SET data[?]=? WHERE id=? AND tpe=?
13SELECT * FROM test WHERE id = ? AND tpe = ?
14	
15INSERT INTO test (id,tpe,data) VALUES (?,?,?) IF NOT EXISTS
16UPDATE test SET data[?]=? WHERE id=? AND tpe=?
17SELECT * FROM test WHERE id = ? AND tpe = ?
18	
19INSERT INTO test (id,tpe,data) VALUES (?,?,?) IF NOT EXISTS
20DELETE FROM test WHERE id=? AND tpe=?
21SELECT * FROM test WHERE id = ? AND tpe = ?
22	
23INSERT INTO test (id,tpe,data) VALUES (?,?,?) IF NOT EXISTS
24TRUNCATE test
25SELECT * FROM test WHERE id = ? AND tpe = ?