Skip to content

Instantly share code, notes, and snippets.

@tzach

tzach/data.cql

Created May 30, 2018 05:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tzach/581c4f835bcb881dc98d65712d31726f to your computer and use it in GitHub Desktop.
Save tzach/581c4f835bcb881dc98d65712d31726f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
data.cql
CREATE KEYSPACE IF NOT EXISTS mykeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
USE mykeyspace;
CREATE TABLE IF NOT EXISTS air_quality_data (sensor_id text,time timestamp,location text, co_ppm int,PRIMARY KEY (sensor_id, time));
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-05 07:01:00', 'ISR', 17);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-06 07:02:01', 'ISR', 18);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-07 07:03:02', 'ISR', 19);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-08 07:04:03', 'ISR', 20);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-09 07:05:04', 'ISR', 30);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-10 07:06:04', 'ISR', 31);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-11 07:07:10', 'ISR', 20);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-12 07:01:00', 'ISR', 17);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-13 07:02:01', 'ISR', 18);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-14 07:03:02', 'ISR', 19);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-15 07:04:03', 'ISR', 25);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-16 07:05:04', 'ISR', 30);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-17 07:06:04', 'ISR', 31);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-18 07:07:10', 'ISR', 25);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-19 07:01:00', 'ISR', 17);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-20 07:02:01', 'ISR', 18);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-21 07:03:02', 'ISR', 15);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-22 07:04:03', 'ISR', 20);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-23 07:05:04', 'ISR', 30);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-24 07:06:04', 'ISR', 31);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-25 07:07:10', 'ISR', 20);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-26 07:01:00', 'ISR', 27);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-27 07:02:01', 'ISR', 14);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-28 07:03:02', 'ISR', 29);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-29 07:04:03', 'ISR', 20);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-30 07:05:04', 'ISR', 11);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-05 07:01:00', 'USA', 30);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-06 07:02:01', 'USA', 31);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-07 07:03:02', 'USA', 32);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-08 07:04:03', 'USA', 44);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-09 07:05:04', 'USA', 70);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-10 07:06:10', 'USA', 80);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-11 07:07:11', 'USA', 90);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-12 07:01:00', 'USA', 37);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-13 07:02:01', 'USA', 38);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-14 07:03:02', 'USA', 32);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-15 07:04:03', 'USA', 35);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-16 07:05:04', 'USA', 42);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-17 07:06:04', 'USA', 41);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-18 07:07:10', 'USA', 35);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-19 07:01:00', 'USA', 47);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-20 07:02:01', 'USA', 42);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-21 07:03:02', 'USA', 35);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-22 07:04:03', 'USA', 40);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-23 07:05:04', 'USA', 33);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-24 07:06:04', 'USA', 41);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-25 07:07:10', 'USA', 30);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-26 07:01:00', 'USA', 44);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-27 07:02:01', 'USA', 34);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-28 07:03:02', 'USA', 39);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-29 07:04:03', 'USA', 44);
INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-30 07:05:04', 'USA', 34);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment