資料庫操作工具 (cqlsh)

主控畫面：

Documented shell commands: =========================== CAPTURE CLS COPY DESCRIBE EXPAND LOGIN SERIAL SOURCE UNICODE CLEAR CONSISTENCY DESC EXIT HELP PAGING SHOW TRACING CQL help topics: ================ AGGREGATES CREATE_KEYSPACE DROP_TRIGGER TEXT ALTER_KEYSPACE CREATE_MATERIALIZED_VIEW DROP_TYPE TIME ALTER_MATERIALIZED_VIEW CREATE_ROLE DROP_USER TIMESTAMP ALTER_TABLE CREATE_TABLE FUNCTIONS TRUNCATE ALTER_TYPE CREATE_TRIGGER GRANT TYPES ALTER_USER CREATE_TYPE INSERT UPDATE APPLY CREATE_USER INSERT_JSON USE ASCII DATE INT UUID BATCH DELETE JSON BEGIN DROP_AGGREGATE KEYWORDS BLOB DROP_COLUMNFAMILY LIST_PERMISSIONS BOOLEAN DROP_FUNCTION LIST_ROLES COUNTER DROP_INDEX LIST_USERS CREATE_AGGREGATE DROP_KEYSPACE PERMISSIONS CREATE_COLUMNFAMILY DROP_MATERIALIZED_VIEW REVOKE CREATE_FUNCTION DROP_ROLE SELECT CREATE_INDEX DROP_TABLE SELECT_JSON

建立資料庫：

CREATE KEYSPACE emprogria WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 3};
DESCRIBE keyspaces;

建立資料表格：

USE emprogria;
1. CREATE TABLE stock_history(histid frozen > PRIMARY KEY, quote_open float, quote_close float, quote_high float, quote_low float, quote_vol int);
DESCRIBE stock_history;
1. CREATE TABLE emprogria.stock_history ( histid frozen> PRIMARY KEY, quote_close float, quote_high float, quote_low float, quote_open float, quote_vol int ) WITH bloom_filter_fp_chance = 0.01 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'} AND comment = '' AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
2. 'max_threshold': '32', 'min_threshold': '4'} AND compression = {'chunk_length_in_kb': '64',
3. 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'} AND crc_check_chance = 1.0 AND dclocal_read_repair_chance = 0.1 AND default_time_to_live = 0 AND gc_grace_seconds = 864000 AND max_index_interval = 2048 AND memtable_flush_period_in_ms = 0 AND min_index_interval = 128 AND read_repair_chance = 0.0 AND speculative_retry = '99PERCENTILE';

新增資料：

INSERT INTO emprogria.stock_history(histid, quote_open, quote_close, quote_high, quote_low, quote_vol)
VALUES (('IBM', '2016-10-12'), 150.0, 150.0, 150.0, 150.0, 20000);

SELECT * FROM emprogria.stock_history;
1. histid | quote_close | quote_high | quote_low | quote_open | quote_vol -----------------------+-------------+------------+-----------+------------+----------- ('IBM', '2016-10-12') | 150 | 150 | 150 | 150 | 20000

更新資料：

UPDATE emprogria.stock_history SET quote_open=250.50,quote_close=200.50 WHERE histid=('IBM', '2016-10-12');

SELECT * FROM emprogria.stock_history;
1. histid | quote_close | quote_high | quote_low | quote_open | quote_vol -----------------------+-------------+------------+-----------+------------+----------- ('IBM', '2016-10-12') | 200.5 | 150 | 150 | 250.5 | 20000

刪除資料：

DELETE FROM emprogria.stock_history WHERE histid=('IBM', '2016-10-12');

SELECT * FROM emprogria.stock_history;
1. histid | quote_close | quote_high | quote_low | quote_open | quote_vol -----------------------+-------------+------------+-----------+------------+----------- (0 rows)