[TIL] Learning note about Cassandra
Keyspace keyspace == database in SQL CREATE KEYSPACE KEYSPACE_NAME WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 }; then use KEYSPACE_NAME; in cqlsh before you create/alter/drop/select tables. Special Data Operation in Cassandra (Set/List/Map/Nested Type/Frozen/Tuple/JSON) Set data Table schema for set. CREATE TABLE users ( user_id text PRIMARY KEY, first_name text, last_name text, emails set<text> ); Insert data into table INSERT INTO users (user_id, first_name, last_name, emails) VALUES('frodo', 'Frodo', 'Baggins', {'[email protected]', '[email protected]'}); List data Table schema CREATE TABLE users ( user_id text PRIMARY KEY, first_name text, last_name text, top_places list<text> ); Data Insertion. INSERT INTO users (user_id, first_name, last_name, emails) VALUES('frodo', 'Frodo', 'Baggins', [ 'rivendell', 'rohan' ]); Map Data Table schema CREATE TABLE users ( user_id text PRIMARY KEY, first_name text, last_name text, todo map<timestamp, text>; ); Data Insertion. INSERT INTO users (user_id, first_name, last_name, emails) VALUES('frodo', 'Frodo', 'Baggins', { '2012-9-24' : 'enter mordor', '2014-10-2 12:00' : 'throw ring...
繼續閱讀