Couchbase : How to Delete Multiple Documents By Using Document ID pattern

1
votes

I am new to Couchbase database.

I have populated a bucket with 10,000 documents and I want to remove these documents using document Id pattern by using N1Ql delete query. For example the keys are like :ao.sl3:eid:89049032000001000000000016677381. So I want to use a pattern , something like ':ao.sl3:eid%' to delete all the documents.

On Couchbase Web UI, my document looks like below image - enter image description here

I want to use CouchBase web UI query editor to delete the documents.

Thanks

2
couchbasen1ql

2 Answers

2
votes

You will need a primary index to do this, but you can simply use the LIKE operator:

DELETE
FROM mybucketname
WHERE META().id LIKE ':ao.sl3:eid%'

Some things to keep in mind:

  • A primary index is a very dangerous thing to have in production. If this is a one-time thing, make sure to remove that primary index after your DELETE has run.
  • If this is something you will be doing in production on a regular basis, you may want to consider an alternate approach. Depending on your use case, you may want to look at TTL, N1QL paging, eventing, or an alternate data model that can use a more efficient index.
0
votes

It has been a few years, but I am just following up any any loose ends, as Matthew Groves indicated you could use the Couchbase Eventing service.

The function to do what you want is quite trivial 4 lines (8 if you count comments).

// example the keys are like :ao.sl3:eid:89049032000001000000000016677381
// delete any key starting with a pattern like ":ao.sl3:eid:"
// make a binding of a bucket alias called src_bkt in read+write mode 
// then deploy with a Feed Boundary of Everything.
function OnUpdate(doc, meta) {
    if (!meta.id.startsWith(':ao.sl3:eid:')) return;
    delete src_bkt[meta.id];
}

For more information on Couchbase Eventing refer to eventing-overview and eventing-examples