default.txt 402 B

12345678910111213141516171819
  1. SELECT *
  2. FROM `beer-sample`
  3. WHERE brewery_id IS NOT MISSING AND type="beer"
  4. LIMIT 1;
  5. UPSERT INTO product (KEY, VALUE) VALUES (
  6. "odwalla-juice1", {
  7. "productId": "odwalla-juice1",
  8. "unitPrice": 5.40,
  9. "type": "product",
  10. "color":"red"
  11. }
  12. ) RETURNING *;
  13. INFER `beer-sample` WITH {
  14. "sample_size": 10000,
  15. "num_sample_values": 1,
  16. "similarity_metric": 0.0
  17. };