TRUNC in N1QL Delete from Bucketname

SQL++
1

I have the problem that I want to erase the entire database to load it again, for that I run the DELETE FROM bucketname command but I have the problem it takes more than an hour to make the whole process and at 10 minutes the execution is canceled by timeout.

I want this to work like this for normal queries but not for Delete.

I want to do something with a trunc based on relational databases.

2

@nelsonxx1 ,

If need to delete all the documents in bucket use Flush described in the following link via UI.

https://docs.couchbase.com/server/current/manage/manage-buckets/flush-bucket.html

1 Like