I have a situation in my production couchbase cluster having version 6.0.1.
I have a doc_type = “eventing_history” which is having 4 years customer event data. Size of this doc_type is 2TB and docs in this doc_type is approx 1 Billion.
Now I want to delete the data for this doc_type and leave only current month data.
I tried n1ql delete syntax but it was getting time out after some time. and I don’t think that N1QL can delete 1 billion docs.
Please suggest correct approach to delete 1 billion docs having same key prefix.