· 8 years ago · Feb 09, 2018, 04:32 PM
1CREATE TABLE IF NOT EXISTS mytable (
2myid text,
3mytype text,
4mymodels set<text>,
5myname,
6created bigint,
7PRIMARY KEY (myid, mytype,)
8) WITH CLUSTERING ORDER BY (mytype ASC);
9
10mytype|mymodels|myname
11"type1"|[model1,model2,model3]|"name1"
12"type2"|[model1,model4,model5]|"name2"
13
14myid|mytype|mymodels|myname|created
15uuid()|"type1"|[model1,model2,model3]|"name1"|blobAsBigint(timestampAsBlob(now()))
16uuid()|"type2"|[model1,model4,model5]|"name2"|blobAsBigint(timestampAsBlob(now()))