While copying 15000 documents matching some condition and at the same time trying to update two attribute values using below N1QL query, I get “the query was canceled.” exception. I use .Net SDK I wanted to modify two attributes in the newly copied document (id, scenarioId) “INSERT INTO Schedules(…

The following query all matched document are inserted into new target. If required increase query timeout If one time u can use Query Work Bench INSERT INTO Schedules(KEY x.id, VALUE x) SELECT OBJECT_CONCAT(s, {"id":UUID(), "scenarioId": $newScenarioId}) AS x FROM Schedules AS s WHERE…

Copy documents within same bucket matching condition

SQL++

Subasish April 23, 2022, 1:01pm 7

My bad, newScenarioId is a new Guid() passed as parameter to the function

Topic		Replies	Views
Fastest way to copy document and modify content before saving SQL++ n1ql , dot-net	2	1303	April 19, 2022
Bulk copy of existing documents SQL++ dot-net , eventing	6	1741	August 10, 2021
N1QL Query for copying data from one bucket to another SQL++ query	2	1881	January 6, 2022
How to copy a key value from one doc to other doc from same bucket Couchbase Server	1	1086	August 7, 2019
Converting documents using N1QL SQL++	7	786	February 28, 2019

Copy documents within same bucket matching condition

Related topics