Insert into from another bucket loads only one record

SQL++
,
1

Hi,

I am trying to insert data from a diff bucket to another bucket, however it loads only the first record, below is the query used,

insert into bucket1 (KEY ‘newkey’,VALUE user_record)
select user_record from diffbucket as user_record where type=‘xyz’;

Actual data in the SELECT query: select user_record from diffbucket as user_record where type=‘xyz’;

[
{
“user_record”: {
“value”: “abc”
}
},
{
“user_record”: {
“value”: “xyz”
}
}
]

Data inserted is just one and the other record is not loaded, any insights on how the query should be tweaked is appreciated, Thanks

{
“value”: “abc”
}