{"id":1255,"date":"2018-03-06T04:43:47","date_gmt":"2018-03-06T12:43:47","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/"},"modified":"2018-03-06T04:43:47","modified_gmt":"2018-03-06T12:43:47","slug":"5-common-forums-questions","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/","title":{"rendered":"The 5 Most Common Forum&#8217;s Questions"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><b>How to do \u201csomething\u201d in N1QL?<\/b><\/h3>\n\n\n\n<p><span>First of all, <\/span><span>if you are not familiar with N1QL I highly recommend you to spend a few minutes in our free N1QL training <\/span><a href=\"https:\/\/training.couchbase.com\/online\"><span>here<\/span><\/a><span>, \u00a0or just play with it <\/span><a href=\"https:\/\/query-tutorial.couchbase.com\/tutorial\/#1\"><span>here<\/span><\/a><span>.<\/span><\/p>\n\n\n\n<p><span>Second, as it is a broad question, let\u2019s go through some common scenarios:<\/span><\/p>\n\n\n\n<p>\u00a0<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><b>Select the id of a document and all its attributes:<\/b><\/h4>\n\n\n<p>[crayon lang=&#8221;default&#8221; decode=&#8221;true&#8221;]Select meta(t).id as id, t.* from `myBucket` t where type = &#8216;someType'[\/crayon]<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><\/h4>\n\n\n\n<h4 class=\"wp-block-heading\"><b>How to write a JOIN:<\/b><\/h4>\n\n\n\n<p><span>Let\u2019s query which companies fly from San Francisco airport (SFO) to anywhere in the world using the travel sample:<\/span><\/p>\n\n\n<p>[crayon lang=&#8221;default&#8221; decode=&#8221;true&#8221;]SELECT \u00a0airline.name, airline.callsign, route.destinationairport, route.stops, route.airline<br \/>\nFROM `travel-sample` route JOIN `travel-sample` airline ON KEYS route.airlineid<br \/>\nWHERE route.type = &#8220;route&#8221;<br \/>\nAND airline.type = &#8220;airline&#8221;<br \/>\nAND route.sourceairport = &#8220;SFO&#8221;<br \/>\nAND route.stops = 0<br \/>\nORDER BY airline.name[\/crayon]<\/p>\n\n\n\n<p><span>The <\/span><b><i>JOIN<\/i><\/b><span> clause looks like a standard SQL JOIN, the only difference here is the <\/span><b><i>ON KEYS <\/i><\/b><span>keyword, to read more about it <\/span><a href=\"https:\/\/dzone.com\/articles\/visually-explaining-n1ql-joins\"><span>check this article explaining visually N1QL JOINs<\/span><\/a><span>. Couchbase 5.5 will also add support to <a href=\"https:\/\/www.couchbase.com\/blog\/ansi-join-support-n1ql\/\">ANSI JOINs<\/a><\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><b>How to select items of an array:<\/b><\/h4>\n\n\n\n<p><span>Given documents like:<\/span><\/p>\n\n\n<p>[crayon lang=&#8221;js&#8221; decode=&#8221;true&#8221;]{<br \/>\n  type: \u201cperson\u201d,<br \/>\n  name: \u201cJohn\u201d,<br \/>\n  children: [<br \/>\n    {<br \/>\n      \u201cname\u201d: \u201cPedro\u201d,<br \/>\n      \u201cage\u201d: 8<br \/>\n    },<br \/>\n    {<br \/>\n       \u201cname\u201d: \u201cGeorge\u201d,<br \/>\n       \u201cage\u201d: 11<br \/>\n    }<br \/>\n  ]<br \/>\n}[\/crayon]<\/p>\n\n\n\n<p><span>If we want to select all children who are more than 10 years old, we could use the <strong>UNNEST<\/strong> keyword: <\/span><\/p>\n\n\n<p>[crayon lang=&#8221;default&#8221; decode=&#8221;true&#8221;]SELECT c.* FROM tutorial t UNNEST t.children c WHERE c.age &gt; 10[\/crayon]<\/p>\n\n\n\n<p>\u00a0<\/p>\n\n\n\n<p>\u00a0<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><b>Why my query is slow?<\/b><\/h3>\n\n\n\n<p><span>Probably your query is not hitting any indexes. You can check that by running your query with the <\/span><b><i>explain<\/i><\/b><span> keyword, as follows:<\/span><\/p>\n\n\n\n<p><span><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4724\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/explain-query-correct-1024x778-1.png\" alt=\"\" width=\"710\" height=\"540\"><\/span><\/p>\n\n\n\n<p><span>As you can see in the image above, the query is hitting the <\/span><b><i>PrimaryScan<\/i><\/b><span> which means that it is using the primary index. Creating a secondary index for it will potentially solve your problem:<\/span><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4725\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/Screen-Shot-2018-03-06-at-12.57.03-PM-1024x369-1.png\" alt=\"\" width=\"700\" height=\"252\"><\/p>\n\n\n\n<p><span>Executing the same query again will output something like:<\/span><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4726\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/Screen-Shot-2018-03-06-at-12.57.33-PM-1024x560-1.png\" alt=\"\" width=\"723\" height=\"395\"><\/p>\n\n\n\n<p><span>If your query is already hitting an index but still has a poor performance, you might want to add a more optimized index (<\/span><a href=\"https:\/\/www.couchbase.com\/forums\/t\/order-by-performance-really-slow\/13173\/20\/\"><span>like in this example<\/span><\/a><span>). If you are not familiar with <\/span><span>how to create an index<\/span><span>, <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/create-right-index-get-right-performance\/\"><span>check out this blog post<\/span><\/a><\/p>\n\n\n\n<p>\u00a0<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><b>How to paginate results in N1QL?<\/b><\/h3>\n\n\n\n<p><span>You can use <\/span><b><i>LIMIT<\/i><\/b><span> and <\/span><b><i>OFFSET<\/i><\/b><span>:<\/span><\/p>\n\n\n<p>[crayon lang=&#8221;default&#8221; decode=&#8221;true&#8221;]select * from `travel-sample` where country = &#8216;United States&#8217; OFFSET 10 LIMIT 10[\/crayon]<\/p>\n\n\n\n<p><span>Check out <\/span><a href=\"https:\/\/dzone.com\/articles\/database-pagination-using-offset-and-keyset-in-n1q\"><span>this tutorial<\/span><\/a><span> to read more about it.\u00a0<\/span><span>Additionally, if you are using Spring Data you can add a <\/span><b><i>Pageable<\/i><\/b><span> object to the end of your method definition:<\/span><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4727\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/repository-1024x203-1.png\" alt=\"\" width=\"763\" height=\"151\"><\/p>\n\n\n\n<p><span>And then, in your Service you can use the <\/span><b><i>PageRequest<\/i><\/b><span> object:<\/span><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4728\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/service-1024x263-1.png\" alt=\"\" width=\"760\" height=\"195\"><\/p>\n\n\n\n<p>\u00a0<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><b>My query has missing results\/wrong results<\/b><\/h3>\n\n\n\n<p><span>By default, Couchbase supports <\/span><i><span>read-after-writes<\/span><\/i><span> whenever you get a document by its key, but your indexes and views are updated asynchronously via Data Change Protocol (DCP). So, if you are executing a query right after a write, it might be executed before the views\/indexes had a chance to be updated.<\/span><\/p>\n\n\n\n<p><span>Couchbase is all about speed, and no one has time to wait until all indexes and views are updated to send the response back to the client that a write has been executed successfully.<\/span><\/p>\n\n\n\n<p><span>But there are few scenarios where strong consistency between writes and your queries are actually needed, for those cases you can specify via SDK that you actually want to wait until the index\/view you are using is updated:<\/span><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-4729\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/consistency-1024x107-1.png\" alt=\"\" width=\"900\" height=\"94\"><\/p>\n\n\n\n<p><span>To read more about scan consistency, please refer to the <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/learn\/services-and-indexes\/indexes\/index-replication.html\"><span>official documentation<\/span><\/a><span>.<\/span><\/p>\n\n\n\n<p><span>In my personal experience, I only scenario where I do need consistency between writes and queries is during the <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/integration-tests-couchbase-application\/\"><b><i>integration tests<\/i><\/b><\/a><span> phase, which is when you actually insert data and query it right after. <\/span><\/p>\n\n\n\n<p>\u00a0<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><b>How to Creating\/use Array Indexes.<\/b><\/h3>\n\n\n\n<p><span>This is an interesting topic, as <\/span><b><i>array indexing<\/i><\/b><span> might speed up significantly your performance. So, let\u2019s say we have the following document structure:<\/span><\/p>\n\n\n<p>[crayon lang=&#8221;default&#8221; decode=&#8221;true&#8221;]{<br \/>\n\u00a0\u00a0\u00a0&#8220;address&#8221;: &#8220;Capstone Road, ME7 3JE&#8221;,<br \/>\n\u00a0\u00a0\u00a0&#8220;alias&#8221;: null,<br \/>\n\u00a0\u00a0\u00a0&#8220;city&#8221;: &#8220;Medway&#8221;,<br \/>\n\u00a0\u00a0\u00a0&#8220;country&#8221;: &#8220;United Kingdom&#8221;,<br \/>\n\u00a0\u00a0\u00a0&#8220;description&#8221;: &#8220;40 bed summer hostel about 3 miles from Gillingham, housed in a districtive converted Oast House in a semi-rural setting.&#8221;,<br \/>\n\u00a0\u00a0\u00a0&#8220;directions&#8221;: null,<br \/>\n\u00a0\u00a0\u00a0&#8220;email&#8221;: null,<br \/>\n\u00a0\u00a0\u00a0&#8220;fax&#8221;: null,<br \/>\n\u00a0\u00a0\u00a0 \u2026<br \/>\n\u00a0\u00a0\u00a0&#8220;id&#8221;: 10025,<br \/>\n\u00a0\u00a0\u00a0&#8220;name&#8221;: &#8220;Medway Youth Hostel&#8221;,<br \/>\n\u00a0\u00a0\u00a0&#8220;pets_ok&#8221;: true,<br \/>\n\u00a0\u00a0\u00a0&#8220;phone&#8221;: &#8220;+44 870 770 5964&#8221;,<br \/>\n\u00a0\u00a0\u00a0&#8220;price&#8221;: null,<br \/>\n\u00a0\u00a0\u00a0&#8220;reviews&#8221;: [<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0{<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;author&#8221;: &#8220;Ozella Sipes&#8221;,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;content&#8221;: &#8220;Some review here\u2026\u201d,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;date&#8221;: &#8220;2013-06-22 18:33:50 +0300&#8221;,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;ratings&#8221;: {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;Cleanliness&#8221;: 5,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;Location&#8221;: 4,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;Overall&#8221;: 4,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;Rooms&#8221;: 3,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;Service&#8221;: 5,<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;Value&#8221;: 4<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}<br \/>\n     }<br \/>\n   ]<br \/>\n}[\/crayon]<\/p>\n\n\n\n<p><span>Now, if we need to query hotel reviews, we could do something like:<\/span><\/p>\n\n\n<p>[crayon lang=&#8221;default&#8221; decode=&#8221;true&#8221;]SELECT c.* FROM `travel-sample` t UNNEST t.reviews c where t.type == &#8220;hotel&#8221; limit 100[\/crayon]<\/p>\n\n\n\n<p><span>So, the simplest index for the <\/span><b><i>reviews<\/i><\/b><span> array <\/span><span>will<\/span><span> look like the following:<\/span><\/p>\n\n\n<p>[crayon lang=&#8221;default&#8221; decode=&#8221;true&#8221;]CREATE INDEX idx ON `travel-sample` (reviews) WHERE type = &#8220;hotel&#8221;;[\/crayon]<\/p>\n\n\n\n<p><span>And then, when we execute the query, voil\u00e0:<\/span><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4730\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/array_index-1024x564-1.png\" alt=\"\" width=\"778\" height=\"429\"><\/p>\n\n\n\n<p><span>It is using the recently created index.<\/span><\/p>\n\n\n\n<p><span>For more examples, check the <\/span><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/n1ql\/n1ql-language-reference\/indexing-arrays.html\"><span>official documentation<\/span><\/a><span> or read <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/making-the-most-of-your-arrays-with-array-indexing\/\"><span>this excellent article<\/span><\/a><span> about how to optimize array indexes.<\/span><\/p>\n\n\n\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to do \u201csomething\u201d in N1QL? First of all, if you are not familiar with N1QL I highly recommend you to spend a few minutes in our free N1QL training here, \u00a0or just play with it here. Second, as it is a broad question, let\u2019s go through some common scenarios: \u00a0 Select the id of [&hellip;]<\/p>\n","protected":false},"author":8754,"featured_media":18,"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":[287],"class_list":["post-1255","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.6 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>The 5 Most Common Forum&#039;s Questions - The Couchbase Blog<\/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\/5-common-forums-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The 5 Most Common Forum&#039;s Questions\" \/>\n<meta property=\"og:description\" content=\"How to do \u201csomething\u201d in N1QL? First of all, if you are not familiar with N1QL I highly recommend you to spend a few minutes in our free N1QL training here, \u00a0or just play with it here. Second, as it is a broad question, let\u2019s go through some common scenarios: \u00a0 Select the id of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-06T12:43:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Denis Rosa, Developer Advocate, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@deniswsrosa\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Denis Rosa, Developer Advocate, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/\"},\"author\":{\"name\":\"Denis Rosa, Developer Advocate, Couchbase\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/fe3c5273e805e72a5294611a48f62257\"},\"headline\":\"The 5 Most Common Forum&#8217;s Questions\",\"datePublished\":\"2018-03-06T12:43:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/\"},\"wordCount\":818,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/05\\\/couchbase-nosql-dbaas.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/\",\"name\":\"The 5 Most Common Forum's Questions - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/05\\\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2018-03-06T12:43:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/05\\\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/05\\\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/ko\\\/5-common-forums-questions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The 5 Most Common Forum&#8217;s Questions\"}]},{\"@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\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/06\\\/logo.svg\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/06\\\/logo.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/fe3c5273e805e72a5294611a48f62257\",\"name\":\"Denis Rosa, Developer Advocate, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8d1f5c13115122cab89d0f229b904480bfe20d3dfbb093fe9734cda5235d419?s=96&d=mm&r=gbe0716f6199cfb09417c92cf7a8fa8d6\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8d1f5c13115122cab89d0f229b904480bfe20d3dfbb093fe9734cda5235d419?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8d1f5c13115122cab89d0f229b904480bfe20d3dfbb093fe9734cda5235d419?s=96&d=mm&r=g\",\"caption\":\"Denis Rosa, Developer Advocate, Couchbase\"},\"description\":\"Denis Rosa is a Developer Advocate for Couchbase and lives in Munich - Germany. He has a solid experience as a software engineer and speaks fluently Java, Python, Scala and Javascript. Denis likes to write about search, Big Data, AI, Microservices and everything else that would help developers to make a beautiful, faster, stable and scalable app.\",\"sameAs\":[\"https:\\\/\\\/x.com\\\/deniswsrosa\"],\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/author\\\/denis-rosa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The 5 Most Common Forum's Questions - The Couchbase Blog","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\/5-common-forums-questions\/","og_locale":"en_US","og_type":"article","og_title":"The 5 Most Common Forum's Questions","og_description":"How to do \u201csomething\u201d in N1QL? First of all, if you are not familiar with N1QL I highly recommend you to spend a few minutes in our free N1QL training here, \u00a0or just play with it here. Second, as it is a broad question, let\u2019s go through some common scenarios: \u00a0 Select the id of [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-03-06T12:43:47+00:00","og_image":[{"width":1800,"height":630,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png","type":"image\/png"}],"author":"Denis Rosa, Developer Advocate, Couchbase","twitter_card":"summary_large_image","twitter_creator":"@deniswsrosa","twitter_misc":{"Written by":"Denis Rosa, Developer Advocate, Couchbase","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/"},"author":{"name":"Denis Rosa, Developer Advocate, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/fe3c5273e805e72a5294611a48f62257"},"headline":"The 5 Most Common Forum&#8217;s Questions","datePublished":"2018-03-06T12:43:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/"},"wordCount":818,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/","url":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/","name":"The 5 Most Common Forum's Questions - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png","datePublished":"2018-03-06T12:43:47+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/ko\/5-common-forums-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The 5 Most Common Forum&#8217;s Questions"}]},{"@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":"en-US"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"The Couchbase Blog","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/06\/logo.svg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/06\/logo.svg","width":"1024","height":"1024","caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/fe3c5273e805e72a5294611a48f62257","name":"Denis Rosa, Developer Advocate, Couchbase","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8d1f5c13115122cab89d0f229b904480bfe20d3dfbb093fe9734cda5235d419?s=96&d=mm&r=gbe0716f6199cfb09417c92cf7a8fa8d6","url":"https:\/\/secure.gravatar.com\/avatar\/f8d1f5c13115122cab89d0f229b904480bfe20d3dfbb093fe9734cda5235d419?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8d1f5c13115122cab89d0f229b904480bfe20d3dfbb093fe9734cda5235d419?s=96&d=mm&r=g","caption":"Denis Rosa, Developer Advocate, Couchbase"},"description":"Denis Rosa is a Developer Advocate for Couchbase and lives in Munich - Germany. He has a solid experience as a software engineer and speaks fluently Java, Python, Scala and Javascript. Denis likes to write about search, Big Data, AI, Microservices and everything else that would help developers to make a beautiful, faster, stable and scalable app.","sameAs":["https:\/\/x.com\/deniswsrosa"],"url":"https:\/\/www.couchbase.com\/blog\/author\/denis-rosa\/"}]}},"acf":[],"authors":[{"term_id":287,"user_id":8754,"is_guest":0,"slug":"denis-rosa","display_name":"Denis Rosa, Developer Advocate, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/1255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/users\/8754"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/comments?post=1255"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/1255\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media\/18"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media?parent=1255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=1255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=1255"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=1255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}