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