@db2021 db2021 / insert_json.cql
Created at Mon Jul 19 17:47:24 JST 2021
CQL で JSON形式のデータをINSERTする例
insert_json.cql
Raw
CREATE TABLE my_status.user_status_updates_by_datetime (
  username text, 
  status_date date, 
  status_time time, 
  body text, 
  PRIMARY KEY (username, status_date, status_time) );

INSERT INTO "user_status_updates_by_datetime"
JSON '{"username": "alice", "status_date": "2016-11-24", "status_time": "13:35:20.123456", "body": "Alice Update 7"}';
@takane takane commented on 19 Jul 2021

上のような感じで TABLE内のカラムと値をJSON形式のペアで指定できる