{"id":4721,"date":"2018-03-06T04:43:47","date_gmt":"2018-03-06T12:43:47","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4721"},"modified":"2023-10-20T10:19:51","modified_gmt":"2023-10-20T17:19:51","slug":"5-common-forums-questions","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/5-common-forums-questions\/","title":{"rendered":"As 5 perguntas mais comuns do f\u00f3rum"},"content":{"rendered":"<h3><b>Como fazer \"algo\" no N1QL?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Em primeiro lugar, <\/span><span style=\"font-weight: 400\">Se voc\u00ea n\u00e3o estiver familiarizado com o N1QL, recomendo que dedique alguns minutos ao nosso treinamento gratuito sobre N1QL <\/span><a href=\"https:\/\/training.couchbase.com\/online\"><span style=\"font-weight: 400\">aqui<\/span><\/a><span style=\"font-weight: 400\">ou simplesmente brincar com ele <\/span><a href=\"https:\/\/query-tutorial.couchbase.com\/tutorial\/#1\"><span style=\"font-weight: 400\">aqui<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Em segundo lugar, como se trata de uma pergunta ampla, vamos analisar alguns cen\u00e1rios comuns:<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><b>Selecione o ID de um documento e todos os seus atributos:<\/b><\/h4>\n<pre class=\"lang:default decode:true\">Select meta(t).id as id, t.* from `myBucket` t where type = 'someType'<\/pre>\n<h4><\/h4>\n<h4><b>Como escrever um JOIN:<\/b><\/h4>\n<p><span style=\"font-weight: 400\">Vamos consultar quais empresas voam do aeroporto de S\u00e3o Francisco (SFO) para qualquer lugar do mundo usando o exemplo de viagem:<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT \u00a0airline.name, airline.callsign, route.destinationairport, route.stops, route.airline\r\nFROM `travel-sample` route JOIN `travel-sample` airline ON KEYS route.airlineid\r\nWHERE route.type = \"route\"\r\nAND airline.type = \"airline\"\r\nAND route.sourceairport = \"SFO\"\r\nAND route.stops = 0\r\nORDER BY airline.name<\/pre>\n<p><span style=\"font-weight: 400\">O <\/span><b><i>JUNTAR<\/i><\/b><span style=\"font-weight: 400\"> se parece com um SQL JOIN padr\u00e3o, a \u00fanica diferen\u00e7a aqui \u00e9 a cl\u00e1usula <\/span><b><i>SOBRE AS CHAVES <\/i><\/b><span style=\"font-weight: 400\">palavra-chave, para ler mais sobre ela <\/span><a href=\"https:\/\/dzone.com\/articles\/visually-explaining-n1ql-joins\"><span style=\"font-weight: 400\">Confira este artigo que explica visualmente os JOINs N1QL<\/span><\/a><span style=\"font-weight: 400\">. O Couchbase 5.5 tamb\u00e9m adicionar\u00e1 suporte a <a href=\"https:\/\/www.couchbase.com\/blog\/pt\/ansi-join-support-n1ql\/\">ANSI JOINs<\/a><\/span><\/p>\n<h4><b>Como selecionar itens de uma matriz:<\/b><\/h4>\n<p><span style=\"font-weight: 400\">Documentos fornecidos como:<\/span><\/p>\n<pre class=\"lang:js decode:true\">{\r\n  type: \u201cperson\u201d,\r\n  name: \u201cJohn\u201d,\r\n  children: [\r\n    {\r\n      \u201cname\u201d: \u201cPedro\u201d,\r\n      \u201cage\u201d: 8\r\n    },\r\n    {\r\n       \u201cname\u201d: \u201cGeorge\u201d,\r\n       \u201cage\u201d: 11\r\n    }\r\n  ]\r\n}<\/pre>\n<p><span style=\"font-weight: 400\">Se quisermos selecionar todas as crian\u00e7as com mais de 10 anos de idade, podemos usar o comando <strong>IN\u00daTIL<\/strong> palavra-chave: <\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT c.* FROM tutorial t UNNEST t.children c WHERE c.age &gt; 10<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><b>Por que minha consulta est\u00e1 lenta?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Provavelmente, sua consulta n\u00e3o est\u00e1 atingindo nenhum \u00edndice. Voc\u00ea pode verificar isso executando a consulta com a op\u00e7\u00e3o <\/span><b><i>explicar<\/i><\/b><span style=\"font-weight: 400\"> da seguinte forma:<\/span><\/p>\n<p><span style=\"font-weight: 400\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4724\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/explain-query-correct-1024x778.png\" alt=\"\" width=\"710\" height=\"540\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/explain-query-correct-1024x778.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/explain-query-correct-300x228.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/explain-query-correct-768x584.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/explain-query-correct-1536x1167.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/explain-query-correct-20x15.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/explain-query-correct-1320x1003.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/explain-query-correct.png 1666w\" sizes=\"auto, (max-width: 710px) 100vw, 710px\" \/><\/span><\/p>\n<p><span style=\"font-weight: 400\">Como voc\u00ea pode ver na imagem acima, a consulta est\u00e1 atingindo o <\/span><b><i>PrimaryScan<\/i><\/b><span style=\"font-weight: 400\"> o que significa que ele est\u00e1 usando o \u00edndice prim\u00e1rio. A cria\u00e7\u00e3o de um \u00edndice secund\u00e1rio para ele possivelmente resolver\u00e1 seu problema:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4725\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM-1024x369.png\" alt=\"\" width=\"700\" height=\"252\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM-1024x369.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM-300x108.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM-768x277.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM-1536x553.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM-20x7.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM-1320x476.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.03-PM.png 1932w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ao executar a mesma consulta novamente, o resultado ser\u00e1 algo como:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4726\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM-1024x560.png\" alt=\"\" width=\"723\" height=\"395\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM-1024x560.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM-300x164.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM-768x420.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM-1536x840.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM-20x11.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM-1320x721.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/Screen-Shot-2018-03-06-at-12.57.33-PM.png 1954w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Se a sua consulta j\u00e1 estiver atingindo um \u00edndice, mas ainda tiver um desempenho ruim, talvez seja melhor adicionar um \u00edndice mais otimizado (<\/span><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/forums\/t\/order-by-performance-really-slow\/13173\/20\/\"><span style=\"font-weight: 400\">como neste exemplo<\/span><\/a><span style=\"font-weight: 400\">). Se voc\u00ea n\u00e3o estiver familiarizado com <\/span><span style=\"font-weight: 400\">como criar um \u00edndice<\/span><span style=\"font-weight: 400\">, <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/create-right-index-get-right-performance\/\"><span style=\"font-weight: 400\">d\u00ea uma olhada nesta postagem do blog<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><b>Como paginar os resultados no N1QL?<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Voc\u00ea pode usar <\/span><b><i>LIMITE<\/i><\/b><span style=\"font-weight: 400\"> e <\/span><b><i>DESLOCAMENTO<\/i><\/b><span style=\"font-weight: 400\">:<\/span><\/p>\n<pre class=\"lang:default decode:true\">select * from `travel-sample` where country = 'United States' OFFSET 10 LIMIT 10<\/pre>\n<p><span style=\"font-weight: 400\">Confira <\/span><a href=\"https:\/\/dzone.com\/articles\/database-pagination-using-offset-and-keyset-in-n1q\"><span style=\"font-weight: 400\">este tutorial<\/span><\/a><span style=\"font-weight: 400\"> para ler mais sobre o assunto.\u00a0<\/span><span style=\"font-weight: 400\">Al\u00e9m disso, se voc\u00ea estiver usando o Spring Data, poder\u00e1 adicionar um <\/span><b><i>Pagin\u00e1vel<\/i><\/b><span style=\"font-weight: 400\"> ao final da defini\u00e7\u00e3o de seu m\u00e9todo:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4727\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/repository-1024x203.png\" alt=\"\" width=\"763\" height=\"151\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/repository-1024x203.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/repository-300x60.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/repository-768x152.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/repository-20x4.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/repository.png 1270w\" sizes=\"auto, (max-width: 763px) 100vw, 763px\" \/><\/p>\n<p><span style=\"font-weight: 400\">E ent\u00e3o, em seu servi\u00e7o, voc\u00ea pode usar o <\/span><b><i>Solicita\u00e7\u00e3o de p\u00e1gina<\/i><\/b><span style=\"font-weight: 400\"> objeto:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4728\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/service-1024x263.png\" alt=\"\" width=\"760\" height=\"195\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/service-1024x263.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/service-300x77.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/service-768x197.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/service-20x5.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/service-1320x339.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/service.png 1378w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><b>Minha consulta tem resultados ausentes\/errados<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Por padr\u00e3o, o Couchbase suporta <\/span><i><span style=\"font-weight: 400\">leitura ap\u00f3s a escrita<\/span><\/i><span style=\"font-weight: 400\"> sempre que voc\u00ea obt\u00e9m um documento por sua chave, mas seus \u00edndices e exibi\u00e7\u00f5es s\u00e3o atualizados de forma ass\u00edncrona por meio do Data Change Protocol (DCP). Portanto, se voc\u00ea estiver executando uma consulta logo ap\u00f3s uma grava\u00e7\u00e3o, ela poder\u00e1 ser executada antes que as exibi\u00e7\u00f5es\/\u00edndices tenham a chance de ser atualizados.<\/span><\/p>\n<p><span style=\"font-weight: 400\">O Couchbase tem tudo a ver com velocidade, e ningu\u00e9m tem tempo para esperar at\u00e9 que todos os \u00edndices e exibi\u00e7\u00f5es sejam atualizados para enviar a resposta de volta ao cliente de que uma grava\u00e7\u00e3o foi executada com \u00eaxito.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Mas h\u00e1 poucos cen\u00e1rios em que a consist\u00eancia forte entre as grava\u00e7\u00f5es e as consultas \u00e9 realmente necess\u00e1ria. Nesses casos, voc\u00ea pode especificar por meio do SDK que deseja esperar at\u00e9 que o \u00edndice\/visualiza\u00e7\u00e3o que est\u00e1 usando seja atualizado:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-4729\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/consistency-1024x107.png\" alt=\"\" width=\"900\" height=\"94\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/consistency-1024x107.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/consistency-300x31.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/consistency-768x80.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/consistency-20x2.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/consistency-1320x138.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/consistency.png 1432w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Para saber mais sobre consist\u00eancia de varredura, consulte a se\u00e7\u00e3o <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/learn\/services-and-indexes\/indexes\/index-replication.html\"><span style=\"font-weight: 400\">documenta\u00e7\u00e3o oficial<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Em minha experi\u00eancia pessoal, o \u00fanico cen\u00e1rio em que preciso de consist\u00eancia entre grava\u00e7\u00f5es e consultas \u00e9 durante o <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/integration-tests-couchbase-application\/\"><b><i>testes de integra\u00e7\u00e3o<\/i><\/b><\/a><span style=\"font-weight: 400\"> que \u00e9 quando voc\u00ea realmente insere os dados e os consulta logo em seguida. <\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><b>Como criar\/usar \u00edndices de matriz.<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Esse \u00e9 um t\u00f3pico interessante, pois <\/span><b><i>indexa\u00e7\u00e3o de matriz<\/i><\/b><span style=\"font-weight: 400\"> pode acelerar significativamente seu desempenho. Ent\u00e3o, digamos que temos a seguinte estrutura de documento:<\/span><\/p>\n<pre class=\"lang:default decode:true\">{\r\n\u00a0\u00a0\u00a0\"address\": \"Capstone Road, ME7 3JE\",\r\n\u00a0\u00a0\u00a0\"alias\": null,\r\n\u00a0\u00a0\u00a0\"city\": \"Medway\",\r\n\u00a0\u00a0\u00a0\"country\": \"United Kingdom\",\r\n\u00a0\u00a0\u00a0\"description\": \"40 bed summer hostel about 3 miles from Gillingham, housed in a districtive converted Oast House in a semi-rural setting.\",\r\n\u00a0\u00a0\u00a0\"directions\": null,\r\n\u00a0\u00a0\u00a0\"email\": null,\r\n\u00a0\u00a0\u00a0\"fax\": null,\r\n\u00a0\u00a0\u00a0 \u2026\r\n\u00a0\u00a0\u00a0\"id\": 10025,\r\n\u00a0\u00a0\u00a0\"name\": \"Medway Youth Hostel\",\r\n\u00a0\u00a0\u00a0\"pets_ok\": true,\r\n\u00a0\u00a0\u00a0\"phone\": \"+44 870 770 5964\",\r\n\u00a0\u00a0\u00a0\"price\": null,\r\n\u00a0\u00a0\u00a0\"reviews\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"author\": \"Ozella Sipes\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"content\": \"Some review here\u2026\u201d,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"date\": \"2013-06-22 18:33:50 +0300\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"ratings\": {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Cleanliness\": 5,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Location\": 4,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Overall\": 4,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Rooms\": 3,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Service\": 5,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Value\": 4\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n     }\r\n   ]\r\n}<\/pre>\n<p><span style=\"font-weight: 400\">Agora, se precisarmos consultar as avalia\u00e7\u00f5es de hot\u00e9is, podemos fazer algo como:<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT c.* FROM `travel-sample` t UNNEST t.reviews c where t.type == \"hotel\" limit 100<\/pre>\n<p><span style=\"font-weight: 400\">Portanto, o \u00edndice mais simples para o <\/span><b><i>revis\u00f5es<\/i><\/b><span style=\"font-weight: 400\"> matriz <\/span><span style=\"font-weight: 400\">vontade<\/span><span style=\"font-weight: 400\"> se parece com o seguinte:<\/span><\/p>\n<pre class=\"lang:default decode:true\">CREATE INDEX idx ON `travel-sample` (reviews) WHERE type = \"hotel\";<\/pre>\n<p><span style=\"font-weight: 400\">E ent\u00e3o, quando executamos a consulta, voil\u00e0:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4730\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/array_index-1024x564.png\" alt=\"\" width=\"778\" height=\"429\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/array_index-1024x564.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/array_index-300x165.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/array_index-768x423.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/array_index-1536x846.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/array_index-20x11.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/array_index-1320x727.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/array_index.png 1982w\" sizes=\"auto, (max-width: 778px) 100vw, 778px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ele est\u00e1 usando o \u00edndice criado recentemente.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Para obter mais exemplos, consulte o <\/span><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/n1ql\/n1ql-language-reference\/indexing-arrays.html\"><span style=\"font-weight: 400\">documenta\u00e7\u00e3o oficial<\/span><\/a><span style=\"font-weight: 400\"> ou leia <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/making-the-most-of-your-arrays-with-array-indexing\/\"><span style=\"font-weight: 400\">este excelente artigo<\/span><\/a><span style=\"font-weight: 400\"> sobre como otimizar os \u00edndices de matriz.<\/span><\/p>\n<p>&nbsp;<\/p>","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 [&hellip;]<\/p>","protected":false},"author":8754,"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":[9059],"class_list":["post-4721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.0 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\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\/pt\/5-common-forums-questions\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/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=\"article:modified_time\" content=\"2023-10-20T17:19:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/explain-query-correct-1024x778.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 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/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\",\"dateModified\":\"2023-10-20T17:19:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/\"},\"wordCount\":602,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/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\/5-common-forums-questions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2018-03-06T12:43:47+00:00\",\"dateModified\":\"2023-10-20T17:19:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#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\/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\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\/fe3c5273e805e72a5294611a48f62257\",\"name\":\"Denis Rosa, Developer Advocate, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/be0716f6199cfb09417c92cf7a8fa8d6\",\"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\/pt\/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\/pt\/5-common-forums-questions\/","og_locale":"pt_BR","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 [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/5-common-forums-questions\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-03-06T12:43:47+00:00","article_modified_time":"2023-10-20T17:19:51+00:00","og_image":[{"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/explain-query-correct-1024x778.png","type":"","width":"","height":""}],"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 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/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","dateModified":"2023-10-20T17:19:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/"},"wordCount":602,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Uncategorized"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/","url":"https:\/\/www.couchbase.com\/blog\/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\/5-common-forums-questions\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2018-03-06T12:43:47+00:00","dateModified":"2023-10-20T17:19:51+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/5-common-forums-questions\/#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\/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":"Blog do Couchbase","description":"Couchbase, o banco de dados NoSQL","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":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@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\/fe3c5273e805e72a5294611a48f62257","name":"Denis Rosa, defensor dos desenvolvedores, Couchbase","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/be0716f6199cfb09417c92cf7a8fa8d6","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 \u00e9 um Developer Advocate do Couchbase e mora em Munique, na Alemanha. Ele tem uma s\u00f3lida experi\u00eancia como engenheiro de software e fala fluentemente Java, Python, Scala e Javascript. Denis gosta de escrever sobre pesquisa, Big Data, IA, microsservi\u00e7os e tudo o mais que possa ajudar os desenvolvedores a criar um aplicativo bonito, mais r\u00e1pido, est\u00e1vel e escal\u00e1vel.","sameAs":["https:\/\/x.com\/deniswsrosa"],"url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/denis-rosa\/"}]}},"authors":[{"term_id":9059,"user_id":8754,"is_guest":0,"slug":"denis-rosa","display_name":"Denis Rosa, Developer Advocate, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/f8d1f5c13115122cab89d0f229b904480bfe20d3dfbb093fe9734cda5235d419?s=96&d=mm&r=g","author_category":"","last_name":"Rosa, Developer Advocate, Couchbase","first_name":"Denis","job_title":"","user_url":"","description":"Denis Rosa \u00e9 um Developer Advocate do Couchbase e mora em Munique, na Alemanha. Ele tem uma s\u00f3lida experi\u00eancia como engenheiro de software e fala fluentemente Java, Python, Scala e Javascript. Denis gosta de escrever sobre pesquisa, Big Data, IA, microsservi\u00e7os e tudo o mais que possa ajudar os desenvolvedores a criar um aplicativo bonito, mais r\u00e1pido, est\u00e1vel e escal\u00e1vel."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/4721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/8754"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=4721"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/4721\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=4721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=4721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=4721"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=4721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}