cqlsh からスクリプトファイルを実行する

• 実行するスクリプトファイルの内容

$ cat insert_small.cql
CONSISTENCY LOCAL_QUORUM ;
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (001, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (002, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (003, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (004, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (005, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (006, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (007, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (008, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (009, '2024-01-10 17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (010, '2024-01-10 17:30:00');

• 実行する

$ cqlsh cassandra.ap-northeast-1.amazonaws.com 9142 --ssl -f insert_small.cql
Consistency level set to LOCAL_QUORUM.

参考

• cqlsh（起動オプション）