Update ARRAY IN ARRAY BigQuery (GA4 Data)

Question

我想用另一个表中的值来更新数组中的值。

table1:

tbody> <<tr>

event_params.key	event_params.value.string_value
国家	我们

我还看到了这段代码:

UPDATE `project.dataset.your_table` t
SET hits = 
ARRAY(
SELECT AS STRUCT * REPLACE(
ARRAY(
SELECT AS STRUCT product.* REPLACE(
CASE WHEN map.raw_name = product.productCategory THEN category 
ELSE productCategoryAttribute END AS productCategoryAttribute)
FROM UNNEST(product) product
LEFT JOIN UNNEST(agg_map.map) map 
ON map.raw_name = product.productCategory
) AS product)
FROM UNNEST(hits) hit
) 
FROM (SELECT ARRAY_AGG(row) map FROM `project.dataset.map` row) agg_map 
WHERE TRUE  

BigQuery UPDATE嵌套数组字段但是我不能实现它。