Issues in Merging buckets

Bucket-1:
Document Key: 7777
JsonArrayDocument Content:
[
{
“fruitName”: “Apple”,
“VegetableName”: “onion”,
“SerialNo”: 1111
},
{
“fruitName”: “Mango”,
“VegetableName”: “Carrot”,
“SerialNo”: 2222
}
]

Bucket-2:
Document Key: 7777
JsonArrayDocument Content:
[
{
“fruitName”: “Apple”,
“VegetableName”: “onion”,
“Seller”: “Walmart”,
“SerialNo”: 1111
},
{
“fruitName”: “Pomegranate”,
“VegetableName”: “Beetroot”,
“SerialNo”: 3333
}
]

I want to merge the content from bucket-2 into bucket-1 based on the condition If document Key matches, and then update the document in bucket-1 so that it looks like this as below, after the merge
Note: if the “SerialNo” matches (in this case “SerialNo”: 1111) between the compared documents then that specific Array element in bucket-1 gets updated with Array element from bucket-2

Final Expected JsonAarray Document:

Document Key: 7777
JsonArrayDocument Content:
[
{
“fruitName”: “Apple”,
“VegetableName”: “onion”,
“Seller”: “Walmart”,
“SerialNo”: 1111
},
{
“fruitName”: “Mango”,
“VegetableName”: “Carrot”,
“SerialNo”: 2222
},
{
“fruitName”: “Pomegranate”,
“VegetableName”: “Beetroot”,
“SerialNo”: 3333
}
]

I am using this query =>
MERGE INTO bucket-1 AS t USING bucket-2 AS s
ON KEY META(s).id
WHEN MATCHED
THEN UPDATE SET t = ARRAY_CONCAT(t, ARRAY v FOR v IN s
WHEN v NOT IN t)
WHEN NOT MATCHED THEN INSERT s

but it is just appending everything from bucket-2 to bucket-1 as below, if the document Key matches and finally it looks like this
[
{
“fruitName”: “Apple”,
“VegetableName”: “onion”,
“SerialNo”: 1111
},
{
“fruitName”: “Mango”,
“VegetableName”: “Carrot”,
“SerialNo”: 2222
},
{
“fruitName”: “Apple”,
“VegetableName”: “onion”,
“Seller”: “Walmart”,
“SerialNo”: 1111
},
{
“fruitName”: “Mango”,
“VegetableName”: “Carrot”,
“SerialNo”: 2222
},
{
“fruitName”: “Pomegranate”,
“VegetableName”: “Beetroot”,
“SerialNo”: 3333
}
]

Any help is appreciated please

Use ANSI MERGE https://blog.couchbase.com/ansi-join-enhancements-and-ansi-merge/