如何用N1QL删除Couchbase空内容文档或填充缺失内容？

Hey there! Let's work through this problem together—typos in N1QL queries happen to everyone, especially when you're still getting the hang of Couchbase and NoSQL. Let's cover two straightforward solutions to fix your issue:

Option 1: Delete all documents with null content #

If you want to clean up the faulty documents first, you can use a DELETE statement to target only the entries in Writer_DB where the content (_v) is null:

DELETE FROM `Writer_DB` WHERE _v IS NULL;

Before running this, it's a good idea to verify which documents will be deleted by running a test SELECT—this helps you avoid accidental deletions:

SELECT META().id, _v FROM `Writer_DB` WHERE _v IS NULL;

Once you confirm those are the bad entries, execute the DELETE. After that, you can run your corrected INSERT query without hitting duplicate ID errors.

Option 2: Update null documents to fill in the correct content (no deletion needed) #

A more efficient approach is to directly fix the existing null documents by pulling the correct content from Sam_DB via an UPDATE with a join. This way, you don't have to delete and reinsert—you just patch the faulty entries in place:

UPDATE `Writer_DB` w
SET w._v = s.v
FROM `Sam_DB` s
WHERE META(w).id = META(s).id AND w._v IS NULL;

This query matches documents in Writer_DB and Sam_DB by their unique ID (using META().id), then updates the null _v field in Writer_DB with the full document content from Sam_DB.

Quick note on your corrected INSERT query #

Just to make sure you don't hit this issue again, here's the fixed version of your original INSERT (since you mentioned swapping _v for v by mistake):

INSERT INTO `Writer_DB` (KEY _k, VALUE _v) 
SELECT META().id _k, v AS _v FROM `Sam_DB` v;

This ensures you're taking the full document from Sam_DB (aliased as v) and assigning it to the _v value field in Writer_DB.

内容的提问来源于stack exchange，提问作者IBot