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