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
  }
}';