CREATE KEYSPACE IF NOT EXISTS insulin_pump WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 }; USE insulin_pump; CREATE TABLE insulin_level ( insulin_pump_id text, event_time timestamp, insulin_level_mcU_ml int, PRIMARY KEY (insulin_pump_id,event_time) ); INSERT INTO insulin_level(insulin_pump_id,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-01 09:01:00','5 mcU/ml'); INSERT INTO insulin_level(insulin_pump_id,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-01 09:02:00','6 mcU/ml'); INSERT INTO insulin_level(insulin_pump_id,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-01 09:03:00','6 mcU/ml'); INSERT INTO insulin_level(insulin_pump_id,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-01 09:04:00','7 mcU/ml'); CREATE TABLE insulin_level_by_day ( insulin_pump_id text, date text, event_time timestamp, insulin_level_mcU_ml int, PRIMARY KEY ((insulin_pump_id,date),event_time) ); INSERT INTO insulin_level_by_day(insulin_pump_id,date,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-03','2016-02-03 09:01:00','9 mcU/ml'); INSERT INTO insulin_level_by_day(insulin_pump_id,date,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-03','2016-02-03 09:02:00','10 mcU/ml'); INSERT INTO insulin_level_by_day(insulin_pump_id,date,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-04','2016-02-04 09:01:00','11 mcU/ml'); INSERT INTO insulin_level_by_day(insulin_pump_id,date,event_time,insulin_level_mcU_ml) VALUES ('0908070605','2016-02-04','2016-02-04 09:02:00','11 mcU/ml');