takane revised this on 29 Oct 2021

insert_json.cql

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"}'; 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 revised this on 19 Jul 2021

insert_json.cql
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"}';