SELECT *
FROM `beer-sample`
WHERE brewery_id IS NOT MISSING AND type="beer"
LIMIT 1;
UPSERT INTO product (KEY, VALUE) VALUES (
"odwalla-juice1", {
"productId": "odwalla-juice1",
"unitPrice": 5.40,
"type": "product",
"color":"red"
}
) RETURNING *;
INFER `beer-sample` WITH {
"sample_size": 10000,
"num_sample_values": 1,
"similarity_metric": 0.0
};