更新时间:2023-08-26 11:20:40
以下为 BigQuery Standard SQL
Below is for BigQuery Standard SQL
#standardSQL
UPDATE `project.dataset.table` t
SET weights =
ARRAY(
SELECT AS STRUCT IF(animal = 'dragon', 'cat', animal) animal, value
FROM t.weights
)
WHERE TRUE