清空表里的所有数据
Truncate falcon_gps;
TRUNCATE accepts a single argument for the column family name, and permanently removes all data from said column family.
查询Cassandra某表里一空有多少行记录
select count(*) from falcon_gps;
批量导入数据
BEGIN BATCH USING CONSISTENCY QUORUM AND TTL 8640000 INSERT INTO users (KEY, password, name) VALUES ('user2', 'ch@ngem3b', 'second user') UPDATE users SET password = 'ps22dhds' WHERE KEY = 'user2' INSERT INTO users (KEY, password) VALUES ('user3', 'ch@ngem3c') DELETE name FROM users WHERE key = 'user2' INSERT INTO users (KEY, password, name) VALUES ('user4', 'ch@ngem3c', 'Andrew') APPLY BATCH;