{"id":11663,"date":"2021-08-04T00:00:55","date_gmt":"2021-08-04T07:00:55","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=11663"},"modified":"2025-06-13T19:27:05","modified_gmt":"2025-06-14T02:27:05","slug":"amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","title":{"rendered":"Amplie sua an\u00e1lise de dados com a nova agrega\u00e7\u00e3o ROLLUP no Couchbase Analytics"},"content":{"rendered":"

Tenho o prazer de anunciar dois novos recursos avan\u00e7ados de an\u00e1lise de dados<\/strong> agora dispon\u00edvel como parte do Couchbase Analytics: 1) ROLLUP<\/code> agrega\u00e7\u00e3o, e 2) CUBO<\/code> ambos para ajud\u00e1-lo a agregar dados em v\u00e1rios atributos de documentos.<\/p>\n

A adi\u00e7\u00e3o do ROLLUP<\/code> funcionalidade de agrega\u00e7\u00e3o para o servi\u00e7o de an\u00e1lise do Couchbase<\/a> faz parte de a vers\u00e3o 7.0 do Couchbase Server<\/a>. (Cobriremos o CUBO<\/code> em um artigo na pr\u00f3xima semana).<\/p>\n

Exemplo de agrega\u00e7\u00e3o ROLLUP: Dados de com\u00e9rcio eletr\u00f4nico<\/h2>\n

O ROLLUP<\/code> \u00e9 uma extens\u00e3o da fun\u00e7\u00e3o de agrega\u00e7\u00e3o GRUPO POR<\/a> cl\u00e1usula.<\/p>\n

O ROLLUP<\/code> permite que voc\u00ea inclua linhas extras - comumente chamadas de linhas superagregadas - que representam subtotais em seus dados, juntamente com a linha do total geral.<\/p>\n

Por exemplo, digamos que voc\u00ea tenha uma cole\u00e7\u00e3o de an\u00e1lise chamada Sales que rastreia informa\u00e7\u00f5es de com\u00e9rcio eletr\u00f4nico da sua empresa. Os principais elementos de dados que voc\u00ea tem mais interesse em rastrear s\u00e3o pa\u00eds, regi\u00e3o\/estado, produto, quantidade e pre\u00e7o. (E digamos que voc\u00ea calcule Sales como Sales = quantity * price).<\/p>\n

Abaixo est\u00e1 um subconjunto do nosso exemplo de coleta de dados de com\u00e9rcio eletr\u00f4nico:<\/p>\n

{\r\n    \"Country\": \"US\",\r\n    \"Region\": \"California\",\r\n    \"Product\": \"Rubber Keyboard\",\r\n    \"Qty\": 1,\r\n    \"Price\": 35.5\r\n  },\r\n  {\r\n    \"Country\": \"US\",\r\n    \"Region\": \"Colorado\",\r\n    \"Product\": \"Gloves\",\r\n    \"Qty\": 4,\r\n    \"Price\": 6.95\r\n  },\r\n {\r\n    \"Country\": \"US\",\r\n    \"Region\": \"Connecticut\",\r\n    \"Product\": \"Cotton Ties\",\r\n    \"Qty\": 2,\r\n    \"Price\": 12.75\r\n}\r\n\u2026\r\n<\/pre>\n
<\/div>\n
Agora, digamos que seus usu\u00e1rios precisem determinar as seguintes informa\u00e7\u00f5es usando os dados acima:<\/p>\n
1) Total de vendas para todos os pa\u00edses e regi\u00f5es
\n2) Total de vendas para todas as regi\u00f5es por pa\u00eds
\n3) Total de vendas para cada regi\u00e3o<\/p>\n
O ROLLUP<\/code> A subcl\u00e1usula de agrega\u00e7\u00e3o \u00e9 uma excelente op\u00e7\u00e3o para responder a esses tipos de perguntas de an\u00e1lise de dados. Seu engenheiro ou analista de dados simplesmente usa a subcl\u00e1usula Consulta N1QL<\/a> mostrado abaixo.<\/p>\n
SELECT   IFNULL(country,\"All Countries\") Country,\r\n                  IFNULL(region,\"All Regions\") Region,\r\n                  ROUND(SUM(o.qty * o.price),0) Sales\r\nFROM     orders o\r\nWHERE  region LIKE \u201cC%\u201d\r\nLET      country = o.country,  region = o.region\r\nGROUP BY ROLLUP(country, region)\r\nORDER BY country ASC, region ASC, Sales DESC;\r\n<\/pre>\n
<\/div>\n
Na consulta N1QL acima, usamos pa\u00eds e regi\u00e3o como vari\u00e1veis. O ROLLUP<\/code> pressup\u00f5e uma hierarquia entre os atributos de dados especificados.<\/p>\n
Por exemplo, se a coluna de entrada for (pa\u00eds, regi\u00e3o)<\/code>, a hierarquia pa\u00eds<\/code> \u00e9 maior ou igual a regi\u00e3o<\/code>. \u00c9 por isso que faz sentido usar ROLLUP<\/code> para gerar os subtotais e o total geral para fins de relat\u00f3rio.<\/p>\n
Com base na consulta acima, ROLLUP(country, region)<\/code> gera os seguintes resultados:<\/p>\n
{ \"Country\": \"All Countries\",\r\n    \"Region\": \"All Regions\",\r\n    \"Sales\": 19921991 \r\n},\r\n{ \"Country\": \"US\",\r\n  \"Region\": \"All Regions\",\r\n   \"Sales\": 199219915 \r\n},\r\n{ \"Country\": \"US\",\r\n  \"Region\": \"California\",\r\n  \"Sales\": 6610804\r\n},\r\n{ \"Country\": \"US\",\r\n  \"Region\": \"Colorado\",\r\n  \"Sales\": 6569542 }\r\n {\r\n    \"Country\": \"US\",\r\n    \"Region\": \"Connecticut\",\r\n    \"Sales\": 6741644\r\n  }\r\n...\r\n<\/pre>\n
<\/div>\n
Observe que o resultado \u00e9 exatamente o que os usu\u00e1rios do exemplo estavam procurando originalmente:<\/p>\n
    \n
  1. Na parte superior dos resultados, um campo JSON de resumo do total geral mostra o total de vendas de todos os pa\u00edses e regi\u00f5es. Nessas linhas, os valores NULL nos atributos de pa\u00eds e regi\u00e3o s\u00e3o transformados em \"Todos os pa\u00edses\" e \"Todas as regi\u00f5es\", respectivamente, para tornar o resultado mais leg\u00edvel.<\/li>\n
  2. Depois disso, para cada pa\u00eds (nesse caso, os EUA), um elemento de dados JSON de resumo de subtotal extra aparece exibindo o total de vendas. Neles, os valores no atributo region s\u00e3o transformados de NULL para \"All Regions\"<\/li>\n
  3. Por fim, o resultado mostra o total de vendas acumuladas para cada regi\u00e3o do pa\u00eds. Neste exemplo, as vendas para a Calif\u00f3rnia, Colorado e Connecticut s\u00e3o mostradas dentro dos EUA.<\/li>\n<\/ol>\n
    Conclus\u00e3o<\/h2>\n
    Esta foi apenas uma r\u00e1pida olhada no novo ROLLUP<\/code> recurso de agrega\u00e7\u00e3o no Couchbase Analytics Service. Para obter mais informa\u00e7\u00f5es, d\u00ea uma olhada no ROLLUP<\/code> documenta\u00e7\u00e3o<\/a>. Espero que esse novo recurso seja \u00fatil para futuros projetos de an\u00e1lise de dados em sua empresa.<\/p>\n
    Estou ansioso para seu feedback nos f\u00f3runs do Couchbase<\/a> - Diga-nos o que voc\u00ea achou!<\/p>\n
    <\/div>\n
    Voc\u00ea n\u00e3o precisa acreditar em minha palavra: D\u00ea uma olhada no Couchbase Analytics hoje mesmo
    Fa\u00e7a um test drive no Couchbase<\/a><\/strong><\/div>\n
    <\/div>\n
     <\/p>","protected":false},"excerpt":{"rendered":"
    I’m excited to announce two new powerful data analysis capabilities now available as part of Couchbase Analytics: 1) ROLLUP aggregation, and 2) CUBE functionality, both to help you aggregate data across multiple document attributes. The addition of the ROLLUP aggregation […]<\/p>\n","protected":false},"author":58630,"featured_media":11665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,2294,1816,1812],"tags":[2014,2155,9354,1261,9353],"ppma_author":[8967],"class_list":["post-11663","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-analytics","category-couchbase-server","category-n1ql-query","tag-data-analysis","tag-ecommerce","tag-group-by","tag-json","tag-super-aggregate-rows"],"yoast_head":"\nData Analysis with ROLLUP Aggregation in Couchbase Analytics<\/title>\n<meta name=\"description\" content=\"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.\" \/>\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\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics\" \/>\n<meta property=\"og:description\" content=\"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-04T07:00:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T02:27:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"418\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Idris Motiwala\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Idris Motiwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/\"},\"author\":{\"name\":\"Idris Motiwala\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\"},\"headline\":\"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics\",\"datePublished\":\"2021-08-04T07:00:55+00:00\",\"dateModified\":\"2025-06-14T02:27:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/\"},\"wordCount\":513,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2021\\\/08\\\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"keywords\":[\"Data Analysis\",\"ecommerce\",\"GROUP BY\",\"JSON\",\"super-aggregate rows\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Couchbase Analytics\",\"Couchbase Server\",\"SQL++ \\\/ N1QL Query\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/\",\"name\":\"Data Analysis with ROLLUP Aggregation in Couchbase Analytics\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2021\\\/08\\\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"datePublished\":\"2021-08-04T07:00:55+00:00\",\"dateModified\":\"2025-06-14T02:27:05+00:00\",\"description\":\"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2021\\\/08\\\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2021\\\/08\\\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"width\":1200,\"height\":628,\"caption\":\"Talend adds Couchbase Capella connector support\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics\"}]},{\"@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\\\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\",\"name\":\"Idris Motiwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g28d4b56674680cd3d7fe940321c3e98a\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"caption\":\"Idris Motiwala\"},\"description\":\"Idris is a Principal Product Manager, Analytics at Couchbase with 20+ years experience in design, development and execution of software products at both Fortune 500s and startups leading teams in digital transformation, cloud and analytics. Idris holds an MS in Technology Management and certifications in product management .\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/idrismotiwala\\\/\"],\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/pt\\\/author\\\/idris-motiwala\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Analysis with ROLLUP Aggregation in Couchbase Analytics","description":"Veja um exemplo do novo recurso de subcl\u00e1usula ROLLUP no Couchbase Analytics para ajud\u00e1-lo a agregar dados em v\u00e1rios atributos de documentos JSON.","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\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","og_locale":"pt_BR","og_type":"article","og_title":"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics","og_description":"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","og_site_name":"The Couchbase Blog","article_published_time":"2021-08-04T07:00:55+00:00","article_modified_time":"2025-06-14T02:27:05+00:00","og_image":[{"width":800,"height":418,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg","type":"image\/jpeg"}],"author":"Idris Motiwala","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg","twitter_misc":{"Written by":"Idris Motiwala","Est. reading time":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/"},"author":{"name":"Idris Motiwala","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8"},"headline":"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics","datePublished":"2021-08-04T07:00:55+00:00","dateModified":"2025-06-14T02:27:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/"},"wordCount":513,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","keywords":["Data Analysis","ecommerce","GROUP BY","JSON","super-aggregate rows"],"articleSection":["Best Practices and Tutorials","Couchbase Analytics","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","url":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","name":"Data Analysis with ROLLUP Aggregation in Couchbase Analytics","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","datePublished":"2021-08-04T07:00:55+00:00","dateModified":"2025-06-14T02:27:05+00:00","description":"Veja um exemplo do novo recurso de subcl\u00e1usula ROLLUP no Couchbase Analytics para ajud\u00e1-lo a agregar dados em v\u00e1rios atributos de documentos JSON.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","width":1200,"height":628,"caption":"Talend adds Couchbase Capella connector support"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics"}]},{"@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\/2fc07a18d91ce2e4e0f1f7c5c9e620b8","name":"Idris Motiwala","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g28d4b56674680cd3d7fe940321c3e98a","url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","caption":"Idris Motiwala"},"description":"Idris \u00e9 gerente de produto principal de an\u00e1lise na Couchbase, com mais de 20 anos de experi\u00eancia em design, desenvolvimento e execu\u00e7\u00e3o de produtos de software em empresas da Fortune 500 e startups, liderando equipes de transforma\u00e7\u00e3o digital, nuvem e an\u00e1lise. Idris tem mestrado em gerenciamento de tecnologia e certifica\u00e7\u00f5es em gerenciamento de produtos.","sameAs":["https:\/\/www.linkedin.com\/in\/idrismotiwala\/"],"url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/idris-motiwala\/"}]}},"acf":[],"authors":[{"term_id":8967,"user_id":58630,"is_guest":0,"slug":"idris-motiwala","display_name":"Idris Motiwala","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/11663","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\/58630"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=11663"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/11663\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/11665"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=11663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=11663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=11663"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=11663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}