{"id":2022,"date":"2015-11-20T14:55:00","date_gmt":"2015-11-20T14:55:00","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2022"},"modified":"2023-06-27T07:14:32","modified_gmt":"2023-06-27T14:14:32","slug":"efficiently-querying-for-deleted-documents-with-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/efficiently-querying-for-deleted-documents-with-n1ql\/","title":{"rendered":"N1QL\uc758 MISSING\uc73c\ub85c \uc0ad\uc81c\ub41c \ubb38\uc11c\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \ucffc\ub9ac\ud558\uae30"},"content":{"rendered":"

\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9cc\ub4e4\ub2e4 \ubcf4\uba74 \uc0ac\uc6a9\uc790\uac00 \uc77c\ubd80 \ucf58\ud150\uce20\ub97c \uc0ad\uc81c\ud558\uace0 \uc2f6\uc9c0\ub9cc \ub370\uc774\ud130\uac00 \uc774\uc804\uc5d0 \uc874\uc7ac\ud588\uc5c8\ub2e4\ub294 \uc0ac\uc2e4\uc744 \uc54c\uc544\uc57c \ud558\ub294 \uc0c1\ud669\uc774 \uc885\uc885 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n

\uba54\uc2dc\uc9d5 \uc571\uc744 \uad6c\ucd95\ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubd05\uc2dc\ub2e4. \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc0ad\uc81c\ub41c \ub300\ud654\ub97c \ubcf5\uc6d0\ud560 \uc218 \uc788\ub294 \uae30\ud68c\ub97c \uc8fc\uace0 \uc2f6\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub530\ub77c\uc11c \ub204\uad70\uac00 \ub300\ud654\ub97c \uc0ad\uc81c\ud558\ub824\uace0 \ud560 \ub54c \ub2e8\uc21c\ud788 Couchbase\uc5d0\uc11c \ubb38\uc11c\ub97c \uc0ad\uc81c\ud558\ub294 \uac83 \uc678\uc5d0 \ub2e4\ub978 \uc870\uce58\ub97c \ucde8\ud574\uc57c \ud569\ub2c8\ub2e4. \ub300\uc2e0 JSON \ubcf8\ubb38\uc5d0\uc11c \ud574\ub2f9 \ubb38\uc11c\ub97c \ube44\ub77c\uc774\ube0c \ubb38\uc11c\ub85c \uc2dd\ubcc4\ud558\ub294 \ud50c\ub798\uadf8\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n

{\r\n    \"deleted\": true\r\n}<\/pre>\n
\uadf8 \uc544\ub798\uc5d0 GSI \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\uc5ec \ubaa8\ub4e0 \ud56d\ubaa9\uc5d0 \ud6a8\uc728\uc801\uc73c\ub85c \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0\uc0ad\uc81c\ub428<\/em>\u00a0\ub300\ud654:<\/p>\n
CREATE INDEX deletedmsgs ON `conversations`(deleted);<\/pre>\n
\uadf8\ub7f0 \ub2e4\uc74c \uc571\uc758 UI\uc5d0\uc11c \uc0ad\uc81c\ub41c \ub300\ud654\uc758 \ubcf4\uae30\ub97c \ucc44\uc6b0\ub824\uba74 N1QL \ucffc\ub9ac<\/a> \uc608\ub97c \ub4e4\uc5b4<\/p>\n
SELECT * FROM `conversations` WHERE deleted = true;<\/pre>\n
\uc9c0\uae08\uae4c\uc9c0\ub294 \ubaa8\ub4e0 \uac83\uc774 \ub9e4\uc6b0 \ubd84\uba85\ud574 \ubcf4\uc785\ub2c8\ub2e4.<\/p>\n
\uae30\uc874 \ub370\uc774\ud130 \uc9d1\ud569\uc5d0 \ucd94\uac00\ud558\uae30<\/h2>\n
\uc774\uc81c \ub9c9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \uc774 \uae30\ub2a5\uc744 \ub3c4\uc785\ud55c \uacbd\uc6b0\ub77c\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694? \uc774\ubbf8 \uc218\ucc9c \uac1c\uc758 \ub300\ud654\uac00 \uc788\ub294\ub370 \uadf8 \ub300\ud654\ub4e4\uc758 \uae30\ubcf8 \ubb38\uc11c\uc5d0\ub294\u00a0\uc0ad\uc81c\ub428<\/em>\u00a0\ud50c\ub798\uadf8.<\/p>\n
\uc774\ubc88 \uae30\ud68c\uc5d0 N1QL\uc758\u00a0\ub204\ub77d\ub428<\/em>. \ub9de\uc9c0\ub9cc \uc81c\uac00 \uc81c\uc548\ud558\ub294 \uac83\uacfc\ub294 \uc57d\uac04 \ub2e4\ub978 \uc0dd\uac01\uc744 \ud558\uace0 \uacc4\uc2e4 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub2f9\uc2e0\u00a0coulc<\/em>\u00a0\uacc4\uc815\uc774 \uc5c6\ub294 \ubb38\uc11c\uc5d0 \ub300\ud55c\u00a0\uc0ad\uc81c\ub428<\/em>\u00a0\ud50c\ub798\uadf8\ub97c \ubcc0\uacbd\ud558\uc5ec N1QL \ucffc\ub9ac\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \ubcc0\uacbd\ud569\ub2c8\ub2e4:<\/p>\n
SELECT * FROM `conversations` WHERE deleted = true OR deleted IS MISSING;<\/pre>\n
\uc880 \ub354 \ud604\uc2e4\uc801\uc73c\ub85c \ud45c\ud604\ud558\uae30 \uc704\ud574 \uad00\ub828\uc790\ub97c \uae30\uc900\uc73c\ub85c \ucffc\ub9ac\ub97c \ud544\ud130\ub9c1\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
SELECT * FROM `conversations` WHERE sender = user123 AND deleted = true OR deleted IS MISSING;<\/pre>\n
\uc774\ub807\uac8c \ud558\uba74 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc9c0\ub9cc \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc740 \uc544\ub2d9\ub2c8\ub2e4.<\/p>\n
OR \uc0c1\ud669\uc5d0\uc11c N1QL\uc758 MISSING \ud0a4\uc6cc\ub4dc\ub97c \ub3c4\uc785\ud55c \ub2e4\uc74c, N1QL\uc774 \uc804\uccb4 \ubb38\uc11c \uc2a4\uce94\uc744 \uc2dc\uc791\ud558\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4. \uc6b0\ub9ac\uc758 \ucffc\ub9ac\ub294 \ubaa8\ub4e0 \ubb38\uc11c\uc5d0 \uc0ad\uc81c\ub41c JSON \ud0a4\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud558\ub3c4\ub85d N1QL\uc5d0 \uc694\uccad\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc11c\uc5d0\ub9cc \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uc0ad\uc81c\ub428<\/em>\u00a0\ud0a4\uac00 \uc5c6\ub294 \ubb38\uc11c\uc5d0\ub294 \uc0c9\uc778\uc744 \uc0dd\uc131\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub300\uc2e0 \uc774 \uacbd\uc6b0\uc5d0\ub294 \ub204\ub77d\ub41c \ubaa8\ub4e0 \ubb38\uc11c\ub97c \ubc18\ud658\ud558\ub294 \uc77c\ud68c\uc131 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.\u00a0\uc0ad\uc81c\ub428<\/em>. \uadf8\ub7f0 \ub2e4\uc74c \uac01 \ud56d\ubaa9\uc744 \uac80\ud1a0\ud558\uc5ec \ub2e4\uc74c\uc744 \ud3ec\ud568\ud558\ub3c4\ub85d \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0\uc0ad\uc81c\ub428 = \uac70\uc9d3<\/em> \uc774\uc81c \ubaa8\ub4e0 \ubb38\uc11c\uac00 \ud6a8\uc728\uc801\uc778 \uc778\ub371\uc2a4\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/p>\n
\ucffc\ub9ac\uac00 \uc870\uae08 \ub354 \uc624\ub798 \uac78\ub9ac\ub354\ub77c\ub3c4 \uad1c\ucc2e\uc2b5\ub2c8\ub2e4. \ubc31\uadf8\ub77c\uc6b4\ub4dc \ub370\uc774\ud130 \uad00\ub9ac \uc791\uc5c5\uc758 \uc77c\ubd80\ub85c \uc2e4\ud589\ub418\ubbc0\ub85c \uc0ac\uc6a9\uc790 \uc911 \ub204\uad6c\ub3c4 \uc774\ub97c \uc778\uc9c0\ud558\uc9c0 \ubabb\ud560 \uac83\uc785\ub2c8\ub2e4. \ubaa8\ub4e0 \ubb38\uc11c\uc5d0 \ub300\ud574 \uc774 \uc791\uc5c5\uc744 \uc2e4\ud589\ud558\uace0 \ub098\uba74 \ub354 \uc774\uc0c1 \ub204\ub77d<\/em> \ub97c \uc0ac\uc6a9\uc790 \ub300\uba74 \ucffc\ub9ac\uc5d0 \ub123\uc73c\uba74 \ubaa8\ub4e0 \ub300\ud654 \ubb38\uc11c\uac00 \ub2e4\uc74c \uc911 \ud558\ub098\ub77c\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.\u00a0\uc0ad\uc81c\ub428: true\u00a0<\/em>\ub610\ub294\u00a0\uc0ad\uc81c\ub428: \uac70\uc9d3<\/em>.<\/p>\n
\uc2a4\ud0a4\ub9c8 \ubc84\uc804 \ub300\uc2e0 \uc0ac\uc6a9<\/h3>\n
\uc2a4\ud0a4\ub9c8 \ubc84\uc804 \uad00\ub9ac\ub97c \uc720\uc9c0\ud558\uba74 MISSING\uc744 \uc544\uc608 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
{\r\n   \"schema\": \"1.2.3\"\r\n}<\/pre>\n
\uc0c8\ub85c\uc6b4 \uc2a4\ud0a4\ub9c8 \ubc84\uc804\uc774 \ub2e4\uc74c\uacfc \uac19\uc740 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uba74\u00a0\uc0ad\uc81c\ub428<\/em>\u00a0\ud50c\ub798\uadf8\uac00 2.0.0\uc774\uba74 \ubc31\uadf8\ub77c\uc6b4\ub4dc \uad00\ub9ac\uc790 \uc791\uc5c5\uc740 \uc2a4\ud0a4\ub9c8 \ubc84\uc804\uc774 2.0.0\ubcf4\ub2e4 \uc624\ub798\ub41c \ubaa8\ub4e0 \ubb38\uc11c\ub97c \ucc3e\uc740 \ub2e4\uc74c \uc5c5\uadf8\ub808\uc774\ub4dc \ud504\ub85c\uc138\uc2a4\ub97c \ud1b5\ud574 \uc2e4\ud589\ud560 \uc218 \uc788\uc73c\uba70, \uadf8 \uc911 \uc77c\ubd80\uac00\u00a0\uc0ad\uc81c\ub428<\/em>\u00a0\ud50c\ub798\uadf8.<\/p>","protected":false},"excerpt":{"rendered":"
When you’re building an application, a situation often comes up where your users want to delete some content but\u00a0you still need to know that the data once existed. Let’s say you’re building a messaging app. You might want to give […]<\/p>","protected":false},"author":18,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"ppma_author":[8982],"class_list":["post-2022","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"yoast_head":"\nEfficiently querying deleted documents with N1QL\u2019s MISSING<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/efficiently-querying-for-deleted-documents-with-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Efficiently querying for deleted documents with N1QL's MISSING\" \/>\n<meta property=\"og:description\" content=\"When you’re building an application, a situation often comes up where your users want to delete some content but\u00a0you still need to know that the data once existed. Let’s say you’re building a messaging app. You might want to give […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/efficiently-querying-for-deleted-documents-with-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-20T14:55:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-27T14:14:32+00:00\" \/>\n<meta name=\"author\" content=\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/\"},\"author\":{\"name\":\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/6c3060a94353df62a71d4672b3454555\"},\"headline\":\"Efficiently querying for deleted documents with N1QL’s MISSING\",\"datePublished\":\"2015-11-20T14:55:00+00:00\",\"dateModified\":\"2023-06-27T14:14:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/\"},\"wordCount\":530,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/\",\"name\":\"Efficiently querying deleted documents with N1QL\u2019s MISSING\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2015-11-20T14:55:00+00:00\",\"dateModified\":\"2023-06-27T14:14:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Efficiently querying for deleted documents with N1QL’s MISSING\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/6c3060a94353df62a71d4672b3454555\",\"name\":\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/b1bc555cd9166b46d6063003c3b92317\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g\",\"caption\":\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\"},\"description\":\"Matthew Revell is a Lead Dev Advocate, EMEA Couchbase. He developed a global strategy for putting Couchbase front in the minds of the product's developers.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/matthew-revell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Efficiently querying deleted documents with N1QL\u2019s MISSING","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/efficiently-querying-for-deleted-documents-with-n1ql\/","og_locale":"ko_KR","og_type":"article","og_title":"Efficiently querying for deleted documents with N1QL's MISSING","og_description":"When you’re building an application, a situation often comes up where your users want to delete some content but\u00a0you still need to know that the data once existed. Let’s say you’re building a messaging app. You might want to give […]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/efficiently-querying-for-deleted-documents-with-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2015-11-20T14:55:00+00:00","article_modified_time":"2023-06-27T14:14:32+00:00","author":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","Est. reading time":"3\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/"},"author":{"name":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/6c3060a94353df62a71d4672b3454555"},"headline":"Efficiently querying for deleted documents with N1QL’s MISSING","datePublished":"2015-11-20T14:55:00+00:00","dateModified":"2023-06-27T14:14:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/"},"wordCount":530,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Uncategorized"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/","name":"Efficiently querying deleted documents with N1QL\u2019s MISSING","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2015-11-20T14:55:00+00:00","dateModified":"2023-06-27T14:14:32+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/efficiently-querying-for-deleted-documents-with-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Efficiently querying for deleted documents with N1QL’s MISSING"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/6c3060a94353df62a71d4672b3454555","name":"Matthew Revell, \uc218\uc11d \uac1c\ubc1c\uc790 \uc639\ud638\uc790, EMEA \uc9c0\uc5ed, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/b1bc555cd9166b46d6063003c3b92317","url":"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g","caption":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase"},"description":"\ub9e4\ud29c \ub808\ubca8\uc740 EMEA \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc218\uc11d \uac1c\ubc1c\uc790 \uc639\ud638\uc790\uc785\ub2c8\ub2e4. \uadf8\ub294 \uc81c\ud488 \uac1c\ubc1c\uc790\ub4e4\uc758 \ub9c8\uc74c\uc18d\uc5d0 Couchbase\ub97c \uac01\uc778\uc2dc\ud0a4\uae30 \uc704\ud55c \uae00\ub85c\ubc8c \uc804\ub7b5\uc744 \uac1c\ubc1c\ud588\uc2b5\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/matthew-revell\/"}]}},"authors":[{"term_id":8982,"user_id":18,"is_guest":0,"slug":"matthew-revell","display_name":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g","author_category":"","last_name":"Revell","first_name":"Matthew","job_title":"","user_url":"","description":"\ub9e4\ud29c \ub808\ubca8\uc740 EMEA \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc218\uc11d \uac1c\ubc1c\uc790 \uc639\ud638\uc790\uc785\ub2c8\ub2e4. \uadf8\ub294 \uc81c\ud488 \uac1c\ubc1c\uc790\ub4e4\uc758 \ub9c8\uc74c\uc18d\uc5d0 Couchbase\ub97c \uac01\uc778\uc2dc\ud0a4\uae30 \uc704\ud55c \uae00\ub85c\ubc8c \uc804\ub7b5\uc744 \uac1c\ubc1c\ud588\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=2022"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2022\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=2022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=2022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=2022"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=2022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}