We are Using the Couchbase community Edition 5.X ,
We have the the volume of 40M records in the bucket and we wanted delete the records which id starts with AAA.
we could not able to do this with NQ1L query from admin portal.
we have 5 nodes, in which 3 are query + data +index 2 are only data nodes.
the query is like delete from bucket_name where meta().id like ‘AAA%’;
Can you provide any suggestions.