aboutsummaryrefslogtreecommitdiff
path: root/README.md
diff options
context:
space:
mode:
Diffstat (limited to 'README.md')
-rw-r--r--README.md16
1 files changed, 16 insertions, 0 deletions
diff --git a/README.md b/README.md
new file mode 100644
index 0000000..6ce8d37
--- /dev/null
+++ b/README.md
@@ -0,0 +1,16 @@
+# Create Schema
+
+ $ bin/cqlsh
+ cqlsh> create keyspace soil_moisture WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
+ cqlsh> use soil_moisture;
+ cqlsh:soil_moisture>
+ create table sm_by_day(
+ device text,
+ day text,
+ timestamp timestamp,
+ sensors list<frozen<tuple<int, int>>>,
+ primary key(
+ (device, day),
+ timestamp
+ )
+ );