GitBucket
Pull requests
Issues
Snippets
Sign in
db2021
/
test_table.cql
Fork
0
Created at Fri Oct 29 16:09:09 JST 2021
Download ZIP
HTTP
Embed
Embed this snippet in your website.
HTTP
Clone with Git using the repository's web address.
Code
Revision
Forks
takane
revised this
on 30 Oct 2021
ddda574
test_table.cql
CREATE TABLE odordb.test_table ( id int PRIMARY KEY, exp map<text,double> ); INSERT INTO odordb.test_table JSON '{"id":1, "exp": { "EDIBLE": 10.5, "BAKERY": 0.0, "SWEET": 0.0, "FRUIT": 0.0, "FISH": 0.0, "GARLIC": 0.0, "SPICES": 0.0, "COLD": 0.0, "SOUR": 50.0, "BURNT": 0.0, "ACID" : 0.0, "WARM": 0.0, "MUSKY": 0.0, "SWEATY" : 0.0, "AMMONIA/URINOUS": 30.0, "DECAYED": 0.0, "WOOD": 0.0, "GRASS": 0.0, "FLOWER": 0.0, "CHEMICAL": 0.0 } }';
CREATE TABLE odordb.test_table ( id int PRIMARY KEY, exp map<text,double> ); INSERT INTO odordb.test_table JSON '{"id":1, "exp": { "EDIBLE": 10.5, "BAKERY": 0.0, "SWEET": 0.0, "FRUIT": 0.0, "FISH": 0.0, "GARLIC": 0.0, "SPICES": 0.0, "COLD": 0.0, "SOUR": 50.0, "BURNT": 0.0, "ACID" : 0.0, "WARM": 0.0, "MUSKY": 0.0, "SWEATY" : 0.0, "AMMONIA_URINOUS": 30.0, "DECAYED": 0.0, "WOOD": 0.0, "GRASS": 0.0, "FLOWER": 0.0, "CHEMICAL": 0.0 } }';
takane
revised this
on 29 Oct 2021
No changes.
9539f1f
takane
revised this
on 29 Oct 2021
No changes.
be831e0
takane
revised this
on 29 Oct 2021
3905c2e
test_table.cql
CREATE TABLE odordb.test_table ( id int PRIMARY KEY, exp map<text,double> ); INSERT INTO odordb.test_table JSON '{"id":1, "exp": { "EDIBLE": 10.5, "BAKERY": 0.0, "SWEET": 0.0, "FRUIT": 0.0, "FISH": 0.0, "GARLIC": 0.0, "SPICES": 0.0, "COLD": 0.0, "SOUR": 50.0, "BURNT": 0.0, "ACID" : 0.0, "WARM": 0.0, "MUSKY": 0.0, "SWEATY" : 0.0, "AMMONIA_URINOUS": 30.0, "DECAYED": 0.0, "WOOD": 0.0, "GRASS": 0.0, "FLOWER": 0.0, "CHEMICAL": 0.0 } }';