{"docsConfig":{"theme":"maple","$schema":"https://mintlify.com/docs.json","name":"ClickHouse Documentation","colors":{"primary":"#1c1c1c","light":"#333431","dark":"#fdff75"},"logo":{"light":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/light.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=b8a838f982def2b530a95016300bc7ec","dark":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/dark.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=563dcf3fc5bb3694597dec207c9b4ecf"},"favicon":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/favicon.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=9a2d9de19e9259c4b5260fa5bfa26851","appearance":{"default":"dark"},"background":{"color":{"light":"#FFFFFF","dark":"#151515"}},"navbar":{},"fonts":{"family":"Inter"},"styling":{"eyebrows":"breadcrumbs","latex":true},"integrations":{"clarity":{"projectId":"xgummrwgj9"},"gtm":{"tagId":"GTM-WTNTDT7W"}},"contextual":{"options":["copy","view","download-pdf",{"title":"Set up the ClickHouse documentation MCP server","description":"Setup instructions for the ClickHouse documentation MCP server","icon":"/images/icons/icon-mcp.svg","href":"https://clickhouse.com/docs/resources/support-center/knowledge-base/setup-installation/set-up-clickhouse-documentation-mcp-server"}],"display":"toc"},"interaction":{"drilldown":false},"metadata":{"timestamp":true},"variables":{"airgap_server_tag":"26.4.1.2739","airgap_keeper_tag":"26.2.1.258","airgap_operator_tag":"1.22992.1","airgap_cr_helm_tag":"1.11.11","airgap_api_tag":"1.175.4","airgap_api_helm_tag":"1.175.4","airgap_preflight_chart_tag":"1.38.7","airgap_support_bundle_tag":"1.12.0"},"navigation":{"languages":[{"language":"en","href":""},{"language":"ar","href":"ar"},{"language":"es","href":"es"},{"language":"fr","href":"fr"},{"language":"ja","href":"ja"},{"language":"ko","href":"ko"},{"language":"pt-BR","href":"pt-BR"},{"language":"ru","href":"ru"},{"language":"zh","href":"zh"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"private-7c7dfe99","hasAudioNarration":false,"actualSubdomain":"private-7c7dfe99","customDomains":["clickhouse.com"],"gitSource":{"_id":"6ad7fa91692c7c940ff17a19","type":"github","owner":"clickhouse","repo":"clickhouse","deployBranch":"master","contentDirectory":"docs","isPrivate":false,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6aebaa0b8e1415d4091d06ac","collectionId":"114515e4-fe1f-4ddd-9728-b9fa79e3e71c","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6aebaa0b8e1415d4091d06ac"},"feedback":{"thumbs":true,"edits":true,"issues":true,"contextualFeedback":{"allowEmail":false},"agentFeedback":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED","enabled":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6aebaa0b8e1415d4091d06ac","clientVersion":"0.0.4067","searchFilterCounts":[{"language":"en","tag":"Database","count":1754},{"language":"ja","tag":"データベース","count":1737},{"language":"pt-BR","tag":"Banco de dados","count":1737},{"language":"zh","tag":"数据库","count":1737},{"language":"ar","tag":"قاعدة البيانات","count":1736},{"language":"es","tag":"Base de datos","count":1736},{"language":"fr","tag":"Base de données","count":1736},{"language":"ko","tag":"데이터베이스","count":1736},{"language":"ru","tag":"База данных","count":1736},{"language":"en","tag":"Reference","count":1578},{"language":"ar","tag":"المرجع","count":1565},{"language":"es","tag":"Referencia","count":1565},{"language":"fr","tag":"Référence","count":1565},{"language":"ja","tag":"リファレンス","count":1565},{"language":"ko","tag":"참고","count":1565},{"language":"pt-BR","tag":"Referência","count":1565},{"language":"ru","tag":"Справочник","count":1565},{"language":"zh","tag":"参考文档","count":1565},{"language":"en","tag":"Solutions","count":561},{"language":"ar","tag":"الحلول","count":554},{"language":"es","tag":"Soluciones","count":554},{"language":"fr","tag":"Solutions","count":554},{"language":"ja","tag":"ソリューション","count":554},{"language":"ko","tag":"솔루션","count":554},{"language":"pt-BR","tag":"Soluções","count":554},{"language":"ru","tag":"Решения","count":554},{"language":"zh","tag":"解决方案","count":554},{"language":"es","tag":"Configuración","count":531},{"language":"ja","tag":"設定","count":531},{"language":"en","tag":"Settings","count":511},{"language":"ar","tag":"الإعدادات","count":505},{"language":"fr","tag":"Paramètres","count":505},{"language":"ko","tag":"설정","count":505},{"language":"pt-BR","tag":"Configurações","count":505},{"language":"ru","tag":"Настройки","count":505},{"language":"zh","tag":"设置","count":505},{"language":"en","tag":"Functions","count":330},{"language":"ar","tag":"الدوال","count":328},{"language":"es","tag":"Funciones","count":328},{"language":"fr","tag":"Fonctions","count":328},{"language":"ja","tag":"関数","count":328},{"language":"ko","tag":"함수","count":328},{"language":"pt-BR","tag":"Funções","count":328},{"language":"ru","tag":"Функции","count":328},{"language":"zh","tag":"函数","count":328},{"language":"en","tag":"Integrations","count":300},{"language":"ko","tag":"통합","count":296},{"language":"zh","tag":"集成","count":296},{"language":"ar","tag":"التكاملات","count":293},{"language":"es","tag":"Integraciones","count":293},{"language":"fr","tag":"Intégrations","count":293},{"language":"pt-BR","tag":"Integrações","count":293},{"language":"ru","tag":"Интеграции","count":293},{"language":"pt-BR","tag":"Recursos","count":291},{"language":"ja","tag":"インテグレーション","count":268},{"language":"en","tag":"Session Settings","count":261},{"language":"ar","tag":"إعدادات session","count":260},{"language":"es","tag":"Configuración de sesión","count":260},{"language":"fr","tag":"Paramètres de session","count":260},{"language":"ja","tag":"session 設定","count":260},{"language":"ko","tag":"세션 설정","count":260},{"language":"pt-BR","tag":"Configurações de sessão","count":260},{"language":"ru","tag":"Настройки сеанса","count":260},{"language":"zh","tag":"会话设置","count":260},{"language":"en","tag":"ClickHouse Cloud","count":257},{"language":"ar","tag":"ClickHouse Cloud","count":255},{"language":"es","tag":"ClickHouse Cloud","count":255},{"language":"fr","tag":"ClickHouse Cloud","count":255},{"language":"ja","tag":"ClickHouse Cloud","count":255},{"language":"ko","tag":"ClickHouse Cloud","count":255},{"language":"pt-BR","tag":"ClickHouse Cloud","count":255},{"language":"ru","tag":"ClickHouse Cloud","count":255},{"language":"zh","tag":"ClickHouse Cloud","count":255},{"language":"ar","tag":"أدلة إرشادية","count":219},{"language":"en","tag":"Guides","count":219},{"language":"es","tag":"Guías","count":219},{"language":"fr","tag":"Guides","count":219},{"language":"ja","tag":"ガイド","count":219},{"language":"ko","tag":"가이드","count":219},{"language":"pt-BR","tag":"Guias","count":219},{"language":"ru","tag":"Руководства","count":219},{"language":"zh","tag":"指南","count":219},{"language":"ar","tag":"الموارد","count":213},{"language":"en","tag":"Resources","count":213},{"language":"es","tag":"Recursos","count":213},{"language":"fr","tag":"Ressources","count":213},{"language":"ja","tag":"リソース","count":213},{"language":"ko","tag":"자료","count":213},{"language":"ru","tag":"Ресурсы","count":213},{"language":"zh","tag":"资源","count":213},{"language":"default","tag":"Solutions","count":131},{"language":"default","tag":"ClickHouse Cloud","count":131},{"language":"default","tag":"Cloud API","count":88},{"language":"default","tag":"API reference","count":88},{"language":"default","tag":"ClickHouse Private","count":43},{"language":"default","tag":"Service","count":34},{"language":"default","tag":"ClickStack","count":31},{"language":"default","tag":"Organization","count":21},{"language":"default","tag":"How-To Guides","count":18},{"language":"default","tag":"Postgres","count":18}],"searchSettings":{"maxResults":1}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"github-push-net-diff","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"_site/styles.css","href":"/docs/_mintlify/custom/private-7c7dfe99/958868d97d3973c3/_site/styles.css"},{"filePath":"snippets/components/Badges/badges_styles.css","content":".betaBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.betaBadge::before{content:\"β\";flex:0 0 auto;margin-right:8px;font-size:1rem;font-weight:600;line-height:1}a.betaBadge{color:#1D4ED8!important;text-decoration:none!important}.dark .betaBadge{background-color:#1E3A6B;color:#93C5FD}.dark a.betaBadge{color:#93C5FD!important;text-decoration:none!important}.ClickHouseSupportedBadge{background-color:#faff69;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#161517;display:inline-flex;margin-right:5px;font-size:0.875rem}.ClickHouseSupportedIcon{margin-right:8px}.ClickHouseSupportedIcon svg path{fill:#282828}.ClickHouseSupportedBadge a{color:black}.dark .ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.dark .ClickHouseSupportedBadge a{color:#161517}.dark .ClickHouseSupportedIcon svg path{fill:#161517}.cloudNotSupportedBadge{background-color:#F6E5FF;color:#660099;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.cloudNotSupportedIcon{margin-right:8px}a.cloudNotSupportedBadge{color:#660099!important;text-decoration:none!important}.cloudNotSupportedIcon svg path{stroke:#660099}.dark .cloudNotSupportedBadge{background-color:#33004D;color:#EECCFF}.dark a.cloudNotSupportedBadge{color:#EECCFF!important;text-decoration:none!important}.dark .cloudNotSupportedIcon svg path{stroke:#EECCFF}.cloudBadge{background-color:#DAE6FC;color:#061D48;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .cloudBadge{background-color:#061D48;color:#DAE6FC}.cloudIcon{margin-right:8px}.cloudIcon svg path{stroke:#061D48}.dark .cloudIcon svg path{stroke:#DAE6FC}.CommunityMaintainedBadge{background-color:#69afff;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.CommunityMaintainedIcon{margin-right:8px}.CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.CommunityMaintainedBadge a{color:#69afff}.CommunityMaintainedBadge svg path{color:#69afff}.dark .CommunityMaintainedBadge{background-color:#69afff;color:#ffffff}.dark .CommunityMaintainedBadge a{color:#ffffff}.dark .CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.deprecatedBadge{background-color:#DFDFDF;color:#53575F;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.deprecatedIcon{margin-right:8px}.deprecatedBadge a{color:inherit}.dark .deprecatedBadge{background-color:#414141;color:#E6E7E9}.dark .deprecatedBadge a{color:inherit}.deprecatedIcon svg path{stroke:#53575F}.dark .deprecatedIcon svg path{stroke:#E6E7E9}.enterprisePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.enterprisePlanFeatureContainer p{margin:0;padding:0}.enterprisePlanFeatureBadge{background-color:#008A0B;border-style:solid;border:1px;border-color:#437EEF;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .enterprisePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .enterprisePlanFeatureBadge{background-color:#99FFA1;color:#1F1F1C}.experimentalBadge{background-color:#F3E8FF;border-radius:16px;color:#6D28D9;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.experimentalIcon{margin-right:8px}a.experimentalBadge{color:#6D28D9!important;text-decoration:none!important}.dark .experimentalBadge{background-color:#3B1D6B;color:#D8B4FE}.dark a.experimentalBadge{color:#D8B4FE!important;text-decoration:none!important}.experimentalIcon svg path{stroke:#6D28D9}.dark .experimentalIcon svg path{stroke:#D8B4FE}.PartnerBadge{background-color:#990073;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.PartnerBadgeIcon{margin-right:8px}.PartnerBadgeIcon svg path{fill:#fbc9ef;stroke:#990073}.PartnerBadge a{color:#990073}.PartnerBadge svg path{color:#990073}.dark .PartnerBadge{background-color:#990073;color:#fbeff8}.dark .PartnerBadge a{color:#fbeff8}.dark .PartnerBadgeIcon svg path{fill:#990073;stroke:#fbeff8}.privatePreviewBadge{background-color:#FEF3C7;color:#B45309;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .privatePreviewBadge{background-color:#4B3410;color:#FCD34D}.privatePreviewIcon{margin-right:8px}.privatePreviewIcon svg path{stroke:#B45309}.dark .privatePreviewIcon svg path{stroke:#FCD34D}.publicPreviewBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .publicPreviewBadge{background-color:#1E3A6B;color:#93C5FD}.scalePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.scalePlanFeatureContainer p{margin:0;padding:0}.scalePlanFeatureBadge{background-color:#1D64EC;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .scalePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .scalePlanFeatureBadge{background-color:#1D64EC;color:#FFFFFF}"},{"filePath":"snippets/components/ClickStackAnimation/ClickStackAnimation.css","content":".clickstack-animation-wrapper{width:100%;max-width:max-content;transition:opacity 0.3s ease}.clickstack-animation-inner{transform-origin:top left}.clickstack-grid{display:grid;width:537px;height:537px;grid-template-columns:repeat(3, 1fr);grid-template-rows:repeat(3, 1fr)}.clickstack-grid-item{position:relative;display:flex;align-items:center;justify-content:center}.clickstack-grid-column{display:flex;flex-direction:column;align-items:center}.clickstack-icon-box{display:flex;width:4rem;height:4rem;align-items:center;justify-content:center;border-radius:0.375rem;padding:1rem;flex-shrink:0;border:1px solid rgba(113, 113, 122, 0.8);background-color:#171717}.clickstack-svg-absolute{position:absolute}.clickstack-svg-left-center{left:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-right-center{right:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-bottom-left{bottom:50%;left:50%;transform:translateY(-2rem)}.clickstack-svg-bottom-right{bottom:50%;right:50%;transform:translateY(-2rem)}.clickstack-logo-container{position:relative}.clickstack-logo-glow{position:absolute;inset:0;z-index:0;animation:fadeInOut 3s ease-in-out infinite;background-color:rgba(250, 255, 105, 0.6);filter:blur(40px)}.clickstack-logo-box{position:absolute;inset:0;z-index:10;display:flex;border-radius:0.5rem;border:2px solid #faff69;background-color:#262626;background-image:linear-gradient(to bottom right, rgba(250, 255, 105, 0.2), rgba(250, 255, 105, 0.4))}.clickstack-logo-svg{margin:auto}@keyframes fadeInOut{0%,100%{opacity:0.3}50%{opacity:0.8}}:is(.light) .clickstack-logo-glow{display:none}:is(.light) .clickstack-logo-box{border-color:#faff69;background-color:#000000;background-image:none}.clickstack-line-bg{stroke:#414141}.clickstack-line-animated{stroke:#faff69}:is(.light) .clickstack-line-bg{stroke:#d4d4d8}:is(.light) .clickstack-line-animated{stroke:#a1a1aa}@media (max-width: 767px){.clickstack-animation-wrapper{max-width:400px}.clickstack-grid{width:400px;height:400px}}"}],"page":{"pagePath":"pt-BR/reference/functions/regular-functions/in-functions","slug":"/pt-BR/reference/functions/regular-functions/in-functions","pageMetadata":{"description":"Documentação das funções para implementação do operador IN","sidebarTitle":"Operador IN","slug":"/sql-reference/functions/in-functions","title":"Funções para implementação do operador IN","doc_type":"reference","href":"/pt-BR/reference/functions/regular-functions/in-functions"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Documentação das funções para implementação do operador IN\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,p:`p`,..._provideComponents(),...props.components},{Heading}=_components;if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsx(`div`,{id:`in-notin-globalin-globalnotin`,children:_jsx(Heading,{level:`2`,id:`in-notin-globalin-globalnotin`,children:`in, notIn, globalIn, globalNotIn`})}),`\n`,_jsxs(_components.p,{children:[`Consulte a seção `,_jsx(_components.a,{href:`/pt-BR/reference/statements/in`,children:`operadores IN`}),`.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"description":"Documentação das funções para implementação do operador IN","sidebarTitle":"Operador IN","slug":"/sql-reference/functions/in-functions","title":"Funções para implementação do operador IN","doc_type":"reference","href":"/pt-BR/reference/functions/regular-functions/in-functions"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"in, notIn, globalIn, globalNotIn","slug":"in-notin-globalin-globalnotin","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/private-7c7dfe99/a0ab956a7a3c7ff5/_site/customizations/ask-ai-button.js","/docs/_mintlify/custom/private-7c7dfe99/39eb0ad87fa3adc8/_site/customizations/clickhouse-sql-highlight.js","/docs/_mintlify/custom/private-7c7dfe99/f2f887f569696d41/_site/customizations/clickhouse-sql-lexer-wasm.js","/docs/_mintlify/custom/private-7c7dfe99/564839e4bb02c38e/_site/customizations/custom-footer.js","/docs/_mintlify/custom/private-7c7dfe99/240e3ba1823c3bae/_site/customizations/galaxy.js","/docs/_mintlify/custom/private-7c7dfe99/38fd3c627bad5620/_site/customizations/inkeep-init.js","/docs/_mintlify/custom/private-7c7dfe99/ad7415752a665282/_site/customizations/kapa-init.js","/docs/_mintlify/custom/private-7c7dfe99/c54d4536629b44db/_site/customizations/nav-icon-preload.js","/docs/_mintlify/custom/private-7c7dfe99/10c01e58e00a0bb5/_site/customizations/navbar-cta.js","/docs/_mintlify/custom/private-7c7dfe99/f75dab9369f45602/_site/customizations/raise-issue-link.js","/docs/_mintlify/custom/private-7c7dfe99/a97e716bfafb62fd/_site/customizations/scroll-reset.js","/docs/_mintlify/custom/private-7c7dfe99/bb66ab6ab59dfc53/_site/customizations/settings-legacy-redirect.js","/docs/_mintlify/custom/private-7c7dfe99/0bfa7a5d239909b5/_site/customizations/settings-legacy-routes/format-settings.js","/docs/_mintlify/custom/private-7c7dfe99/2e7591b344c72658/_site/customizations/settings-legacy-routes/mergetree-settings.js","/docs/_mintlify/custom/private-7c7dfe99/0e5c09ef2a5b216d/_site/customizations/settings-legacy-routes/server-settings.js","/docs/_mintlify/custom/private-7c7dfe99/c131aa6d7f43b229/_site/customizations/settings-legacy-routes/session-settings.js","/docs/_mintlify/custom/private-7c7dfe99/3bd87f000900d6e2/_site/customizations/tab-nav.js","/docs/_mintlify/custom/private-7c7dfe99/5c7ce50607c95a70/_site/customizations/webterminal.js","/docs/_mintlify/custom/private-7c7dfe99/7b903fec76456ee0/_site/customizations/cloud-sidebar-ad.js","/docs/_mintlify/custom/private-7c7dfe99/346eac2572f9fb1d/_site/customizations/section-ticker.js"],"subdomain":"private-7c7dfe99","siteName":"ClickHouse Documentation","title":"Funções para implementação do operador IN - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/reference/functions/regular-functions/in-functions","matchLevel":1},"ar":{"href":"/ar/reference/functions/regular-functions/in-functions","matchLevel":1},"es":{"href":"/es/reference/functions/regular-functions/in-functions","matchLevel":1},"fr":{"href":"/fr/reference/functions/regular-functions/in-functions","matchLevel":1},"ja":{"href":"/ja/reference/functions/regular-functions/in-functions","matchLevel":1},"ko":{"href":"/ko/reference/functions/regular-functions/in-functions","matchLevel":1},"pt-BR":{"href":"/pt-BR/reference/functions/regular-functions/in-functions","matchLevel":0},"ru":{"href":"/ru/reference/functions/regular-functions/in-functions","matchLevel":1},"zh":{"href":"/zh/reference/functions/regular-functions/in-functions","matchLevel":1}}},"originalFileLocation":"pt-BR/reference/functions/regular-functions/in-functions.mdx","locale":"pt-BR"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"dark\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Documentação das funções para implementação do operador IN\">\u003cmeta data-mint-head name=\"application-name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Funções para implementação do operador IN - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Documentação das funções para implementação do operador IN\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://private-7c7dfe99.mintlify.app/_mintlify/api/og/v2?division=Fun%C3%A7%C3%B5es+regulares\u0026amp;title=Fun%C3%A7%C3%B5es+para+implementa%C3%A7%C3%A3o+do+operador+IN\u0026amp;description=Documenta%C3%A7%C3%A3o+das+fun%C3%A7%C3%B5es+para+implementa%C3%A7%C3%A3o+do+operador+IN\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=43a0141e1d6ee53bdfbf16d6c9dc15a0416c34ce8aad2f159086f5863c11be56\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Funções para implementação do operador IN - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Documentação das funções para implementação do operador IN\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.app/_mintlify/api/og/v2?division=Fun%C3%A7%C3%B5es+regulares\u0026amp;title=Fun%C3%A7%C3%B5es+para+implementa%C3%A7%C3%A3o+do+operador+IN\u0026amp;description=Documenta%C3%A7%C3%A3o+das+fun%C3%A7%C3%B5es+para+implementa%C3%A7%C3%A3o+do+operador+IN\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=43a0141e1d6ee53bdfbf16d6c9dc15a0416c34ce8aad2f159086f5863c11be56\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#1c1c1c\">\u003clink data-mint-head rel=\"canonical\" href=\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/pt-BR/reference/functions/regular-functions/in-functions.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/reference/functions/regular-functions/in-functions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/reference/functions/regular-functions/in-functions\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://clickhouse.com/#organization\",\"name\":\"ClickHouse Documentation\",\"url\":\"https://clickhouse.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/light.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=b8a838f982def2b530a95016300bc7ec\"}},{\"@type\":\"WebSite\",\"@id\":\"https://clickhouse.com/docs#website\",\"name\":\"ClickHouse Documentation\",\"url\":\"https://clickhouse.com/docs\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions#webpage\",\"url\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions\",\"name\":\"Funções para implementação do operador IN\",\"description\":\"Documentação das funções para implementação do operador IN\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funções\",\"item\":\"https://clickhouse.com/docs/pt-BR/reference/functions/index\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Funções regulares\",\"item\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/overview\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Funções para implementação do operador IN\",\"item\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions#article\",\"headline\":\"Funções para implementação do operador IN\",\"name\":\"Funções para implementação do operador IN\",\"description\":\"Documentação das funções para implementação do operador IN\",\"url\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/functions/regular-functions/in-functions#webpage\"},\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"},\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"}}]}\u003c/script>","siteName":"ClickHouse Documentation","nav":{"global":null,"languages":[{"language":"en","pages":[{"title":"en","href":"/reference/functions/regular-functions/in-functions"}]},{"language":"ar","pages":[{"title":"ar","href":"/ar/reference/functions/regular-functions/in-functions"}]},{"language":"es","pages":[{"title":"es","href":"/es/reference/functions/regular-functions/in-functions"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/reference/functions/regular-functions/in-functions"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/reference/functions/regular-functions/in-functions"}]},{"language":"ko","pages":[{"title":"ko","href":"/ko/reference/functions/regular-functions/in-functions"}]},{"language":"pt-BR","tabs":[{"tab":"Início","pages":[{"title":"Início","href":"/pt-BR"}]},{"tab":"Banco de dados","menu":[{"item":"Primeiros passos","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-get-started.svg","pages":[{"group":"Primeiros passos","icon":"/images/menu-icon-lightning.svg","pages":[{"title":"Comece a usar o ClickHouse","sidebarTitle":"Visão geral","href":"/pt-BR/get-started"},{"group":"Guias de início rápido","expanded":false,"pages":[{"sidebarTitle":"Explorar guias de início rápido","title":"Explorador dos guias de início rápido","mode":"custom","href":"/pt-BR/get-started/quickstarts/home"},{"group":"Todos os casos de uso","expanded":false,"pages":[{"sidebarTitle":"Início rápido na Cloud","title":"Início rápido do ClickHouse Cloud","href":"/pt-BR/get-started/setup/cloud"},{"sidebarTitle":"Obtenha os detalhes de conexão do Cloud","title":"Obtenha os detalhes de conexão do Cloud","href":"/pt-BR/get-started/quickstarts/obtain-your-cloud-connection-details"},{"sidebarTitle":"Inserir dados no ClickHouse Cloud usando clickhouse-client","title":"Inserir dados no ClickHouse Cloud usando clickhouse-client","href":"/pt-BR/get-started/quickstarts/insert-data-using-clickhouse-client"},{"sidebarTitle":"Criando tabelas no ClickHouse","title":"Criando tabelas no ClickHouse","href":"/pt-BR/get-started/quickstarts/creating-tables"},{"sidebarTitle":"Selecionando dados do ClickHouse","title":"Selecionando dados do ClickHouse","href":"/pt-BR/get-started/quickstarts/writing-queries"},{"sidebarTitle":"Crie sua primeira tabela MergeTree","title":"Crie sua primeira tabela MergeTree","href":"/pt-BR/get-started/quickstarts/create-your-first-mergetree-table"}]},{"group":"Analytics em tempo real","expanded":false,"pages":[{"sidebarTitle":"Crie sua primeira visão materializada","title":"Crie sua primeira visão materializada","href":"/pt-BR/get-started/quickstarts/create-your-first-materialized-view"},{"sidebarTitle":"Crie sua primeira projeção","title":"Crie sua primeira projeção","href":"/pt-BR/get-started/quickstarts/create-your-first-projection"}]},{"group":"Armazenamento de dados","expanded":false,"pages":[{"sidebarTitle":"Como conectar seu catálogo Iceberg ao ClickHouse Cloud","title":"Como conectar seu catálogo Iceberg ao ClickHouse Cloud","href":"/pt-BR/get-started/quickstarts/connect-your-iceberg-catalog"},{"sidebarTitle":"Atualização e exclusão de dados no ClickHouse","title":"Atualização e exclusão de dados no ClickHouse","href":"/pt-BR/get-started/quickstarts/mutations"}]},{"group":"Observabilidade","expanded":false,"pages":[{"sidebarTitle":"Trabalhando com o tipo Map no ClickHouse","title":"Trabalhando com o tipo Map no ClickHouse","href":"/pt-BR/get-started/quickstarts/working-with-the-map-type"}]}]},{"group":"Introdução","expanded":true,"pages":[{"sidebarTitle":"O que é ClickHouse?","title":"O que é ClickHouse?","href":"/pt-BR/get-started/about/intro"},{"sidebarTitle":"Por que o ClickHouse é tão rápido?","title":"Por que o ClickHouse é tão rápido?","href":"/pt-BR/get-started/about/why-clickhouse-is-so-fast"},{"sidebarTitle":"Por que o ClickHouse é único?","title":"Diferenciais do ClickHouse","href":"/pt-BR/get-started/about/distinctive-features"}]},{"group":"Casos de uso","expanded":true,"pages":[{"title":"Casos de uso","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/use-cases/overview"},{"title":"Escolha um serviço para sua carga de trabalho","sidebarTitle":"Escolha um serviço","href":"/pt-BR/get-started/use-cases/choosing-a-service"},{"title":"Analytics em tempo real","sidebarTitle":"Analytics em tempo real","href":"/pt-BR/get-started/use-cases/real-time-analytics"},{"title":"Observabilidade","sidebarTitle":"Observabilidade","href":"/pt-BR/get-started/use-cases/observability"},{"title":"Armazenamento de dados","sidebarTitle":"Armazenamento de dados","href":"/pt-BR/get-started/use-cases/data-warehousing"},{"title":"Análises agênticas","sidebarTitle":"Análises agênticas","href":"/pt-BR/get-started/use-cases/agentic-analytics"}]},{"sidebarTitle":"Modos de implantação","title":"Modos de implantação","href":"/pt-BR/get-started/about/deployment-modes"}]},{"group":"Configuração","icon":"/images/menu-icon-gear.svg","expanded":true,"pages":[{"sidebarTitle":"Instalar","title":"Instruções de instalação","href":"/pt-BR/get-started/setup/install"},{"sidebarTitle":"Início rápido na Cloud","title":"Início rápido do ClickHouse Cloud","href":"/pt-BR/get-started/setup/cloud"},{"group":"Autogerenciado","expanded":true,"pages":[{"title":"Instalação autogerenciada","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/setup/self-managed/overview"},{"group":"Desenvolvimento local","pages":[{"sidebarTitle":"Instalação rápida","title":"Instalação rápida","href":"/pt-BR/get-started/setup/self-managed/quick-install"},{"sidebarTitle":"clickhousectl (CLI)","title":"Instalar com a ClickHouse CLI","href":"/pt-BR/get-started/setup/self-managed/clickhousectl"},{"sidebarTitle":"Docker","title":"Instale o ClickHouse usando o Docker","href":"/pt-BR/get-started/setup/self-managed/docker"},{"sidebarTitle":"Compilações de código-fonte e de CI","title":"Compilações de código-fonte e de CI","href":"/pt-BR/get-started/setup/self-managed/advanced"}]},{"group":"Servidor de produção","pages":[{"sidebarTitle":"Debian/Ubuntu","title":"Instalar o ClickHouse em Debian/Ubuntu","href":"/pt-BR/get-started/setup/self-managed/debian-ubuntu"},{"sidebarTitle":"Red Hat/CentOS","title":"Instale o ClickHouse em distribuições Linux baseadas em rpm","href":"/pt-BR/get-started/setup/self-managed/redhat"},{"sidebarTitle":"NixOS","title":"Instalar o ClickHouse no NixOS","href":"/pt-BR/get-started/setup/self-managed/nixos"},{"sidebarTitle":"Outras versões do Linux","title":"Instalar o ClickHouse usando arquivos tgz","href":"/pt-BR/get-started/setup/self-managed/other-linux"}]}]}]},{"group":"Conjuntos de dados de exemplo","icon":"/images/menu-icon-database.svg","expanded":true,"pages":[{"sidebarTitle":"Visão geral","title":"Tutoriais e conjuntos de dados de exemplo","href":"/pt-BR/get-started/sample-datasets/index"},{"sidebarTitle":"ClickHouse playground","title":"ClickHouse playground","href":"/pt-BR/get-started/sample-datasets/playground"},{"group":"Testes de desempenho","pages":[{"sidebarTitle":"benchmark de big data AMPLab","title":"Benchmark de Big Data AMPLab","href":"/pt-BR/get-started/sample-datasets/amplab-benchmark"},{"sidebarTitle":"Benchmark da Brown University","title":"Benchmark da Brown University","href":"/pt-BR/get-started/sample-datasets/brown-benchmark"},{"sidebarTitle":"Logs de cliques de 1 TB da Criteo","title":"Logs de cliques de um terabyte da Criteo","href":"/pt-BR/get-started/sample-datasets/criteo"},{"title":"Join Order Benchmark (JOB)","sidebarTitle":"JOB","href":"/pt-BR/get-started/sample-datasets/job"},{"sidebarTitle":"Star Schema Benchmark","title":"Star Schema Benchmark (SSB, 2009)","href":"/pt-BR/get-started/sample-datasets/star-schema"},{"title":"TPC-DS (2012)","sidebarTitle":"TPC-DS","href":"/pt-BR/get-started/sample-datasets/tpcds"},{"title":"TPC-H (1999)","sidebarTitle":"TPC-H","href":"/pt-BR/get-started/sample-datasets/tpch"}]},{"group":"Busca vetorial e embeddings","pages":[{"sidebarTitle":"conjunto de dados dbpedia","title":"conjunto de dados dbpedia","href":"/pt-BR/get-started/sample-datasets/dbpedia"},{"sidebarTitle":"Conjunto de dados para busca vetorial do Hacker News","title":"Conjunto de dados para busca vetorial do Hacker News","href":"/pt-BR/get-started/sample-datasets/hacker-news-vector-search"},{"sidebarTitle":"Conjunto de dados Laion-400M","title":"Conjunto de dados Laion-400M","href":"/pt-BR/get-started/sample-datasets/laion"},{"sidebarTitle":"conjunto de dados LAION 5B","title":"conjunto de dados LAION 5B","href":"/pt-BR/get-started/sample-datasets/laion5b"}]},{"group":"Analytics da web e de redes sociais","pages":[{"sidebarTitle":"Avaliações de clientes da Amazon","title":"Avaliações de clientes da Amazon","href":"/pt-BR/get-started/sample-datasets/amazon-reviews"},{"sidebarTitle":"Análise da web anonimizada","title":"Análise da web anonimizada","href":"/pt-BR/get-started/sample-datasets/anon-web-analytics-metrica"},{"sidebarTitle":"Repositório do GitHub","title":"Escrevendo consultas no ClickHouse com dados do GitHub","href":"/pt-BR/get-started/sample-datasets/github"},{"sidebarTitle":"Eventos do GitHub","title":"Conjunto de dados de eventos do GitHub","href":"/pt-BR/get-started/sample-datasets/github-events"},{"sidebarTitle":"Hacker News","title":"Conjunto de dados do Hacker News","href":"/pt-BR/get-started/sample-datasets/hacker-news"},{"sidebarTitle":"Stack Overflow","title":"Análise de dados do Stack Overflow com ClickHouse","href":"/pt-BR/get-started/sample-datasets/stackoverflow"},{"sidebarTitle":"Não gostei do YouTube","title":"Dataset do YouTube com não gostei","href":"/pt-BR/get-started/sample-datasets/youtube-dislikes"}]},{"group":"Geoespacial e localização","pages":[{"sidebarTitle":"Torres de celular","title":"Análise geoespacial com o conjunto de dados de torres de celular","href":"/pt-BR/get-started/sample-datasets/cell-towers"},{"sidebarTitle":"Foursquare OS Places","title":"Conjunto de dados Foursquare OS Places","href":"/pt-BR/get-started/sample-datasets/foursquare-os-places"},{"sidebarTitle":"Dados de táxis de Nova York","title":"Análise geoespacial com o conjunto de dados de táxis de Nova York","href":"/pt-BR/get-started/sample-datasets/nyc-taxi"}]},{"group":"Séries temporais e sensores","pages":[{"sidebarTitle":"Dados de sensores ambientais","title":"Dados de sensores ambientais","href":"/pt-BR/get-started/sample-datasets/environmental-sensors"},{"sidebarTitle":"NOAA Global Historical Climatology Network ","title":"NOAA Global Historical Climatology Network","href":"/pt-BR/get-started/sample-datasets/noaa"},{"sidebarTitle":"Datasets históricos de meteorologia de Taiwan","title":"Datasets históricos de meteorologia de Taiwan","href":"/pt-BR/get-started/sample-datasets/tw-weather"},{"sidebarTitle":"WikiStat","title":"WikiStat","href":"/pt-BR/get-started/sample-datasets/wikistat"}]},{"group":"Registros públicos e dados abertos","pages":[{"sidebarTitle":"dados abertos da COVID-19","title":"dados abertos da COVID-19","href":"/pt-BR/get-started/sample-datasets/covid19"},{"sidebarTitle":"dataset \"what's on the menu?\" da New York Public Library","title":"dataset \"What's on the Menu?\" da New York Public Library","href":"/pt-BR/get-started/sample-datasets/menus"},{"sidebarTitle":"dados de ocorrências do NYPD","title":"dados de ocorrências do NYPD","href":"/pt-BR/get-started/sample-datasets/nypd-complaint-data"},{"sidebarTitle":"Dados de voos OnTime de companhias aéreas","title":"OnTime","href":"/pt-BR/get-started/sample-datasets/ontime"},{"sidebarTitle":"Preços de imóveis no Reino Unido","title":"Consultas analíticas sobre dados de preços de imóveis do Reino Unido","href":"/pt-BR/get-started/sample-datasets/uk-price-paid"}]}]},{"group":"Migrar","icon":"/images/caret-double-right.svg","expanded":true,"pages":[{"sidebarTitle":"Visão geral","title":"Migrando dados para o ClickHouse","href":"/pt-BR/get-started/migrate/overview"},{"group":"PostgreSQL","pages":[{"title":"Comparação entre PostgreSQL e ClickHouse","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/migrate/postgres/overview"},{"group":"Guia de migração","pages":[{"title":"Migração de dados","sidebarTitle":"Parte 1","href":"/pt-BR/get-started/migrate/postgres/migration-guide/migration-guide-part1"},{"title":"Reescrevendo consultas do PostgreSQL","sidebarTitle":"Parte 2","href":"/pt-BR/get-started/migrate/postgres/migration-guide/migration-guide-part2"},{"title":"Técnicas de modelagem de dados","sidebarTitle":"Parte 3","href":"/pt-BR/get-started/migrate/postgres/migration-guide/migration-guide-part3"}]},{"title":"Apêndice","href":"/pt-BR/get-started/migrate/postgres/appendix"}]},{"group":"BigQuery","pages":[{"title":"Comparando ClickHouse Cloud e BigQuery","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/migrate/bigquery/overview"},{"title":"Migrando do BigQuery para o ClickHouse Cloud","sidebarTitle":"Guia de migração","href":"/pt-BR/get-started/migrate/bigquery/migrating-to-clickhouse-cloud"},{"sidebarTitle":"Carga de dados","title":"Carga de dados do BigQuery para o ClickHouse","href":"/pt-BR/get-started/migrate/bigquery/loading-data"}]},{"group":"Snowflake","pages":[{"sidebarTitle":"Visão geral","title":"Migração de Snowflake para ClickHouse","href":"/pt-BR/get-started/migrate/snowflake/overview"},{"sidebarTitle":"Guia de migração","title":"Migrando do Snowflake para o ClickHouse","href":"/pt-BR/get-started/migrate/snowflake/migration-guide"},{"sidebarTitle":"Referência de tradução SQL","title":"Migrando do Snowflake para ClickHouse","href":"/pt-BR/get-started/migrate/snowflake/sql-translation-reference"}]},{"group":"Elasticsearch","pages":[{"sidebarTitle":"Visão geral","title":"Migrar do Elasticsearch para o ClickHouse","href":"/pt-BR/get-started/migrate/elastic/overview"}]},{"group":"Redshift","pages":[{"sidebarTitle":"Visão geral","title":"Comparando o ClickHouse Cloud e o Amazon Redshift","href":"/pt-BR/get-started/migrate/redshift/overview"},{"sidebarTitle":"Guia de migração","title":"Guia de migração do Amazon Redshift para o ClickHouse","href":"/pt-BR/get-started/migrate/redshift/migration-guide"},{"sidebarTitle":"Referência de tradução de SQL","title":"Guia de tradução de SQL do Amazon Redshift","href":"/pt-BR/get-started/migrate/redshift/sql-translation-reference"}]},{"group":"Do OSS para o Cloud","pages":[{"sidebarTitle":"Usando remoteSecure","title":"Migrando entre ClickHouse autogerenciado e ClickHouse Cloud usando remoteSecure","href":"/pt-BR/get-started/migrate/oss-to-cloud/clickhouse-to-cloud"},{"sidebarTitle":"Usando BACKUP e RESTORE","title":"Migração de ClickHouse autogerenciado para ClickHouse Cloud usando comandos de backup","href":"/pt-BR/get-started/migrate/oss-to-cloud/oss-to-cloud-backup-restore"}]},{"group":"Outros métodos","pages":[{"sidebarTitle":"Como usar o clickhouse-local","title":"Como migrar para o ClickHouse usando o clickhouse-local","href":"/pt-BR/get-started/migrate/other-methods/clickhouse-local-etl"},{"sidebarTitle":"Como usar uma ferramenta ETL de terceiros","title":"Como usar uma ferramenta ETL de terceiros","href":"/pt-BR/get-started/migrate/other-methods/etl-tool-to-clickhouse"},{"title":"Mover dados do armazenamento de objetos em Cloud para o ClickHouse Cloud","href":"/pt-BR/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]}]},{"item":"Conceitos","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-concepts.svg","pages":[{"title":"Conceitos","href":"/pt-BR/concepts"}]},{"item":"Guias","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-guides.svg","pages":[{"title":"Guias","href":"/pt-BR/guides/clickhouse"}]},{"item":"Referência","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-reference.svg","pages":[{"title":"Referência","sidebarTitle":"Início","mode":"wide","href":"/pt-BR/reference/home"},{"group":"Referência de SQL","expanded":true,"pages":[{"sidebarTitle":"Sintaxe","title":"Sintaxe","href":"/pt-BR/reference/syntax"},{"group":"Instruções","expanded":false,"pages":[{"sidebarTitle":"Lista de instruções","title":"Instruções SQL do ClickHouse","href":"/pt-BR/reference/statements/index"},{"group":"ALTER","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"ALTER","href":"/pt-BR/reference/statements/alter/index"},{"sidebarTitle":"APPLY DELETED MASK","title":"ALTER TABLE ... APPLY DELETED MASK","href":"/pt-BR/reference/statements/alter/apply-deleted-mask"},{"sidebarTitle":"APPLY PATCHES","title":"ALTER TABLE ... APPLY PATCHES","href":"/pt-BR/reference/statements/alter/apply-patches"},{"sidebarTitle":"COLUMN","title":"ALTER TABLE ... COLUMN","href":"/pt-BR/reference/statements/alter/column"},{"sidebarTitle":"ALTER TABLE ... MODIFY COMMENT","title":"ALTER TABLE ... MODIFY COMMENT","href":"/pt-BR/reference/statements/alter/comment"},{"sidebarTitle":"CONSTRAINT","title":"ALTER TABLE ... CONSTRAINT","href":"/pt-BR/reference/statements/alter/constraint"},{"sidebarTitle":"ALTER DATABASE ... MODIFY COMMENT","title":"ALTER DATABASE ... MODIFY COMMENT","href":"/pt-BR/reference/statements/alter/database-comment"},{"sidebarTitle":"DELETE","title":"ALTER TABLE ... DELETE","href":"/pt-BR/reference/statements/alter/delete"},{"sidebarTitle":"NAMED COLLECTION","title":"ALTER NAMED COLLECTION","href":"/pt-BR/reference/statements/alter/named-collection"},{"sidebarTitle":"ORDER BY","title":"ALTER TABLE ... MODIFY ORDER BY","href":"/pt-BR/reference/statements/alter/order-by"},{"sidebarTitle":"PARTITION","title":"ALTER TABLE ... PARTITION","href":"/pt-BR/reference/statements/alter/partition"},{"sidebarTitle":"PROJECTION","title":"ALTER TABLE ... PROJECTION","href":"/pt-BR/reference/statements/alter/projection"},{"sidebarTitle":"QUOTA","title":"ALTER QUOTA","href":"/pt-BR/reference/statements/alter/quota"},{"sidebarTitle":"ROLE","title":"ALTER ROLE","href":"/pt-BR/reference/statements/alter/role"},{"sidebarTitle":"ROW POLICY","title":"ALTER ROW POLICY","href":"/pt-BR/reference/statements/alter/row-policy"},{"sidebarTitle":"SAMPLE BY","title":"ALTER TABLE ... MODIFY SAMPLE BY","href":"/pt-BR/reference/statements/alter/sample-by"},{"sidebarTitle":"SETTING","title":"ALTER TABLE ... MODIFY SETTING","href":"/pt-BR/reference/statements/alter/setting"},{"sidebarTitle":"SETTINGS PROFILE","title":"ALTER SETTINGS PROFILE","href":"/pt-BR/reference/statements/alter/settings-profile"},{"sidebarTitle":"INDEX","title":"ALTER TABLE ... INDEX","href":"/pt-BR/reference/statements/alter/skipping-index"},{"sidebarTitle":"STATISTICS","title":"ALTER TABLE ... STATISTICS","href":"/pt-BR/reference/statements/alter/statistics"},{"sidebarTitle":"TTL","title":"ALTER TABLE ... MODIFY TTL","href":"/pt-BR/reference/statements/alter/ttl"},{"sidebarTitle":"UPDATE","title":"ALTER TABLE ... UPDATE","href":"/pt-BR/reference/statements/alter/update"},{"sidebarTitle":"USER","title":"ALTER USER","href":"/pt-BR/reference/statements/alter/user"},{"sidebarTitle":"POLÍTICA DE MASCARAMENTO","title":"ALTER MASKING POLICY","href":"/pt-BR/reference/statements/alter/masking-policy"},{"sidebarTitle":"VIEW","title":"ALTER TABLE ... MODIFY QUERY","href":"/pt-BR/reference/statements/alter/view"}]},{"sidebarTitle":"ATTACH","title":"ATTACH","href":"/pt-BR/reference/statements/attach"},{"sidebarTitle":"CHECK GRANT","title":"CHECK GRANT","href":"/pt-BR/reference/statements/check-grant"},{"sidebarTitle":"CHECK DATABASE","title":"CHECK DATABASE","href":"/pt-BR/reference/statements/check-database"},{"sidebarTitle":"CHECK TABLE","title":"CHECK TABLE","href":"/pt-BR/reference/statements/check-table"},{"group":"CREATE","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"CREATE","href":"/pt-BR/reference/statements/create/index"},{"sidebarTitle":"DATABASE","title":"CREATE DATABASE","href":"/pt-BR/reference/statements/create/database"},{"group":"DICTIONARY","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"CREATE DICTIONARY","href":"/pt-BR/reference/statements/create/dictionary"},{"sidebarTitle":"Atributos","title":"Atributos do Dicionário","href":"/pt-BR/reference/statements/create/dictionary/attributes"},{"sidebarTitle":"Dicionários integrados","title":"Dicionários integrados (geobase)","href":"/pt-BR/reference/statements/create/dictionary/embedded"},{"sidebarTitle":"LIFETIME","title":"Atualização dos dados do dicionário usando LIFETIME","href":"/pt-BR/reference/statements/create/dictionary/lifetime"},{"group":"Layouts","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Layouts de dicionários","href":"/pt-BR/reference/statements/create/dictionary/layouts/overview"},{"title":"layout flat de dicionário","sidebarTitle":"flat","href":"/pt-BR/reference/statements/create/dictionary/layouts/flat"},{"title":"tipos de layout hashed para dicionários","sidebarTitle":"hashed","href":"/pt-BR/reference/statements/create/dictionary/layouts/hashed"},{"title":"tipos de layout de dicionário hashed_array","sidebarTitle":"hashed_array","href":"/pt-BR/reference/statements/create/dictionary/layouts/hashed-array"},{"title":"layout de dicionário cache","sidebarTitle":"cache","href":"/pt-BR/reference/statements/create/dictionary/layouts/cache"},{"title":"tipos de layout do dicionário ssd_cache","sidebarTitle":"ssd_cache","href":"/pt-BR/reference/statements/create/dictionary/layouts/ssd-cache"},{"title":"layout direct de dicionário","sidebarTitle":"direct","href":"/pt-BR/reference/statements/create/dictionary/layouts/direct"},{"title":"tipos de layout do dicionário range_hashed","sidebarTitle":"range_hashed","href":"/pt-BR/reference/statements/create/dictionary/layouts/range-hashed"},{"title":"Dicionários hierárquicos","sidebarTitle":"Hierárquico","href":"/pt-BR/reference/statements/create/dictionary/layouts/hierarchical"},{"title":"Dicionários Naive Bayes","sidebarTitle":"Naive Bayes","href":"/pt-BR/reference/statements/create/dictionary/layouts/naive-bayes"},{"title":"Dicionários de polígono","sidebarTitle":"polígono","href":"/pt-BR/reference/statements/create/dictionary/layouts/polygon"},{"title":"layout de dicionário ip_trie","sidebarTitle":"ip_trie","href":"/pt-BR/reference/statements/create/dictionary/layouts/ip-trie"},{"title":"Layout de dicionário de árvore regexp","sidebarTitle":"Regexp Tree","href":"/pt-BR/reference/statements/create/dictionary/layouts/regexp-tree"}]},{"group":"Fontes","expanded":false,"pages":[{"title":"Fontes de dicionário","sidebarTitle":"Visão geral","href":"/pt-BR/reference/statements/create/dictionary/sources/overview"},{"title":"Origem de dicionário de arquivo local","sidebarTitle":"Arquivo local","href":"/pt-BR/reference/statements/create/dictionary/sources/local-file"},{"title":"Fonte de dicionário de arquivo executável","sidebarTitle":"Arquivo executável","href":"/pt-BR/reference/statements/create/dictionary/sources/executable-file"},{"title":"Fonte de dicionário Executable Pool","sidebarTitle":"Executable Pool","href":"/pt-BR/reference/statements/create/dictionary/sources/executable-pool"},{"title":"Origem de dicionário HTTP(S)","sidebarTitle":"HTTP(S)","href":"/pt-BR/reference/statements/create/dictionary/sources/http"},{"title":"Fonte de dicionário do ClickHouse","sidebarTitle":"ClickHouse","href":"/pt-BR/reference/statements/create/dictionary/sources/clickhouse"},{"title":"Fonte de dicionário do MySQL","sidebarTitle":"MySQL","href":"/pt-BR/reference/statements/create/dictionary/sources/mysql"},{"title":"Fonte de dicionário PostgreSQL","sidebarTitle":"PostgreSQL","href":"/pt-BR/reference/statements/create/dictionary/sources/postgresql"},{"title":"Fonte de dicionário do MongoDB","sidebarTitle":"MongoDB","href":"/pt-BR/reference/statements/create/dictionary/sources/mongodb"},{"title":"Fonte de dicionário do Redis","sidebarTitle":"Redis","href":"/pt-BR/reference/statements/create/dictionary/sources/redis"},{"title":"Fonte de dicionário do Cassandra","sidebarTitle":"Cassandra","href":"/pt-BR/reference/statements/create/dictionary/sources/cassandra"},{"title":"Fonte de dicionário ODBC","sidebarTitle":"ODBC","href":"/pt-BR/reference/statements/create/dictionary/sources/odbc"},{"title":"Fonte de dicionário Null","sidebarTitle":"Null","href":"/pt-BR/reference/statements/create/dictionary/sources/null"},{"title":"Fonte de dicionário YAMLRegExpTree","sidebarTitle":"YAMLRegExpTree","href":"/pt-BR/reference/statements/create/dictionary/sources/yamlregexptree"},{"title":"Fonte de dicionário do YTsaurus","sidebarTitle":"YTsaurus","href":"/pt-BR/reference/statements/create/dictionary/sources/ytsaurus"}]}]},{"sidebarTitle":"POLÍTICA DE MASCARAMENTO","title":"CREATE MASKING POLICY","href":"/pt-BR/reference/statements/create/masking-policy"},{"sidebarTitle":"FUNCTION","title":"CREATE FUNCTION","href":"/pt-BR/reference/statements/create/function"},{"sidebarTitle":"HANDLER","title":"CREATE HANDLER","href":"/pt-BR/reference/statements/create/handler"},{"sidebarTitle":"NAMED COLLECTION","title":"CREATE NAMED COLLECTION","href":"/pt-BR/reference/statements/create/named-collection"},{"sidebarTitle":"QUOTA","title":"CREATE QUOTA","href":"/pt-BR/reference/statements/create/quota"},{"sidebarTitle":"ROLE","title":"CREATE ROLE","href":"/pt-BR/reference/statements/create/role"},{"sidebarTitle":"ROW POLICY","title":"CREATE ROW POLICY","href":"/pt-BR/reference/statements/create/row-policy"},{"sidebarTitle":"SETTINGS PROFILE","title":"CREATE SETTINGS PROFILE","href":"/pt-BR/reference/statements/create/settings-profile"},{"group":"TABLE","expanded":false,"pages":[{"sidebarTitle":"CREATE TABLE","title":"CREATE TABLE","href":"/pt-BR/reference/statements/create/table"},{"sidebarTitle":"CODEC","title":"CODEC","href":"/pt-BR/reference/statements/create/table/codec"},{"sidebarTitle":"TEMPORARY TABLE","title":"CREATE TEMPORARY TABLE","href":"/pt-BR/reference/statements/create/table/temporary-table"},{"sidebarTitle":"REPLACE TABLE","title":"REPLACE TABLE","href":"/pt-BR/reference/statements/create/table/replace-table"}]},{"sidebarTitle":"TOKEN","title":"CREATE TOKEN","href":"/pt-BR/reference/statements/create/token"},{"sidebarTitle":"USER","title":"CREATE USER","href":"/pt-BR/reference/statements/create/user"},{"sidebarTitle":"VIEW","title":"CREATE VIEW","href":"/pt-BR/reference/statements/create/view"}]},{"sidebarTitle":"DELETE","title":"DELETE","href":"/pt-BR/reference/statements/delete"},{"sidebarTitle":"DESCRIBE TABLE","title":"DESCRIBE TABLE","href":"/pt-BR/reference/statements/describe-table"},{"sidebarTitle":"DETACH","title":"DETACH","href":"/pt-BR/reference/statements/detach"},{"sidebarTitle":"DDL distribuído","title":"ON CLUSTER","href":"/pt-BR/reference/statements/distributed-ddl"},{"sidebarTitle":"DROP","title":"DROP","href":"/pt-BR/reference/statements/drop"},{"sidebarTitle":"EXCHANGE","title":"EXCHANGE","href":"/pt-BR/reference/statements/exchange"},{"sidebarTitle":"EXECUTE AS","title":"EXECUTE AS","href":"/pt-BR/reference/statements/execute_as"},{"sidebarTitle":"EXISTS","title":"EXISTS","href":"/pt-BR/reference/statements/exists"},{"sidebarTitle":"EXPLAIN","title":"EXPLAIN","href":"/pt-BR/reference/statements/explain"},{"sidebarTitle":"GRANT","title":"GRANT","href":"/pt-BR/reference/statements/grant"},{"sidebarTitle":"HYPOTHETICAL INDEX","title":"HYPOTHETICAL INDEX","href":"/pt-BR/reference/statements/hypothetical-index"},{"sidebarTitle":"HYPOTHETICAL PROJECTION","title":"HYPOTHETICAL PROJECTION","href":"/pt-BR/reference/statements/hypothetical-projection"},{"title":"IN","href":"/pt-BR/reference/statements/in"},{"sidebarTitle":"INSERT INTO","title":"INSERT INTO","href":"/pt-BR/reference/statements/insert-into"},{"sidebarTitle":"KILL","title":"KILL","href":"/pt-BR/reference/statements/kill"},{"sidebarTitle":"MOVE","title":"MOVE","href":"/pt-BR/reference/statements/move"},{"sidebarTitle":"OPTIMIZE","title":"OPTIMIZE","href":"/pt-BR/reference/statements/optimize"},{"sidebarTitle":"PARALLEL WITH","title":"PARALLEL WITH","href":"/pt-BR/reference/statements/parallel_with"},{"sidebarTitle":"RENAME","title":"RENAME","href":"/pt-BR/reference/statements/rename"},{"sidebarTitle":"REVOKE","title":"REVOKE","href":"/pt-BR/reference/statements/revoke"},{"group":"SELECT","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"SELECT","href":"/pt-BR/reference/statements/select/index"},{"sidebarTitle":"ALL","title":"ALL","href":"/pt-BR/reference/statements/select/all"},{"sidebarTitle":"APPLY","title":"Modificador APPLY","href":"/pt-BR/reference/statements/select/apply_modifier"},{"sidebarTitle":"ARRAY JOIN","title":"ARRAY JOIN","href":"/pt-BR/reference/statements/select/array-join"},{"sidebarTitle":"DISTINCT","title":"DISTINCT","href":"/pt-BR/reference/statements/select/distinct"},{"sidebarTitle":"EXCEPT","title":"EXCEPT","href":"/pt-BR/reference/statements/select/except"},{"sidebarTitle":"EXCEPT","title":"Modificador EXCEPT","href":"/pt-BR/reference/statements/select/except_modifier"},{"sidebarTitle":"FORMAT","title":"FORMAT","href":"/pt-BR/reference/statements/select/format"},{"sidebarTitle":"FROM","title":"FROM","href":"/pt-BR/reference/statements/select/from"},{"sidebarTitle":"GROUP BY","title":"GROUP BY","href":"/pt-BR/reference/statements/select/group-by"},{"sidebarTitle":"HAVING","title":"HAVING","href":"/pt-BR/reference/statements/select/having"},{"sidebarTitle":"INTERSECT","title":"INTERSECT","href":"/pt-BR/reference/statements/select/intersect"},{"sidebarTitle":"INTO OUTFILE","title":"INTO OUTFILE","href":"/pt-BR/reference/statements/select/into-outfile"},{"sidebarTitle":"JOIN","title":"JOIN","href":"/pt-BR/reference/statements/select/join"},{"sidebarTitle":"LIMIT BY","title":"LIMIT BY","href":"/pt-BR/reference/statements/select/limit-by"},{"sidebarTitle":"LIMIT","title":"LIMIT","href":"/pt-BR/reference/statements/select/limit"},{"sidebarTitle":"OFFSET","title":"OFFSET FETCH","href":"/pt-BR/reference/statements/select/offset"},{"sidebarTitle":"ORDER BY","title":"ORDER BY","href":"/pt-BR/reference/statements/select/order-by"},{"sidebarTitle":"Operadores de pipe","title":"OPERADORES DE PIPE","href":"/pt-BR/reference/statements/select/pipe-operators"},{"sidebarTitle":"PREWHERE","title":"PREWHERE","href":"/pt-BR/reference/statements/select/prewhere"},{"sidebarTitle":"QUALIFY","title":"QUALIFY","href":"/pt-BR/reference/statements/select/qualify"},{"sidebarTitle":"REPLACE","title":"Modificador REPLACE","href":"/pt-BR/reference/statements/select/replace_modifier"},{"sidebarTitle":"SAMPLE","title":"SAMPLE","href":"/pt-BR/reference/statements/select/sample"},{"sidebarTitle":"UNION","title":"UNION","href":"/pt-BR/reference/statements/select/union"},{"sidebarTitle":"WHERE","title":"WHERE","href":"/pt-BR/reference/statements/select/where"},{"sidebarTitle":"WITH","title":"WITH","href":"/pt-BR/reference/statements/select/with"}]},{"sidebarTitle":"SET ROLE","title":"SET ROLE","href":"/pt-BR/reference/statements/set-role"},{"sidebarTitle":"SET","title":"SET","href":"/pt-BR/reference/statements/set"},{"sidebarTitle":"SHOW","title":"SHOW","href":"/pt-BR/reference/statements/show"},{"sidebarTitle":"SYSTEM","title":"SYSTEM","href":"/pt-BR/reference/statements/system"},{"sidebarTitle":"TRUNCATE","title":"TRUNCATE","href":"/pt-BR/reference/statements/truncate"},{"sidebarTitle":"UNDROP","title":"UNDROP","href":"/pt-BR/reference/statements/undrop"},{"sidebarTitle":"UPDATE","title":"UPDATE","href":"/pt-BR/reference/statements/update"},{"sidebarTitle":"USE","title":"USE","href":"/pt-BR/reference/statements/use"}]},{"group":"Operadores","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Operadores","href":"/pt-BR/reference/operators/index"}]}]},{"group":"Tipos de dados","expanded":false,"pages":[{"sidebarTitle":"Lista de tipos de dados","title":"Tipos de dados no ClickHouse","mode":"wide","href":"/pt-BR/reference/data-types/index"},{"group":"Tipos numéricos","expanded":false,"pages":[{"sidebarTitle":"Int | UInt","title":"Tipos Int | UInt","href":"/pt-BR/reference/data-types/int-uint"},{"sidebarTitle":"Float32 | Float64 | BFloat16","title":"Tipos Float32 | Float64 | BFloat16","href":"/pt-BR/reference/data-types/float"},{"sidebarTitle":"Decimal","title":"Decimal, Decimal(P), Decimal(P, S), Decimal32(S), Decimal64(S), Decimal128(S), Decimal256(S)","href":"/pt-BR/reference/data-types/decimal"},{"sidebarTitle":"Boolean","title":"Bool","href":"/pt-BR/reference/data-types/boolean"}]},{"group":"Tipos de string","expanded":false,"pages":[{"sidebarTitle":"String","title":"String","href":"/pt-BR/reference/data-types/string"},{"sidebarTitle":"FixedString(N)","title":"FixedString(N)","href":"/pt-BR/reference/data-types/fixedstring"}]},{"group":"Tipos de data e hora","expanded":false,"pages":[{"sidebarTitle":"Date","title":"Date","href":"/pt-BR/reference/data-types/date"},{"sidebarTitle":"Date32","title":"Date32","href":"/pt-BR/reference/data-types/date32"},{"sidebarTitle":"DateTime","title":"DateTime","href":"/pt-BR/reference/data-types/datetime"},{"sidebarTitle":"DateTime64","title":"DateTime64","href":"/pt-BR/reference/data-types/datetime64"},{"sidebarTitle":"Time","title":"Time","href":"/pt-BR/reference/data-types/time"},{"sidebarTitle":"Time64","title":"Time64","href":"/pt-BR/reference/data-types/time64"}]},{"group":"Tipos de rede","expanded":false,"pages":[{"sidebarTitle":"IPv4","title":"IPv4","href":"/pt-BR/reference/data-types/ipv4"},{"sidebarTitle":"IPv6","title":"IPv6","href":"/pt-BR/reference/data-types/ipv6"}]},{"group":"Tipos compostos","expanded":false,"pages":[{"sidebarTitle":"Array(T)","title":"Array(T)","href":"/pt-BR/reference/data-types/array"},{"sidebarTitle":"Tuple(T1, T2, ...)","title":"Tuple(T1, T2, ...)","href":"/pt-BR/reference/data-types/tuple"},{"sidebarTitle":"Map(K, V)","title":"Map(K, V)","href":"/pt-BR/reference/data-types/map"},{"sidebarTitle":"Nested(Name1 Type1, Name2 Type2, ...)","title":"Nested(name1 Type1, Name2 Type2, ...)","href":"/pt-BR/reference/data-types/nested-data-structures/index"}]},{"group":"Tipos semiestruturados","expanded":false,"pages":[{"sidebarTitle":"JSON","title":"Tipo de dados JSON","href":"/pt-BR/reference/data-types/newjson"},{"sidebarTitle":"Dynamic","title":"Dynamic","href":"/pt-BR/reference/data-types/dynamic"},{"sidebarTitle":"Variant(T1, T2, ...)","title":"Variant(T1, T2, ...)","href":"/pt-BR/reference/data-types/variant"}]},{"group":"Tipos anuláveis e opcionais","expanded":false,"pages":[{"sidebarTitle":"Nullable(T)","title":"Nullable(T)","href":"/pt-BR/reference/data-types/nullable"},{"sidebarTitle":"LowCardinality(T)","title":"LowCardinality(T)","href":"/pt-BR/reference/data-types/lowcardinality"}]},{"group":"Tipos especializados","expanded":false,"pages":[{"sidebarTitle":"UUID","title":"UUID","href":"/pt-BR/reference/data-types/uuid"},{"sidebarTitle":"Enum","title":"Enum","href":"/pt-BR/reference/data-types/enum"},{"sidebarTitle":"Geo","title":"Geométrico","href":"/pt-BR/reference/data-types/geo"},{"sidebarTitle":"QBit","title":"Tipo de dado QBit","href":"/pt-BR/reference/data-types/qbit"},{"sidebarTitle":"Domínios","title":"Domínios","href":"/pt-BR/reference/data-types/domains/index"}]},{"group":"Tipos de função de agregação","expanded":false,"pages":[{"sidebarTitle":"AggregateFunction","title":"Tipo AggregateFunction","href":"/pt-BR/reference/data-types/aggregatefunction"},{"sidebarTitle":"SimpleAggregateFunction","title":"Tipo de dado SimpleAggregateFunction","href":"/pt-BR/reference/data-types/simpleaggregatefunction"}]},{"group":"Tipos de dados especiais","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Tipos de Dados Especiais","href":"/pt-BR/reference/data-types/special-data-types/index"},{"sidebarTitle":"Expression","title":"Expression","href":"/pt-BR/reference/data-types/special-data-types/expression"},{"sidebarTitle":"Interval","title":"Interval","href":"/pt-BR/reference/data-types/special-data-types/interval"},{"sidebarTitle":"Nothing","title":"Nothing","href":"/pt-BR/reference/data-types/special-data-types/nothing"},{"sidebarTitle":"Set","title":"Set","href":"/pt-BR/reference/data-types/special-data-types/set"}]},{"group":"Codificação binária","pages":[{"sidebarTitle":"Especificação de codificação binária de tipos de dados.","title":"Especificação de codificação binária de tipos de dados","href":"/pt-BR/reference/data-types/data-types-binary-encoding"}]}]},{"group":"Motores","expanded":false,"pages":[{"title":"Motores","sidebarTitle":"Visão geral","mode":"wide","href":"/pt-BR/reference/engines/engines"},{"group":"Motores de tabela","expanded":false,"pages":[{"title":"Motores de Tabela","sidebarTitle":"Visão geral","href":"/pt-BR/reference/engines/table-engines/index"},{"group":"Integrações","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Motores de tabela para integrações","href":"/pt-BR/reference/engines/table-engines/integrations/index"},{"sidebarTitle":"ArrowFlight","title":"Motor de tabela ArrowFlight","href":"/pt-BR/reference/engines/table-engines/integrations/arrowflight"},{"sidebarTitle":"AzureQueue","title":"Motor de tabela AzureQueue","href":"/pt-BR/reference/engines/table-engines/integrations/azure-queue"},{"sidebarTitle":"Azure Blob Storage","title":"Motor de tabela AzureBlobStorage","href":"/pt-BR/reference/engines/table-engines/integrations/azureBlobStorage"},{"sidebarTitle":"BigQuery","title":"Motor de tabela BigQuery","href":"/pt-BR/reference/engines/table-engines/integrations/bigquery"},{"sidebarTitle":"DeltaLake","title":"motor de tabela DeltaLake","href":"/pt-BR/reference/engines/table-engines/integrations/deltalake"},{"sidebarTitle":"EmbeddedRocksDB","title":"Motor de tabela EmbeddedRocksDB","href":"/pt-BR/reference/engines/table-engines/integrations/embedded-rocksdb"},{"sidebarTitle":"ExternalDistributed","title":"Motor de tabela ExternalDistributed","href":"/pt-BR/reference/engines/table-engines/integrations/ExternalDistributed"},{"sidebarTitle":"HDFS","title":"Motor de tabela HDFS","href":"/pt-BR/reference/engines/table-engines/integrations/hdfs"},{"sidebarTitle":"Hive","title":"Motor de tabela Hive","href":"/pt-BR/reference/engines/table-engines/integrations/hive"},{"sidebarTitle":"Hudi","title":"Motor de tabela Hudi","href":"/pt-BR/reference/engines/table-engines/integrations/hudi"},{"sidebarTitle":"Iceberg","title":"Motor de tabela Iceberg","href":"/pt-BR/reference/engines/table-engines/integrations/iceberg"},{"sidebarTitle":"JDBC","title":"Motor de tabela JDBC","href":"/pt-BR/reference/engines/table-engines/integrations/jdbc"},{"sidebarTitle":"Kafka","title":"Motor de tabela Kafka","href":"/pt-BR/reference/engines/table-engines/integrations/kafka"},{"sidebarTitle":"MaterializedPostgreSQL","title":"motor de tabela MaterializedPostgreSQL","href":"/pt-BR/reference/engines/table-engines/integrations/materialized-postgresql"},{"sidebarTitle":"MongoDB","title":"Motor de tabela do MongoDB","href":"/pt-BR/reference/engines/table-engines/integrations/mongodb"},{"sidebarTitle":"MySQL","title":"Mecanismo de tabela MySQL","href":"/pt-BR/reference/engines/table-engines/integrations/mysql"},{"sidebarTitle":"NATS","title":"Engine de tabela NATS","href":"/pt-BR/reference/engines/table-engines/integrations/nats"},{"sidebarTitle":"ODBC","title":"Motor de tabela ODBC","href":"/pt-BR/reference/engines/table-engines/integrations/odbc"},{"sidebarTitle":"Paimon","title":"Motor de tabela Paimon","href":"/pt-BR/reference/engines/table-engines/integrations/paimon"},{"sidebarTitle":"PostgreSQL","title":"Motor de tabela PostgreSQL","href":"/pt-BR/reference/engines/table-engines/integrations/postgresql"},{"sidebarTitle":"RabbitMQ","title":"Motor de tabela RabbitMQ","href":"/pt-BR/reference/engines/table-engines/integrations/rabbitmq"},{"sidebarTitle":"Redis","title":"Motor de tabela Redis","href":"/pt-BR/reference/engines/table-engines/integrations/redis"},{"sidebarTitle":"S3","title":"Motor de tabela S3","href":"/pt-BR/reference/engines/table-engines/integrations/s3"},{"sidebarTitle":"S3Queue","title":"Motor de tabela S3Queue","href":"/pt-BR/reference/engines/table-engines/integrations/s3queue"},{"sidebarTitle":"SQLite","title":"Motor de tabela SQLite","href":"/pt-BR/reference/engines/table-engines/integrations/sqlite"},{"sidebarTitle":"TimeSeries","title":"motor de tabela TimeSeries","href":"/pt-BR/reference/engines/table-engines/integrations/time-series"},{"sidebarTitle":"YTsaurus","title":"Motor de tabela YTsaurus","href":"/pt-BR/reference/engines/table-engines/integrations/ytsaurus"}]},{"group":"Família Log","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Família de motores Log","href":"/pt-BR/reference/engines/table-engines/log-family/index"},{"title":"Motor de tabela Log","href":"/pt-BR/reference/engines/table-engines/log-family/log"},{"title":"Motor de tabela StripeLog","href":"/pt-BR/reference/engines/table-engines/log-family/stripelog"},{"title":"Motor de tabela TinyLog","href":"/pt-BR/reference/engines/table-engines/log-family/tinylog"}]},{"group":"Família MergeTree","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Família de motores MergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/index"},{"sidebarTitle":"MergeTree","title":"Motor de tabela MergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/mergetree"},{"sidebarTitle":"AggregatingMergeTree","title":"motor de tabela AggregatingMergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/aggregatingmergetree"},{"sidebarTitle":"Busca Vetorial Exata e Aproximada","title":"Busca Vetorial Exata e Aproximada","href":"/pt-BR/reference/engines/table-engines/mergetree-family/annindexes"},{"sidebarTitle":"CoalescingMergeTree","title":"Motor de tabela CoalescingMergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/coalescingmergetree"},{"sidebarTitle":"CollapsingMergeTree","title":"motor de tabela CollapsingMergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/collapsingmergetree"},{"sidebarTitle":"Chave de particionamento personalizada","title":"Chave de particionamento personalizada","href":"/pt-BR/reference/engines/table-engines/mergetree-family/custom-partitioning-key"},{"sidebarTitle":"GraphiteMergeTree","title":"Motor de tabela GraphiteMergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/graphitemergetree"},{"sidebarTitle":"ReplacingMergeTree","title":"Motor de tabela ReplacingMergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/replacingmergetree"},{"sidebarTitle":"Replicated*","title":"Motores de tabela Replicated*","href":"/pt-BR/reference/engines/table-engines/mergetree-family/replication"},{"sidebarTitle":"SummingMergeTree","title":"Motor de tabela SummingMergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/summingmergetree"},{"sidebarTitle":"Busca de texto completo com índices de texto","title":"Busca de texto completo com índices de texto","href":"/pt-BR/reference/engines/table-engines/mergetree-family/textindexes"},{"sidebarTitle":"VersionedCollapsingMergeTree","title":"motor de tabela VersionedCollapsingMergeTree","href":"/pt-BR/reference/engines/table-engines/mergetree-family/versionedcollapsingmergetree"}]},{"group":"Especiais","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Motores de tabela especiais","href":"/pt-BR/reference/engines/table-engines/special/index"},{"sidebarTitle":"Alias","title":"Motor de tabela Alias","href":"/pt-BR/reference/engines/table-engines/special/alias"},{"sidebarTitle":"Buffer","title":"Motor de tabela Buffer","href":"/pt-BR/reference/engines/table-engines/special/buffer"},{"sidebarTitle":"Dicionário","title":"Motor de tabela Dicionário","href":"/pt-BR/reference/engines/table-engines/special/dictionary"},{"sidebarTitle":"Distributed","title":"Motor de tabela Distributed","href":"/pt-BR/reference/engines/table-engines/special/distributed"},{"sidebarTitle":"Executable/ExecutablePool","title":"Motores de tabela Executable e ExecutablePool","href":"/pt-BR/reference/engines/table-engines/special/executable"},{"sidebarTitle":"Dados externos para processamento de consultas","title":"Dados externos para processamento de consultas","href":"/pt-BR/reference/engines/table-engines/special/external-data"},{"sidebarTitle":"File","title":"Motor de tabela File","href":"/pt-BR/reference/engines/table-engines/special/file"},{"sidebarTitle":"FileLog","title":"Motor de tabela FileLog","href":"/pt-BR/reference/engines/table-engines/special/filelog"},{"sidebarTitle":"GenerateRandom","title":"Motor de tabela GenerateRandom","href":"/pt-BR/reference/engines/table-engines/special/generate"},{"sidebarTitle":"Join","title":"Motor de tabela Join","href":"/pt-BR/reference/engines/table-engines/special/join"},{"sidebarTitle":"KeeperMap","title":"Motor de tabela KeeperMap","href":"/pt-BR/reference/engines/table-engines/special/keepermap"},{"sidebarTitle":"Memory","title":"Motor de tabela Memory","href":"/pt-BR/reference/engines/table-engines/special/memory"},{"sidebarTitle":"Merge","title":"Motor de tabela Merge","href":"/pt-BR/reference/engines/table-engines/special/merge"},{"sidebarTitle":"Null","title":"Motor de tabela Null","href":"/pt-BR/reference/engines/table-engines/special/null"},{"sidebarTitle":"QueryRunner","title":"Motor de tabela QueryRunner","href":"/pt-BR/reference/engines/table-engines/special/query-runner"},{"sidebarTitle":"Set","title":"Motor de tabela Set","href":"/pt-BR/reference/engines/table-engines/special/set"},{"sidebarTitle":"URL","title":"motor de tabela URL","href":"/pt-BR/reference/engines/table-engines/special/url"},{"sidebarTitle":"View","title":"Mecanismo de tabela View","href":"/pt-BR/reference/engines/table-engines/special/view"}]}]},{"group":"Motores de banco de dados","expanded":false,"pages":[{"title":"Motores de Banco de Dados","sidebarTitle":"Visão geral","href":"/pt-BR/reference/engines/database-engines/index"},{"sidebarTitle":"Atomic","title":"Atomic","href":"/pt-BR/reference/engines/database-engines/atomic"},{"sidebarTitle":"Backup","title":"Backup","href":"/pt-BR/reference/engines/database-engines/backup"},{"sidebarTitle":"Cluster","title":"Cluster","href":"/pt-BR/reference/engines/database-engines/cluster"},{"sidebarTitle":"DataLakeCatalog","title":"DataLakeCatalog","href":"/pt-BR/reference/engines/database-engines/datalake"},{"sidebarTitle":"Dictionary","title":"Dicionário","href":"/pt-BR/reference/engines/database-engines/dictionary"},{"sidebarTitle":"Filesystem","title":"Filesystem","href":"/pt-BR/reference/engines/database-engines/filesystem"},{"sidebarTitle":"HDFS","title":"HDFS","href":"/pt-BR/reference/engines/database-engines/hdfs"},{"sidebarTitle":"MaterializedPostgreSQL","title":"MaterializedPostgreSQL","href":"/pt-BR/reference/engines/database-engines/materialized-postgresql"},{"sidebarTitle":"Memory","title":"Memory","href":"/pt-BR/reference/engines/database-engines/memory"},{"sidebarTitle":"MySQL","title":"MySQL","href":"/pt-BR/reference/engines/database-engines/mysql"},{"sidebarTitle":"Ordinary","title":"Ordinary","href":"/pt-BR/reference/engines/database-engines/ordinary"},{"sidebarTitle":"Overlay","title":"Overlay","href":"/pt-BR/reference/engines/database-engines/overlay"},{"sidebarTitle":"PostgreSQL","title":"PostgreSQL","href":"/pt-BR/reference/engines/database-engines/postgresql"},{"sidebarTitle":"Remote","title":"Remote","href":"/pt-BR/reference/engines/database-engines/remote"},{"sidebarTitle":"Replicated","title":"Replicated","href":"/pt-BR/reference/engines/database-engines/replicated"},{"sidebarTitle":"S3","title":"S3","href":"/pt-BR/reference/engines/database-engines/s3"},{"sidebarTitle":"Shared","title":"Shared","href":"/pt-BR/reference/engines/database-engines/shared"},{"sidebarTitle":"SQLite","title":"SQLite","href":"/pt-BR/reference/engines/database-engines/sqlite"},{"sidebarTitle":"URL","title":"URL","href":"/pt-BR/reference/engines/database-engines/url"}]}]},{"group":"Funções","expanded":false,"pages":[{"title":"Visão geral das funções","mode":"wide","href":"/pt-BR/reference/functions/index"},{"group":"Funções regulares","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Funções Regulares","href":"/pt-BR/reference/functions/regular-functions/overview"},{"sidebarTitle":"AI","title":"Funções de IA","href":"/pt-BR/reference/functions/regular-functions/ai-functions"},{"sidebarTitle":"Aritmética","title":"Funções Aritméticas","href":"/pt-BR/reference/functions/regular-functions/arithmetic-functions"},{"sidebarTitle":"Arrays","title":"Funções de array","href":"/pt-BR/reference/functions/regular-functions/array-functions"},{"sidebarTitle":"arrayJoin","title":"função arrayJoin","href":"/pt-BR/reference/functions/regular-functions/array-join"},{"sidebarTitle":"Bit","title":"Funções de Bit","href":"/pt-BR/reference/functions/regular-functions/bit-functions"},{"sidebarTitle":"Bitmap","title":"Funções de bitmap","href":"/pt-BR/reference/functions/regular-functions/bitmap-functions"},{"sidebarTitle":"Comparação","title":"Funções de Comparação","href":"/pt-BR/reference/functions/regular-functions/comparison-functions"},{"sidebarTitle":"Condicional","title":"Funções Condicionais","href":"/pt-BR/reference/functions/regular-functions/conditional-functions"},{"sidebarTitle":"Datas e horas","title":"Funções para trabalhar com datas e horas","href":"/pt-BR/reference/functions/regular-functions/date-time-functions"},{"sidebarTitle":"Distância","title":"Funções de distância","href":"/pt-BR/reference/functions/regular-functions/distance-functions"},{"sidebarTitle":"Dicionário incorporado","title":"Funções para Trabalhar com Dicionários Incorporados","href":"/pt-BR/reference/functions/regular-functions/embedded-dict-functions"},{"sidebarTitle":"Codificação","title":"Funções de codificação","href":"/pt-BR/reference/functions/regular-functions/encoding-functions"},{"sidebarTitle":"Criptografia","title":"Funções de criptografia","href":"/pt-BR/reference/functions/regular-functions/encryption-functions"},{"sidebarTitle":"Dicionários","title":"Funções para Trabalhar com Dicionários","href":"/pt-BR/reference/functions/regular-functions/ext-dict-functions"},{"sidebarTitle":"Arquivos","title":"Arquivos","href":"/pt-BR/reference/functions/regular-functions/files"},{"sidebarTitle":"Financeiras","title":"Funções financeiras","href":"/pt-BR/reference/functions/regular-functions/financial-functions"},{"sidebarTitle":"Nullable","title":"Funções para trabalhar com valores Nullable","href":"/pt-BR/reference/functions/regular-functions/functions-for-nulls"},{"group":"Geoespacial","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Funções Geo","href":"/pt-BR/reference/functions/regular-functions/geo/index"},{"sidebarTitle":"Coordenadas geográficas","title":"Funções para trabalhar com coordenadas geográficas","href":"/pt-BR/reference/functions/regular-functions/geo/coordinates"},{"sidebarTitle":"Inversão de coordenadas","title":"Inversão de coordenadas","href":"/pt-BR/reference/functions/regular-functions/geo/flipCoordinates"},{"sidebarTitle":"Geometry","title":"Funções para trabalhar com Geometry","href":"/pt-BR/reference/functions/regular-functions/geo/geometry"},{"sidebarTitle":"Geohash","title":"Funções para trabalhar com Geohash","href":"/pt-BR/reference/functions/regular-functions/geo/geohash"},{"sidebarTitle":"Índices H3","title":"Funções para trabalhar com índices H3","href":"/pt-BR/reference/functions/regular-functions/geo/h3"},{"sidebarTitle":"Mapbox Vector Tiles","title":"Funções para codificar Mapbox Vector Tiles","href":"/pt-BR/reference/functions/regular-functions/geo/mvt"},{"sidebarTitle":"Polygons","title":"Funções para trabalhar com Polygons","href":"/pt-BR/reference/functions/regular-functions/geo/polygon"},{"sidebarTitle":"Geometria S2","title":"Funções para trabalhar com o S2 Index","href":"/pt-BR/reference/functions/regular-functions/geo/s2"},{"title":null,"href":"/pt-BR/reference/functions/regular-functions/geo/svg"}]},{"description":"Documentação das funções de hash","sidebarTitle":"Hash","title":"Funções de hash","href":"/pt-BR/reference/functions/regular-functions/hash-functions"},{"sidebarTitle":"Operador IN","title":"Funções para implementação do operador IN","href":"/pt-BR/reference/functions/regular-functions/in-functions"},{"description":"Documentação das funções de introspecção","sidebarTitle":"Introspecção","title":"Funções de introspecção","href":"/pt-BR/reference/functions/regular-functions/introspection"},{"sidebarTitle":"Endereços IP","title":"Funções para trabalhar com endereços IPv4 e IPv6","href":"/pt-BR/reference/functions/regular-functions/ip-address-functions"},{"sidebarTitle":"JSON","title":"Funções JSON","href":"/pt-BR/reference/functions/regular-functions/json-functions"},{"sidebarTitle":"Lógicas","title":"Funções lógicas","href":"/pt-BR/reference/functions/regular-functions/logical-functions"},{"sidebarTitle":"Machine Learning","title":"Funções de machine learning","href":"/pt-BR/reference/functions/regular-functions/machine-learning-functions"},{"sidebarTitle":"Matemática","title":"Funções matemáticas","href":"/pt-BR/reference/functions/regular-functions/math-functions"},{"sidebarTitle":"NLP","title":"Funções de processamento de linguagem natural (NLP)","href":"/pt-BR/reference/functions/regular-functions/nlp-functions"},{"sidebarTitle":"NumericIndexedVector","title":"Funções de NumericIndexedVector","href":"/pt-BR/reference/functions/regular-functions/numeric-indexed-vector-functions"},{"sidebarTitle":"Outras","title":"Outras funções","href":"/pt-BR/reference/functions/regular-functions/other-functions"},{"sidebarTitle":"Número aleatório","title":"Funções para gerar números aleatórios","href":"/pt-BR/reference/functions/regular-functions/random-functions"},{"sidebarTitle":"Arredondamento","title":"Funções de arredondamento","href":"/pt-BR/reference/functions/regular-functions/rounding-functions"},{"sidebarTitle":"Divisão de strings","title":"Funções de divisão de strings","href":"/pt-BR/reference/functions/regular-functions/splitting-merging-functions"},{"sidebarTitle":"String","title":"Funções para trabalhar com String","href":"/pt-BR/reference/functions/regular-functions/string-functions"},{"sidebarTitle":"Substituição de strings","title":"Funções de substituição de strings","href":"/pt-BR/reference/functions/regular-functions/string-replace-functions"},{"sidebarTitle":"Busca em strings","title":"Funções de busca em strings","href":"/pt-BR/reference/functions/regular-functions/string-search-functions"},{"sidebarTitle":"Séries temporais","title":"Funções para trabalhar com séries temporais","href":"/pt-BR/reference/functions/regular-functions/time-series-functions"},{"sidebarTitle":"Janela de tempo","title":"Funções de janela de tempo","href":"/pt-BR/reference/functions/regular-functions/time-window-functions"},{"sidebarTitle":"Tuples","title":"Funções Tuple","href":"/pt-BR/reference/functions/regular-functions/tuple-functions"},{"sidebarTitle":"Maps","title":"Funções de map","href":"/pt-BR/reference/functions/regular-functions/tuple-map-functions"},{"sidebarTitle":"Conversão de tipos","title":"Funções de conversão de tipos","href":"/pt-BR/reference/functions/regular-functions/type-conversion-functions"},{"sidebarTitle":"ULIDs","title":"Funções para trabalhar com ULIDs","href":"/pt-BR/reference/functions/regular-functions/ulid-functions"},{"sidebarTitle":"uniqTheta","title":"Funções uniqTheta","href":"/pt-BR/reference/functions/regular-functions/uniqtheta-functions"},{"sidebarTitle":"URLs","title":"Funções para trabalhar com URLs","href":"/pt-BR/reference/functions/regular-functions/url-functions"},{"sidebarTitle":"UUIDs","title":"Funções para trabalhar com UUIDs","href":"/pt-BR/reference/functions/regular-functions/uuid-functions"}]},{"group":"Funções de agregação","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Funções de agregação","href":"/pt-BR/reference/functions/aggregate-functions/index"},{"sidebarTitle":"Combinadores","title":"Combinadores de funções de agregação","href":"/pt-BR/reference/functions/aggregate-functions/combinators"},{"title":"GROUPING","href":"/pt-BR/reference/functions/aggregate-functions/grouping_function"},{"sidebarTitle":"Paramétricas","title":"Funções de agregação paramétricas","href":"/pt-BR/reference/functions/aggregate-functions/parametric-functions"},{"group":"Referência","expanded":false,"pages":[{"title":"Funções de agregação","href":"/pt-BR/reference/functions/aggregate-functions/reference-index"},{"title":"aggThrow","href":"/pt-BR/reference/functions/aggregate-functions/aggThrow"},{"title":"analysisOfVariance","href":"/pt-BR/reference/functions/aggregate-functions/analysis_of_variance"},{"title":"any","href":"/pt-BR/reference/functions/aggregate-functions/any"},{"title":"anyHeavy","href":"/pt-BR/reference/functions/aggregate-functions/anyHeavy"},{"title":"anyLast","href":"/pt-BR/reference/functions/aggregate-functions/anyLast"},{"title":"approx_top_k","href":"/pt-BR/reference/functions/aggregate-functions/approxtopk"},{"title":"approx_top_sum","href":"/pt-BR/reference/functions/aggregate-functions/approxtopsum"},{"title":"argMax","href":"/pt-BR/reference/functions/aggregate-functions/argMax"},{"title":"argAndMax","href":"/pt-BR/reference/functions/aggregate-functions/argAndMax"},{"title":"argMin","href":"/pt-BR/reference/functions/aggregate-functions/argMin"},{"title":"argAndMin","href":"/pt-BR/reference/functions/aggregate-functions/argAndMin"},{"title":"avg","href":"/pt-BR/reference/functions/aggregate-functions/avg"},{"title":"avgWeighted","href":"/pt-BR/reference/functions/aggregate-functions/avgWeighted"},{"title":"boundingRatio","href":"/pt-BR/reference/functions/aggregate-functions/boundrat"},{"title":"categoricalInformationValue","href":"/pt-BR/reference/functions/aggregate-functions/categoricalInformationValue"},{"title":"contingency","href":"/pt-BR/reference/functions/aggregate-functions/contingency"},{"title":"corr","href":"/pt-BR/reference/functions/aggregate-functions/corr"},{"title":"corrMatrix","href":"/pt-BR/reference/functions/aggregate-functions/corrMatrix"},{"title":"corrStable","href":"/pt-BR/reference/functions/aggregate-functions/corrStable"},{"title":"count","href":"/pt-BR/reference/functions/aggregate-functions/count"},{"title":"covarPop","href":"/pt-BR/reference/functions/aggregate-functions/covarPop"},{"title":"covarPopMatrix","href":"/pt-BR/reference/functions/aggregate-functions/covarPopMatrix"},{"title":"covarPopStable","href":"/pt-BR/reference/functions/aggregate-functions/covarPopStable"},{"title":"covarSamp","href":"/pt-BR/reference/functions/aggregate-functions/covarSamp"},{"title":"covarSampMatrix","href":"/pt-BR/reference/functions/aggregate-functions/covarSampMatrix"},{"title":"covarSampStable","href":"/pt-BR/reference/functions/aggregate-functions/covarSampStable"},{"title":"cramersV","href":"/pt-BR/reference/functions/aggregate-functions/cramersV"},{"title":"cramersVBiasCorrected","href":"/pt-BR/reference/functions/aggregate-functions/cramersVBiasCorrected"},{"title":"deltaSum","href":"/pt-BR/reference/functions/aggregate-functions/deltaSum"},{"title":"deltaSumTimestamp","href":"/pt-BR/reference/functions/aggregate-functions/deltaSumTimestamp"},{"title":"distinctDynamicTypes","href":"/pt-BR/reference/functions/aggregate-functions/distinctDynamicTypes"},{"title":"distinctJSONPaths","href":"/pt-BR/reference/functions/aggregate-functions/distinctJSONPaths"},{"title":"distinctJSONPathsAndTypes","href":"/pt-BR/reference/functions/aggregate-functions/distinctJSONPathsAndTypes"},{"title":"entropy","href":"/pt-BR/reference/functions/aggregate-functions/entropy"},{"title":"estimateCompressionRatio","href":"/pt-BR/reference/functions/aggregate-functions/estimateCompressionRatio"},{"title":"exponentialMovingAverage","href":"/pt-BR/reference/functions/aggregate-functions/exponentialMovingAverage"},{"title":"exponentialTimeDecayedAvg","href":"/pt-BR/reference/functions/aggregate-functions/exponentialTimeDecayedAvg"},{"title":"exponentialTimeDecayedCount","href":"/pt-BR/reference/functions/aggregate-functions/exponentialTimeDecayedCount"},{"title":"exponentialTimeDecayedMax","href":"/pt-BR/reference/functions/aggregate-functions/exponentialTimeDecayedMax"},{"title":"exponentialTimeDecayedSum","href":"/pt-BR/reference/functions/aggregate-functions/exponentialTimeDecayedSum"},{"title":"first_value","href":"/pt-BR/reference/functions/aggregate-functions/first_value"},{"title":"flameGraph","href":"/pt-BR/reference/functions/aggregate-functions/flame_graph"},{"sidebarTitle":"gini","title":"gini","href":"/pt-BR/reference/functions/aggregate-functions/gini"},{"title":"groupArray","href":"/pt-BR/reference/functions/aggregate-functions/groupArray"},{"title":"groupArrayArray","href":"/pt-BR/reference/functions/aggregate-functions/groupArrayArray"},{"title":"groupArrayInsertAt","href":"/pt-BR/reference/functions/aggregate-functions/groupArrayInsertAt"},{"title":"groupArrayIntersect","href":"/pt-BR/reference/functions/aggregate-functions/groupArrayIntersect"},{"title":"groupArrayLast","href":"/pt-BR/reference/functions/aggregate-functions/groupArrayLast"},{"title":"groupArrayMovingAvg","href":"/pt-BR/reference/functions/aggregate-functions/groupArrayMovingAvg"},{"title":"groupArrayMovingSum","href":"/pt-BR/reference/functions/aggregate-functions/groupArrayMovingSum"},{"title":"groupArraySample","href":"/pt-BR/reference/functions/aggregate-functions/groupArraySample"},{"title":"groupArraySorted","href":"/pt-BR/reference/functions/aggregate-functions/groupArraySorted"},{"title":"groupBitAnd","href":"/pt-BR/reference/functions/aggregate-functions/groupBitAnd"},{"title":"groupBitmap","href":"/pt-BR/reference/functions/aggregate-functions/groupBitmap"},{"title":"groupBitmapAnd","href":"/pt-BR/reference/functions/aggregate-functions/groupBitmapAnd"},{"title":"groupBitmapOr","href":"/pt-BR/reference/functions/aggregate-functions/groupBitmapOr"},{"title":"groupBitmapXor","href":"/pt-BR/reference/functions/aggregate-functions/groupBitmapXor"},{"title":"groupBitOr","href":"/pt-BR/reference/functions/aggregate-functions/groupBitOr"},{"title":"groupBitXor","href":"/pt-BR/reference/functions/aggregate-functions/groupBitXor"},{"sidebarTitle":"groupConcat","title":"groupConcat","href":"/pt-BR/reference/functions/aggregate-functions/groupConcat"},{"sidebarTitle":"groupFormat","title":"groupFormat","href":"/pt-BR/reference/functions/aggregate-functions/groupFormat"},{"title":"groupUniqArray","href":"/pt-BR/reference/functions/aggregate-functions/groupUniqArray"},{"sidebarTitle":"intervalLengthSum","title":"intervalLengthSum","href":"/pt-BR/reference/functions/aggregate-functions/intervalLengthSum"},{"sidebarTitle":"kolmogorovSmirnovTest","title":"kolmogorovSmirnovTest","href":"/pt-BR/reference/functions/aggregate-functions/kolmogorovSmirnovTest"},{"title":"kurtPop","href":"/pt-BR/reference/functions/aggregate-functions/kurtPop"},{"title":"kurtSamp","href":"/pt-BR/reference/functions/aggregate-functions/kurtSamp"},{"sidebarTitle":"largestTriangleThreeBuckets","title":"largestTriangleThreeBuckets","href":"/pt-BR/reference/functions/aggregate-functions/largestTriangleThreeBuckets"},{"title":"last_value","href":"/pt-BR/reference/functions/aggregate-functions/last_value"},{"sidebarTitle":"mannWhitneyUTest","title":"mannWhitneyUTest","href":"/pt-BR/reference/functions/aggregate-functions/mannWhitneyUTest"},{"title":"max","href":"/pt-BR/reference/functions/aggregate-functions/max"},{"title":"maxIntersections","href":"/pt-BR/reference/functions/aggregate-functions/maxIntersections"},{"title":"maxIntersectionsPosition","href":"/pt-BR/reference/functions/aggregate-functions/maxIntersectionsPosition"},{"title":"maxMap","href":"/pt-BR/reference/functions/aggregate-functions/maxMap"},{"sidebarTitle":"meanZTest","title":"meanZTest","href":"/pt-BR/reference/functions/aggregate-functions/meanZTest"},{"title":"mergedJSONPatch","href":"/pt-BR/reference/functions/aggregate-functions/mergedJSONPatch"},{"title":"median","href":"/pt-BR/reference/functions/aggregate-functions/median"},{"title":"min","href":"/pt-BR/reference/functions/aggregate-functions/min"},{"title":"minMap","href":"/pt-BR/reference/functions/aggregate-functions/minMap"},{"title":"quantile","href":"/pt-BR/reference/functions/aggregate-functions/quantile"},{"title":"quantileGK","href":"/pt-BR/reference/functions/aggregate-functions/quantileGK"},{"title":"quantileBFloat16","href":"/pt-BR/reference/functions/aggregate-functions/quantileBFloat16"},{"title":"quantileDD","href":"/pt-BR/reference/functions/aggregate-functions/quantileddsketch"},{"title":"quantileDeterministic","href":"/pt-BR/reference/functions/aggregate-functions/quantileDeterministic"},{"title":"Funções quantileExact","href":"/pt-BR/reference/functions/aggregate-functions/quantileExact"},{"title":"quantileExactExclusive","href":"/pt-BR/reference/functions/aggregate-functions/quantileExactExclusive"},{"title":"quantileExactHigh","href":"/pt-BR/reference/functions/aggregate-functions/quantileExactHigh"},{"title":"quantileExactInclusive","href":"/pt-BR/reference/functions/aggregate-functions/quantileExactInclusive"},{"title":"quantileExactLow","href":"/pt-BR/reference/functions/aggregate-functions/quantileExactLow"},{"title":"quantileExactWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantileExactWeighted"},{"title":"quantileExactWeightedInterpolated","href":"/pt-BR/reference/functions/aggregate-functions/quantileExactWeightedInterpolated"},{"title":"quantileInterpolatedWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantileInterpolatedWeighted"},{"title":"quantilePrometheusHistogram","href":"/pt-BR/reference/functions/aggregate-functions/quantilePrometheusHistogram"},{"title":"Funções quantiles","href":"/pt-BR/reference/functions/aggregate-functions/quantiles"},{"title":"quantilesBFloat16","href":"/pt-BR/reference/functions/aggregate-functions/quantilesBFloat16"},{"title":"quantilesBFloat16Weighted","href":"/pt-BR/reference/functions/aggregate-functions/quantilesBFloat16Weighted"},{"title":"quantilesDD","href":"/pt-BR/reference/functions/aggregate-functions/quantilesDD"},{"title":"quantilesDeterministic","href":"/pt-BR/reference/functions/aggregate-functions/quantilesDeterministic"},{"title":"quantilesExact","href":"/pt-BR/reference/functions/aggregate-functions/quantilesExact"},{"title":"quantilesExactExclusive","href":"/pt-BR/reference/functions/aggregate-functions/quantilesExactExclusive"},{"title":"quantilesExactHigh","href":"/pt-BR/reference/functions/aggregate-functions/quantilesExactHigh"},{"title":"quantilesExactInclusive","href":"/pt-BR/reference/functions/aggregate-functions/quantilesExactInclusive"},{"title":"quantilesExactLow","href":"/pt-BR/reference/functions/aggregate-functions/quantilesExactLow"},{"title":"quantilesExactWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantilesExactWeighted"},{"title":"quantilesExactWeightedInterpolated","href":"/pt-BR/reference/functions/aggregate-functions/quantilesExactWeightedInterpolated"},{"title":"quantilesGK","href":"/pt-BR/reference/functions/aggregate-functions/quantilesGK"},{"title":"quantilesInterpolatedWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantilesInterpolatedWeighted"},{"title":"quantilesPrometheusHistogram","href":"/pt-BR/reference/functions/aggregate-functions/quantilesPrometheusHistogram"},{"title":"quantilesTDigest","href":"/pt-BR/reference/functions/aggregate-functions/quantilesTDigest"},{"title":"quantilesTDigestWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantilesTDigestWeighted"},{"title":"quantilesTiming","href":"/pt-BR/reference/functions/aggregate-functions/quantilesTiming"},{"title":"quantileTDigest","href":"/pt-BR/reference/functions/aggregate-functions/quantileTDigest"},{"title":"quantileTDigestWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantileTDigestWeighted"},{"title":"quantileTiming","href":"/pt-BR/reference/functions/aggregate-functions/quantileTiming"},{"title":"quantileTimingWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantileTimingWeighted"},{"title":"quantilesTimingWeighted","href":"/pt-BR/reference/functions/aggregate-functions/quantilesTimingWeighted"},{"title":"rankCorr","href":"/pt-BR/reference/functions/aggregate-functions/rankCorr"},{"title":"regr_avgx","href":"/pt-BR/reference/functions/aggregate-functions/regr_avgx"},{"title":"regr_avgy","href":"/pt-BR/reference/functions/aggregate-functions/regr_avgy"},{"title":"regr_count","href":"/pt-BR/reference/functions/aggregate-functions/regr_count"},{"title":"regr_intercept","href":"/pt-BR/reference/functions/aggregate-functions/regr_intercept"},{"title":"regr_r2","href":"/pt-BR/reference/functions/aggregate-functions/regr_r2"},{"title":"regr_slope","href":"/pt-BR/reference/functions/aggregate-functions/regr_slope"},{"title":"regr_sxx","href":"/pt-BR/reference/functions/aggregate-functions/regr_sxx"},{"title":"regr_sxy","href":"/pt-BR/reference/functions/aggregate-functions/regr_sxy"},{"title":"regr_syy","href":"/pt-BR/reference/functions/aggregate-functions/regr_syy"},{"title":"simpleLinearRegression","href":"/pt-BR/reference/functions/aggregate-functions/simpleLinearRegression"},{"title":"singleValueOrNull","href":"/pt-BR/reference/functions/aggregate-functions/singleValueOrNull"},{"title":"skewPop","href":"/pt-BR/reference/functions/aggregate-functions/skewPop"},{"title":"skewSamp","href":"/pt-BR/reference/functions/aggregate-functions/skewSamp"},{"sidebarTitle":"sparkbar","title":"sparkbar","href":"/pt-BR/reference/functions/aggregate-functions/sparkbar"},{"title":"stddevPop","href":"/pt-BR/reference/functions/aggregate-functions/stddevPop"},{"title":"stddevPopStable","href":"/pt-BR/reference/functions/aggregate-functions/stddevPopStable"},{"title":"stddevSamp","href":"/pt-BR/reference/functions/aggregate-functions/stddevSamp"},{"title":"stddevSampStable","href":"/pt-BR/reference/functions/aggregate-functions/stddevSampStable"},{"title":"stochasticLinearRegression","href":"/pt-BR/reference/functions/aggregate-functions/stochasticLinearRegression"},{"title":"stochasticLogisticRegression","href":"/pt-BR/reference/functions/aggregate-functions/stochasticLogisticRegression"},{"sidebarTitle":"studentTTest","title":"studentTTest","href":"/pt-BR/reference/functions/aggregate-functions/studentTTest"},{"sidebarTitle":"studentTTestOneSample","title":"studentTTestOneSample","href":"/pt-BR/reference/functions/aggregate-functions/studentTTestOneSample"},{"title":"sum","href":"/pt-BR/reference/functions/aggregate-functions/sum"},{"title":"sumCount","href":"/pt-BR/reference/functions/aggregate-functions/sumCount"},{"title":"sumKahan","href":"/pt-BR/reference/functions/aggregate-functions/sumKahan"},{"title":"sumMap","href":"/pt-BR/reference/functions/aggregate-functions/sumMap"},{"title":"sumMapWithOverflow","href":"/pt-BR/reference/functions/aggregate-functions/sumMapWithOverflow"},{"title":"sumWithOverflow","href":"/pt-BR/reference/functions/aggregate-functions/sumWithOverflow"},{"title":"theilsU","href":"/pt-BR/reference/functions/aggregate-functions/theilsU"},{"title":"timeSeriesAvgToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesAvgToGrid"},{"title":"timeSeriesBottomKMasks","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesBottomKMasks"},{"title":"timeSeriesChangesToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesChangesToGrid"},{"title":"timeSeriesCountToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesCountToGrid"},{"title":"timeSeriesDeltaToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesDeltaToGrid"},{"title":"timeSeriesDerivToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesDerivToGrid"},{"title":"timeSeriesFirstToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesFirstToGrid"},{"title":"timeSeriesGroupArray","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesGroupArray"},{"title":"timeSeriesIncreaseToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesIncreaseToGrid"},{"title":"timeSeriesInstantDeltaToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesInstantDeltaToGrid"},{"title":"timeSeriesInstantRateToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesInstantRateToGrid"},{"title":"timeSeriesLastToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesLastToGrid"},{"title":"timeSeriesLastTwoSamples","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesLastTwoSamples"},{"title":"timeSeriesLimitKMasks","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesLimitKMasks"},{"title":"timeSeriesLinearRegressionToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesLinearRegressionToGrid"},{"title":"timeSeriesMadToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesMadToGrid"},{"title":"timeSeriesMaxToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesMaxToGrid"},{"title":"timeSeriesMinToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesMinToGrid"},{"title":"timeSeriesPredictLinearToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesPredictLinearToGrid"},{"title":"timeSeriesPresentToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesPresentToGrid"},{"title":"timeSeriesQuantileToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesQuantileToGrid"},{"title":"timeSeriesRateToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesRateToGrid"},{"title":"timeSeriesResampleToGridWithStaleness","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesResampleToGridWithStaleness"},{"title":"timeSeriesResetsToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesResetsToGrid"},{"title":"timeSeriesStddevToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesStddevToGrid"},{"title":"timeSeriesStdvarToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesStdvarToGrid"},{"title":"timeSeriesSumToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesSumToGrid"},{"title":"timeSeriesTimestampOfFirstToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesTimestampOfFirstToGrid"},{"title":"timeSeriesTimestampOfLastToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesTimestampOfLastToGrid"},{"title":"timeSeriesTimestampOfMaxToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesTimestampOfMaxToGrid"},{"title":"timeSeriesTimestampOfMinToGrid","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesTimestampOfMinToGrid"},{"title":"timeSeriesTopKMasks","href":"/pt-BR/reference/functions/aggregate-functions/timeSeriesTopKMasks"},{"title":"topK","href":"/pt-BR/reference/functions/aggregate-functions/topK"},{"title":"topKWeighted","href":"/pt-BR/reference/functions/aggregate-functions/topKWeighted"},{"title":"uniq","href":"/pt-BR/reference/functions/aggregate-functions/uniq"},{"title":"uniqCombined","href":"/pt-BR/reference/functions/aggregate-functions/uniqCombined"},{"title":"uniqCombined64","href":"/pt-BR/reference/functions/aggregate-functions/uniqCombined64"},{"title":"uniqExact","href":"/pt-BR/reference/functions/aggregate-functions/uniqExact"},{"title":"uniqHLL12","href":"/pt-BR/reference/functions/aggregate-functions/uniqHLL12"},{"title":"uniqTheta","href":"/pt-BR/reference/functions/aggregate-functions/uniqthetasketch"},{"title":"varPop","href":"/pt-BR/reference/functions/aggregate-functions/varPop"},{"title":"varPopStable","href":"/pt-BR/reference/functions/aggregate-functions/varPopStable"},{"title":"varSamp","href":"/pt-BR/reference/functions/aggregate-functions/varSamp"},{"title":"varSampStable","href":"/pt-BR/reference/functions/aggregate-functions/varSampStable"},{"sidebarTitle":"welchTTest","title":"welchTTest","href":"/pt-BR/reference/functions/aggregate-functions/welchTTest"}]}]},{"group":"Funções de tabela","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Funções de tabela","href":"/pt-BR/reference/functions/table-functions/index"},{"sidebarTitle":"arrowFlight","title":"arrowFlight","href":"/pt-BR/reference/functions/table-functions/arrowflight"},{"sidebarTitle":"azureBlobStorage","title":"azureBlobStorage","href":"/pt-BR/reference/functions/table-functions/azureBlobStorage"},{"sidebarTitle":"azureBlobStorageCluster","title":"azureBlobStorageCluster","href":"/pt-BR/reference/functions/table-functions/azureBlobStorageCluster"},{"sidebarTitle":"bigquery","title":"bigquery","href":"/pt-BR/reference/functions/table-functions/bigquery"},{"sidebarTitle":"cluster","title":"clusterAllReplicas","href":"/pt-BR/reference/functions/table-functions/cluster"},{"sidebarTitle":"deltaLake","title":"deltaLake","href":"/pt-BR/reference/functions/table-functions/deltalake"},{"sidebarTitle":"deltaLakeCluster","title":"deltaLakeCluster","href":"/pt-BR/reference/functions/table-functions/deltalakeCluster"},{"sidebarTitle":"dictionary","title":"dictionary","href":"/pt-BR/reference/functions/table-functions/dictionary"},{"sidebarTitle":"executable","title":"executable","href":"/pt-BR/reference/functions/table-functions/executable"},{"sidebarTitle":"eval","title":"eval","href":"/pt-BR/reference/functions/table-functions/eval"},{"sidebarTitle":"file","title":"file","href":"/pt-BR/reference/functions/table-functions/file"},{"sidebarTitle":"fileCluster","title":"fileCluster","href":"/pt-BR/reference/functions/table-functions/fileCluster"},{"sidebarTitle":"filesystem","title":"filesystem","href":"/pt-BR/reference/functions/table-functions/filesystem"},{"sidebarTitle":"format","title":"format","href":"/pt-BR/reference/functions/table-functions/format"},{"sidebarTitle":"fuzzJSON","title":"fuzzJSON","href":"/pt-BR/reference/functions/table-functions/fuzzJSON"},{"sidebarTitle":"fuzzQuery","title":"fuzzQuery","href":"/pt-BR/reference/functions/table-functions/fuzzQuery"},{"sidebarTitle":"gcs","title":"gcs","href":"/pt-BR/reference/functions/table-functions/gcs"},{"sidebarTitle":"generateRandom","title":"generateRandom","href":"/pt-BR/reference/functions/table-functions/generate"},{"sidebarTitle":"generate_series","title":"generate_series (generateSeries)","href":"/pt-BR/reference/functions/table-functions/generate_series"},{"sidebarTitle":"hdfs","title":"hdfs","href":"/pt-BR/reference/functions/table-functions/hdfs"},{"sidebarTitle":"hdfsCluster","title":"hdfsCluster","href":"/pt-BR/reference/functions/table-functions/hdfsCluster"},{"sidebarTitle":"hudi","title":"hudi","href":"/pt-BR/reference/functions/table-functions/hudi"},{"sidebarTitle":"hudiCluster","title":"Função de Tabela hudiCluster","href":"/pt-BR/reference/functions/table-functions/hudiCluster"},{"sidebarTitle":"iceberg","title":"iceberg","href":"/pt-BR/reference/functions/table-functions/iceberg"},{"sidebarTitle":"icebergCluster","title":"icebergCluster","href":"/pt-BR/reference/functions/table-functions/icebergCluster"},{"sidebarTitle":"input","title":"input","href":"/pt-BR/reference/functions/table-functions/input"},{"sidebarTitle":"jdbc","title":"jdbc","href":"/pt-BR/reference/functions/table-functions/jdbc"},{"title":"loop","href":"/pt-BR/reference/functions/table-functions/loop"},{"sidebarTitle":"merge","title":"merge","href":"/pt-BR/reference/functions/table-functions/merge"},{"sidebarTitle":"mergeTreeCodecBlockCounts","title":"mergeTreeCodecBlockCounts","href":"/pt-BR/reference/functions/table-functions/mergeTreeCodecBlockCounts"},{"sidebarTitle":"mergeTreeIndex","title":"mergeTreeIndex","href":"/pt-BR/reference/functions/table-functions/mergeTreeIndex"},{"sidebarTitle":"mergeTreeProjection","title":"mergeTreeProjection","href":"/pt-BR/reference/functions/table-functions/mergeTreeProjection"},{"sidebarTitle":"mergeTreeTextIndex","title":"mergeTreeTextIndex","href":"/pt-BR/reference/functions/table-functions/mergeTreeTextIndex"},{"sidebarTitle":"mongodb","title":"mongodb","href":"/pt-BR/reference/functions/table-functions/mongodb"},{"sidebarTitle":"mysql","title":"mysql","href":"/pt-BR/reference/functions/table-functions/mysql"},{"sidebarTitle":"função null","title":"null","href":"/pt-BR/reference/functions/table-functions/null"},{"sidebarTitle":"numbers","title":"numbers","href":"/pt-BR/reference/functions/table-functions/numbers"},{"sidebarTitle":"odbc","title":"odbc table function","href":"/pt-BR/reference/functions/table-functions/odbc"},{"sidebarTitle":"paimon","title":"paimon","href":"/pt-BR/reference/functions/table-functions/paimon"},{"sidebarTitle":"paimonCluster","title":"paimonCluster","href":"/pt-BR/reference/functions/table-functions/paimonCluster"},{"sidebarTitle":"postgresql","title":"postgresql","href":"/pt-BR/reference/functions/table-functions/postgresql"},{"sidebarTitle":"primes","title":"primes","href":"/pt-BR/reference/functions/table-functions/primes"},{"sidebarTitle":"prometheusQuery","title":"prometheusQuery","href":"/pt-BR/reference/functions/table-functions/prometheusQuery"},{"sidebarTitle":"prometheusQueryRange","title":"prometheusQueryRange","href":"/pt-BR/reference/functions/table-functions/prometheusQueryRange"},{"sidebarTitle":"redis","title":"redis","href":"/pt-BR/reference/functions/table-functions/redis"},{"sidebarTitle":"remote","title":"remote, remoteSecure","href":"/pt-BR/reference/functions/table-functions/remote"},{"sidebarTitle":"s3","title":"função de tabela S3","href":"/pt-BR/reference/functions/table-functions/s3"},{"sidebarTitle":"s3Cluster","title":"s3Cluster","href":"/pt-BR/reference/functions/table-functions/s3Cluster"},{"sidebarTitle":"sqlite","title":"sqlite","href":"/pt-BR/reference/functions/table-functions/sqlite"},{"sidebarTitle":"timeSeriesData","title":"timeSeriesData","href":"/pt-BR/reference/functions/table-functions/timeSeriesData"},{"sidebarTitle":"timeSeriesMetricFamilies","title":"timeSeriesMetricFamilies","href":"/pt-BR/reference/functions/table-functions/timeSeriesMetricFamilies"},{"sidebarTitle":"timeSeriesSamples","title":"timeSeriesSamples","href":"/pt-BR/reference/functions/table-functions/timeSeriesSamples"},{"sidebarTitle":"timeSeriesSelector","title":"timeSeriesSelector","href":"/pt-BR/reference/functions/table-functions/timeSeriesSelector"},{"sidebarTitle":"timeSeriesTags","title":"timeSeriesTags","href":"/pt-BR/reference/functions/table-functions/timeSeriesTags"},{"sidebarTitle":"url","title":"url","href":"/pt-BR/reference/functions/table-functions/url"},{"sidebarTitle":"urlCluster","title":"urlCluster","href":"/pt-BR/reference/functions/table-functions/urlCluster"},{"sidebarTitle":"values","title":"values","href":"/pt-BR/reference/functions/table-functions/values"},{"sidebarTitle":"view","title":"view","href":"/pt-BR/reference/functions/table-functions/view"},{"sidebarTitle":"ytsaurus","title":"ytsaurus","href":"/pt-BR/reference/functions/table-functions/ytsaurus"},{"sidebarTitle":"zeros","title":"zeros","href":"/pt-BR/reference/functions/table-functions/zeros"}]},{"group":"Funções de janela","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Funções de janela","href":"/pt-BR/reference/functions/window-functions/index"},{"sidebarTitle":"cume_dist","title":"cume_dist","href":"/pt-BR/reference/functions/window-functions/cume_dist"},{"sidebarTitle":"dense_rank","title":"dense_rank","href":"/pt-BR/reference/functions/window-functions/dense_rank"},{"sidebarTitle":"first_value","title":"first_value","href":"/pt-BR/reference/functions/window-functions/first_value"},{"sidebarTitle":"lag","title":"lag","href":"/pt-BR/reference/functions/window-functions/lag"},{"sidebarTitle":"lagInFrame","title":"lagInFrame","href":"/pt-BR/reference/functions/window-functions/lagInFrame"},{"sidebarTitle":"last_value","title":"last_value","href":"/pt-BR/reference/functions/window-functions/last_value"},{"sidebarTitle":"lead","title":"lead","href":"/pt-BR/reference/functions/window-functions/lead"},{"sidebarTitle":"leadInFrame","title":"leadInFrame","href":"/pt-BR/reference/functions/window-functions/leadInFrame"},{"sidebarTitle":"nonNegativeDerivative","title":"nonNegativeDerivative","href":"/pt-BR/reference/functions/window-functions/nonNegativeDerivative"},{"sidebarTitle":"nth_value","title":"nth_value","href":"/pt-BR/reference/functions/window-functions/nth_value"},{"sidebarTitle":"ntile","title":"ntile","href":"/pt-BR/reference/functions/window-functions/ntile"},{"sidebarTitle":"percent_rank","title":"percent_rank","href":"/pt-BR/reference/functions/window-functions/percent_rank"},{"sidebarTitle":"rank","title":"rank","href":"/pt-BR/reference/functions/window-functions/rank"},{"sidebarTitle":"row_number","title":"row_number","href":"/pt-BR/reference/functions/window-functions/row_number"}]},{"group":"Funções definidas pelo usuário","pages":[{"sidebarTitle":"UDF","title":"Funções definidas pelo usuário (UDFs)","href":"/pt-BR/reference/functions/regular-functions/udf"},{"sidebarTitle":"WebAssembly UDFs","title":"Funções Definidas pelo Usuário em WebAssembly","href":"/pt-BR/reference/functions/regular-functions/wasm_udf"}]}]},{"group":"Formatos","expanded":false,"pages":[{"sidebarTitle":"Ver todos os formatos...","title":"Formatos para dados de entrada e saída","href":"/pt-BR/reference/formats/index"},{"group":"Arrow","expanded":false,"pages":[{"title":"Arrow","href":"/pt-BR/reference/formats/Arrow/Arrow"},{"title":"ArrowStream","href":"/pt-BR/reference/formats/Arrow/ArrowStream"}]},{"group":"Avro","expanded":false,"pages":[{"title":"Avro","href":"/pt-BR/reference/formats/Avro/Avro"},{"title":"AvroConfluent","href":"/pt-BR/reference/formats/Avro/AvroConfluent"}]},{"title":"BSONEachRow","href":"/pt-BR/reference/formats/BSONEachRow"},{"title":"Buffers","href":"/pt-BR/reference/formats/Buffers"},{"group":"CSV","expanded":false,"pages":[{"title":"CSV","href":"/pt-BR/reference/formats/CSV/CSV"},{"title":"CSVWithNames","href":"/pt-BR/reference/formats/CSV/CSVWithNames"},{"title":"CSVWithNamesAndTypes","href":"/pt-BR/reference/formats/CSV/CSVWithNamesAndTypes"}]},{"title":"CapnProto","href":"/pt-BR/reference/formats/CapnProto"},{"group":"CustomSeparated","expanded":false,"pages":[{"title":"CustomSeparated","href":"/pt-BR/reference/formats/CustomSeparated/CustomSeparated"},{"title":"CustomSeparatedIgnoreSpaces","href":"/pt-BR/reference/formats/CustomSeparated/CustomSeparatedIgnoreSpaces"},{"title":"CustomSeparatedIgnoreSpacesWithNames","href":"/pt-BR/reference/formats/CustomSeparated/CustomSeparatedIgnoreSpacesWithNames"},{"title":"CustomSeparatedIgnoreSpacesWithNamesAndTypes","href":"/pt-BR/reference/formats/CustomSeparated/CustomSeparatedIgnoreSpacesWithNamesAndTypes"},{"title":"CustomSeparatedWithNames","href":"/pt-BR/reference/formats/CustomSeparated/CustomSeparatedWithNames"},{"title":"CustomSeparatedWithNamesAndTypes","href":"/pt-BR/reference/formats/CustomSeparated/CustomSeparatedWithNamesAndTypes"}]},{"title":"DWARF","href":"/pt-BR/reference/formats/DWARF"},{"title":"Form","href":"/pt-BR/reference/formats/Form"},{"sidebarTitle":"GeoJSON","title":"GeoJSON","href":"/pt-BR/reference/formats/GeoJSON"},{"title":"Hash","href":"/pt-BR/reference/formats/Hash"},{"title":"HiveText","href":"/pt-BR/reference/formats/HiveText"},{"group":"JSON","expanded":false,"pages":[{"title":"JSON","href":"/pt-BR/reference/formats/JSON/JSON"},{"title":"JSONAsObject","href":"/pt-BR/reference/formats/JSON/JSONAsObject"},{"title":"JSONAsString","href":"/pt-BR/reference/formats/JSON/JSONAsString"},{"title":"JSONColumns","href":"/pt-BR/reference/formats/JSON/JSONColumns"},{"title":"JSONColumnsWithMetadata","href":"/pt-BR/reference/formats/JSON/JSONColumnsWithMetadata"},{"title":"JSONCompact","href":"/pt-BR/reference/formats/JSON/JSONCompact"},{"title":"JSONCompactColumns","href":"/pt-BR/reference/formats/JSON/JSONCompactColumns"},{"title":"JSONCompactEachRow","href":"/pt-BR/reference/formats/JSON/JSONCompactEachRow"},{"title":"JSONCompactEachRowWithNames","href":"/pt-BR/reference/formats/JSON/JSONCompactEachRowWithNames"},{"title":"JSONCompactEachRowWithNamesAndTypes","href":"/pt-BR/reference/formats/JSON/JSONCompactEachRowWithNamesAndTypes"},{"title":"JSONCompactEachRowWithProgress","href":"/pt-BR/reference/formats/JSON/JSONCompactEachRowWithProgress"},{"title":"JSONCompactStrings","href":"/pt-BR/reference/formats/JSON/JSONCompactStrings"},{"title":"JSONCompactStringsEachRow","href":"/pt-BR/reference/formats/JSON/JSONCompactStringsEachRow"},{"title":"JSONCompactStringsEachRowWithNames","href":"/pt-BR/reference/formats/JSON/JSONCompactStringsEachRowWithNames"},{"title":"JSONCompactStringsEachRowWithNamesAndTypes","href":"/pt-BR/reference/formats/JSON/JSONCompactStringsEachRowWithNamesAndTypes"},{"title":"JSONCompactStringsEachRowWithProgress","href":"/pt-BR/reference/formats/JSON/JSONCompactStringsEachRowWithProgress"},{"title":"JSONEachRow","href":"/pt-BR/reference/formats/JSON/JSONEachRow"},{"title":"JSONEachRowWithProgress","href":"/pt-BR/reference/formats/JSON/JSONEachRowWithProgress"},{"title":"JSONLines","href":"/pt-BR/reference/formats/JSON/JSONLines"},{"title":"JSONObjectEachRow","href":"/pt-BR/reference/formats/JSON/JSONObjectEachRow"},{"title":"JSONStrings","href":"/pt-BR/reference/formats/JSON/JSONStrings"},{"title":"JSONStringsEachRow","href":"/pt-BR/reference/formats/JSON/JSONStringsEachRow"},{"title":"JSONStringsEachRowWithProgress","href":"/pt-BR/reference/formats/JSON/JSONStringsEachRowWithProgress"},{"title":"PrettyJSONEachRow","href":"/pt-BR/reference/formats/JSON/PrettyJSONEachRow"},{"title":"Configurações de formato para o JSON","href":"/pt-BR/reference/formats/JSON/format-settings"}]},{"group":"LineAsString","expanded":false,"pages":[{"title":"LineAsString","href":"/pt-BR/reference/formats/LineAsString/LineAsString"},{"title":"LineAsStringWithNames","href":"/pt-BR/reference/formats/LineAsString/LineAsStringWithNames"},{"title":"LineAsStringWithNamesAndTypes","href":"/pt-BR/reference/formats/LineAsString/LineAsStringWithNamesAndTypes"}]},{"title":"Markdown","href":"/pt-BR/reference/formats/Markdown"},{"title":"MsgPack","href":"/pt-BR/reference/formats/MsgPack"},{"title":"MySQLDump","href":"/pt-BR/reference/formats/MySQLDump"},{"title":"MySQLWire","href":"/pt-BR/reference/formats/MySQLWire"},{"title":"Native","href":"/pt-BR/reference/formats/Native"},{"title":"Npy","href":"/pt-BR/reference/formats/Npy"},{"title":"Null","href":"/pt-BR/reference/formats/Null"},{"title":"ODBCDriver2","href":"/pt-BR/reference/formats/ODBCDriver2"},{"title":"ORC","href":"/pt-BR/reference/formats/ORC"},{"title":"One","href":"/pt-BR/reference/formats/One"},{"group":"Parquet","expanded":false,"pages":[{"title":"Parquet","href":"/pt-BR/reference/formats/Parquet/Parquet"},{"title":"ParquetMetadata","href":"/pt-BR/reference/formats/Parquet/ParquetMetadata"}]},{"title":"PNG","href":"/pt-BR/reference/formats/PNG"},{"title":"PostgreSQLWire","href":"/pt-BR/reference/formats/PostgreSQLWire"},{"group":"Pretty","expanded":false,"pages":[{"title":"Pretty","href":"/pt-BR/reference/formats/Pretty/Pretty"},{"title":"PrettyCompact","href":"/pt-BR/reference/formats/Pretty/PrettyCompact"},{"title":"PrettyCompactMonoBlock","href":"/pt-BR/reference/formats/Pretty/PrettyCompactMonoBlock"},{"title":"PrettyCompactNoEscapes","href":"/pt-BR/reference/formats/Pretty/PrettyCompactNoEscapes"},{"title":"PrettyCompactNoEscapesMonoBlock","href":"/pt-BR/reference/formats/Pretty/PrettyCompactNoEscapesMonoBlock"},{"title":"PrettyMonoBlock","href":"/pt-BR/reference/formats/Pretty/PrettyMonoBlock"},{"title":"PrettyNoEscapes","href":"/pt-BR/reference/formats/Pretty/PrettyNoEscapes"},{"title":"PrettyNoEscapesMonoBlock","href":"/pt-BR/reference/formats/Pretty/PrettyNoEscapesMonoBlock"},{"title":"PrettySpace","href":"/pt-BR/reference/formats/Pretty/PrettySpace"},{"title":"PrettySpaceMonoBlock","href":"/pt-BR/reference/formats/Pretty/PrettySpaceMonoBlock"},{"title":"PrettySpaceNoEscapes","href":"/pt-BR/reference/formats/Pretty/PrettySpaceNoEscapes"},{"title":"PrettySpaceNoEscapesMonoBlock","href":"/pt-BR/reference/formats/Pretty/PrettySpaceNoEscapesMonoBlock"}]},{"title":"Prometheus","href":"/pt-BR/reference/formats/Prometheus"},{"group":"Protobuf","expanded":false,"pages":[{"title":"Protobuf","href":"/pt-BR/reference/formats/Protobuf/Protobuf"},{"title":"ProtobufList","href":"/pt-BR/reference/formats/Protobuf/ProtobufList"},{"title":"ProtobufSingle","href":"/pt-BR/reference/formats/Protobuf/ProtobufSingle"}]},{"group":"Puffin","expanded":false,"pages":[{"title":"Puffin","href":"/pt-BR/reference/formats/Puffin/Puffin"},{"title":"PuffinMetadata","href":"/pt-BR/reference/formats/Puffin/PuffinMetadata"}]},{"title":"RawBLOB","href":"/pt-BR/reference/formats/RawBLOB"},{"title":"Regexp","href":"/pt-BR/reference/formats/Regexp"},{"group":"RowBinary","expanded":false,"pages":[{"title":"RowBinary","href":"/pt-BR/reference/formats/RowBinary/RowBinary"},{"title":"RowBinaryWithDefaults","href":"/pt-BR/reference/formats/RowBinary/RowBinaryWithDefaults"},{"title":"RowBinaryWithNames","href":"/pt-BR/reference/formats/RowBinary/RowBinaryWithNames"},{"title":"RowBinaryWithNamesAndTypes","href":"/pt-BR/reference/formats/RowBinary/RowBinaryWithNamesAndTypes"},{"title":"RowBinaryWithNamesAndTypesAndDefaults","href":"/pt-BR/reference/formats/RowBinary/RowBinaryWithNamesAndTypesAndDefaults"}]},{"title":"SQLInsert","href":"/pt-BR/reference/formats/SQLInsert"},{"title":"SQLite","href":"/pt-BR/reference/formats/SQLite"},{"group":"TabSeparated","expanded":false,"pages":[{"title":"TSKV","href":"/pt-BR/reference/formats/TabSeparated/TSKV"},{"title":"TabSeparated","href":"/pt-BR/reference/formats/TabSeparated/TabSeparated"},{"title":"TabSeparatedRaw","href":"/pt-BR/reference/formats/TabSeparated/TabSeparatedRaw"},{"title":"TabSeparatedRawWithNames","href":"/pt-BR/reference/formats/TabSeparated/TabSeparatedRawWithNames"},{"title":"TabSeparatedRawWithNamesAndTypes","href":"/pt-BR/reference/formats/TabSeparated/TabSeparatedRawWithNamesAndTypes"},{"title":"TabSeparatedWithNames","href":"/pt-BR/reference/formats/TabSeparated/TabSeparatedWithNames"},{"title":"TabSeparatedWithNamesAndTypes","href":"/pt-BR/reference/formats/TabSeparated/TabSeparatedWithNamesAndTypes"}]},{"group":"Template","expanded":false,"pages":[{"title":"Template","href":"/pt-BR/reference/formats/Template/Template"},{"title":"TemplateIgnoreSpaces","href":"/pt-BR/reference/formats/Template/TemplateIgnoreSpaces"}]},{"title":"Values","href":"/pt-BR/reference/formats/Values"},{"title":"Vertical","href":"/pt-BR/reference/formats/Vertical"},{"title":"XML","href":"/pt-BR/reference/formats/XML"}]},{"group":"Configurações","expanded":false,"pages":[{"title":"Configurações","sidebarTitle":"Visão geral","mode":"wide","href":"/pt-BR/reference/settings/index"},{"group":"Configurações do servidor","directory":"none","pages":[{"sidebarTitle":"Visão geral","title":"Configurações do servidor","href":"/pt-BR/reference/settings/server-settings/settings"},{"title":"configurações do servidor access_control_*","sidebarTitle":"access_control_*","href":"/pt-BR/reference/settings/server-settings/settings/access-control"},{"title":"configurações do servidor aggregate_function_*","sidebarTitle":"aggregate_function_*","href":"/pt-BR/reference/settings/server-settings/settings/aggregate-function"},{"title":"configurações do servidor allow_*","sidebarTitle":"allow_*","href":"/pt-BR/reference/settings/server-settings/settings/allow"},{"title":"configurações de servidor allow_experimental_*","sidebarTitle":"allow_experimental_*","href":"/pt-BR/reference/settings/server-settings/settings/allow-experimental"},{"title":"configurações do servidor para async_insert_*","sidebarTitle":"async_insert_*","href":"/pt-BR/reference/settings/server-settings/settings/async-insert"},{"title":"configurações do servidor async_load_*","sidebarTitle":"async_load_*","href":"/pt-BR/reference/settings/server-settings/settings/async-load"},{"title":"configurações de servidor asynchronous_*","sidebarTitle":"asynchronous_*","href":"/pt-BR/reference/settings/server-settings/settings/asynchronous"},{"title":"configurações do servidor asynchronous_metrics_*","sidebarTitle":"asynchronous_metrics_*","href":"/pt-BR/reference/settings/server-settings/settings/asynchronous-metrics"},{"title":"configurações do servidor background_*","sidebarTitle":"background_*","href":"/pt-BR/reference/settings/server-settings/settings/background"},{"title":"configurações de servidor background_merges_*","sidebarTitle":"background_merges_*","href":"/pt-BR/reference/settings/server-settings/settings/background-merges"},{"title":"configurações do servidor background_schedule_*","sidebarTitle":"background_schedule_*","href":"/pt-BR/reference/settings/server-settings/settings/background-schedule"},{"title":"configurações de servidor backup_*","sidebarTitle":"backup_*","href":"/pt-BR/reference/settings/server-settings/settings/backup"},{"title":"configurações do servidor backups_*","sidebarTitle":"backups_*","href":"/pt-BR/reference/settings/server-settings/settings/backups"},{"title":"Configurações do servidor columns_cache_*","sidebarTitle":"columns_cache_*","href":"/pt-BR/reference/settings/server-settings/settings/columns-cache"},{"title":"configurações do servidor compiled_expression_*","sidebarTitle":"compiled_expression_*","href":"/pt-BR/reference/settings/server-settings/settings/compiled-expression"},{"title":"configurações do servidor concurrent_threads_*","sidebarTitle":"concurrent_threads_*","href":"/pt-BR/reference/settings/server-settings/settings/concurrent-threads"},{"title":"configurações do servidor cpu_slot_*","sidebarTitle":"cpu_slot_*","href":"/pt-BR/reference/settings/server-settings/settings/cpu-slot"},{"title":"configurações de servidor custom_*","sidebarTitle":"custom_*","href":"/pt-BR/reference/settings/server-settings/settings/custom"},{"title":"configurações do servidor database_catalog_*","sidebarTitle":"database_catalog_*","href":"/pt-BR/reference/settings/server-settings/settings/database-catalog"},{"title":"configurações do servidor database_replicated_*","sidebarTitle":"database_replicated_*","href":"/pt-BR/reference/settings/server-settings/settings/database-replicated"},{"title":"configurações de servidor default_*","sidebarTitle":"default_*","href":"/pt-BR/reference/settings/server-settings/settings/default"},{"title":"configurações do servidor default_replica_*","sidebarTitle":"default_replica_*","href":"/pt-BR/reference/settings/server-settings/settings/default-replica"},{"title":"configurações de servidor dictionaries_*","sidebarTitle":"dictionaries_*","href":"/pt-BR/reference/settings/server-settings/settings/dictionaries"},{"title":"configurações disable_* do servidor","sidebarTitle":"disable_*","href":"/pt-BR/reference/settings/server-settings/settings/disable"},{"title":"configurações de servidor disk_connections_*","sidebarTitle":"disk_connections_*","href":"/pt-BR/reference/settings/server-settings/settings/disk-connections"},{"title":"configurações do servidor distributed_*","sidebarTitle":"distributed_*","href":"/pt-BR/reference/settings/server-settings/settings/distributed"},{"title":"configurações do servidor distributed_cache_*","sidebarTitle":"distributed_cache_*","href":"/pt-BR/reference/settings/server-settings/settings/distributed-cache"},{"title":"configurações do servidor distributed_ddl_*","sidebarTitle":"distributed_ddl_*","href":"/pt-BR/reference/settings/server-settings/settings/distributed-ddl"},{"title":"configurações de servidor dns_allow_*","sidebarTitle":"dns_allow_*","href":"/pt-BR/reference/settings/server-settings/settings/dns-allow"},{"title":"configurações do servidor dns_cache_*","sidebarTitle":"dns_cache_*","href":"/pt-BR/reference/settings/server-settings/settings/dns-cache"},{"title":"configurações do servidor drop_distributed_*","sidebarTitle":"drop_distributed_*","href":"/pt-BR/reference/settings/server-settings/settings/drop-distributed"},{"title":"configurações enable_* do servidor","sidebarTitle":"enable_*","href":"/pt-BR/reference/settings/server-settings/settings/enable"},{"title":"configurações do servidor encryption_header_*","sidebarTitle":"encryption_header_*","href":"/pt-BR/reference/settings/server-settings/settings/encryption-header"},{"title":"configurações do servidor format_*","sidebarTitle":"format_*","href":"/pt-BR/reference/settings/server-settings/settings/format"},{"title":"configurações do servidor global_profiler_*","sidebarTitle":"global_profiler_*","href":"/pt-BR/reference/settings/server-settings/settings/global-profiler"},{"title":"configurações do servidor graphite_*","sidebarTitle":"graphite_*","href":"/pt-BR/reference/settings/server-settings/settings/graphite"},{"title":"configurações do servidor http_*","sidebarTitle":"http_*","href":"/pt-BR/reference/settings/server-settings/settings/http"},{"title":"configurações do servidor http_connections_*","sidebarTitle":"http_connections_*","href":"/pt-BR/reference/settings/server-settings/settings/http-connections"},{"title":"configurações do servidor iceberg_catalog_*","sidebarTitle":"iceberg_catalog_*","href":"/pt-BR/reference/settings/server-settings/settings/iceberg-catalog"},{"title":"configurações do servidor iceberg_compaction_*","sidebarTitle":"iceberg_compaction_*","href":"/pt-BR/reference/settings/server-settings/settings/iceberg-compaction"},{"title":"configurações de servidor iceberg_metadata_*","sidebarTitle":"iceberg_metadata_*","href":"/pt-BR/reference/settings/server-settings/settings/iceberg-metadata"},{"title":"configurações de servidor iceberg_scheduler_*","sidebarTitle":"iceberg_scheduler_*","href":"/pt-BR/reference/settings/server-settings/settings/iceberg-scheduler"},{"title":"Configurações do servidor index_mark_*","sidebarTitle":"index_mark_*","href":"/pt-BR/reference/settings/server-settings/settings/index-mark"},{"title":"configurações do servidor index_uncompressed_*","sidebarTitle":"index_uncompressed_*","href":"/pt-BR/reference/settings/server-settings/settings/index-uncompressed"},{"title":"configurações do servidor interserver_*","sidebarTitle":"interserver_*","href":"/pt-BR/reference/settings/server-settings/settings/interserver"},{"title":"configurações de servidor interserver_http_*","sidebarTitle":"interserver_http_*","href":"/pt-BR/reference/settings/server-settings/settings/interserver-http"},{"title":"configurações do servidor interserver_https_*","sidebarTitle":"interserver_https_*","href":"/pt-BR/reference/settings/server-settings/settings/interserver-https"},{"title":"configurações de servidor jemalloc_*","sidebarTitle":"jemalloc_*","href":"/pt-BR/reference/settings/server-settings/settings/jemalloc"},{"title":"Configurações do servidor jemalloc_enable_*","sidebarTitle":"jemalloc_enable_*","href":"/pt-BR/reference/settings/server-settings/settings/jemalloc-enable"},{"title":"Configurações do servidor jemalloc_flush_*","sidebarTitle":"jemalloc_flush_*","href":"/pt-BR/reference/settings/server-settings/settings/jemalloc-flush"},{"title":"configurações do servidor keeper_*","sidebarTitle":"keeper_*","href":"/pt-BR/reference/settings/server-settings/settings/keeper"},{"title":"configurações de servidor keeper_server.socket_*","sidebarTitle":"keeper_server.socket_*","href":"/pt-BR/reference/settings/server-settings/settings/keeper-server-socket"},{"title":"configurações de servidor license_*","sidebarTitle":"license_*","href":"/pt-BR/reference/settings/server-settings/settings/license"},{"title":"configurações do servidor listen_*","sidebarTitle":"listen_*","href":"/pt-BR/reference/settings/server-settings/settings/listen"},{"title":"configurações do servidor load_marks_*","sidebarTitle":"load_marks_*","href":"/pt-BR/reference/settings/server-settings/settings/load-marks"},{"title":"Configurações do servidor logger.async_*","sidebarTitle":"logger.async_*","href":"/pt-BR/reference/settings/server-settings/settings/logger-async"},{"title":"configurações de servidor logger.console_*","sidebarTitle":"logger.console_*","href":"/pt-BR/reference/settings/server-settings/settings/logger-console"},{"title":"configurações do servidor mark_cache_*","sidebarTitle":"mark_cache_*","href":"/pt-BR/reference/settings/server-settings/settings/mark-cache"},{"title":"configurações de servidor max_*","sidebarTitle":"max_*","href":"/pt-BR/reference/settings/server-settings/settings/max"},{"title":"configurações do servidor max_backups_*","sidebarTitle":"max_backups_*","href":"/pt-BR/reference/settings/server-settings/settings/max-backups"},{"title":"configurações do servidor max_concurrent_*","sidebarTitle":"max_concurrent_*","href":"/pt-BR/reference/settings/server-settings/settings/max-concurrent"},{"title":"configurações do servidor max_database_*","sidebarTitle":"max_database_*","href":"/pt-BR/reference/settings/server-settings/settings/max-database"},{"title":"configurações do servidor max_dictionary_*","sidebarTitle":"max_dictionary_*","href":"/pt-BR/reference/settings/server-settings/settings/max-dictionary"},{"title":"configurações do servidor max_distributed_*","sidebarTitle":"max_distributed_*","href":"/pt-BR/reference/settings/server-settings/settings/max-distributed"},{"title":"configurações do servidor max_format_*","sidebarTitle":"max_format_*","href":"/pt-BR/reference/settings/server-settings/settings/max-format"},{"title":"configurações de servidor max_io_*","sidebarTitle":"max_io_*","href":"/pt-BR/reference/settings/server-settings/settings/max-io"},{"title":"configurações do servidor max_local_*","sidebarTitle":"max_local_*","href":"/pt-BR/reference/settings/server-settings/settings/max-local"},{"title":"configurações de servidor max_named_*","sidebarTitle":"max_named_*","href":"/pt-BR/reference/settings/server-settings/settings/max-named"},{"title":"configurações de servidor max_pending_*","sidebarTitle":"max_pending_*","href":"/pt-BR/reference/settings/server-settings/settings/max-pending"},{"title":"configurações de servidor max_prefixes_*","sidebarTitle":"max_prefixes_*","href":"/pt-BR/reference/settings/server-settings/settings/max-prefixes"},{"title":"configurações de servidor max_remote_*","sidebarTitle":"max_remote_*","href":"/pt-BR/reference/settings/server-settings/settings/max-remote"},{"title":"configurações do servidor max_replicated_*","sidebarTitle":"max_replicated_*","href":"/pt-BR/reference/settings/server-settings/settings/max-replicated"},{"title":"configurações do servidor max_server_memory_usage_*","sidebarTitle":"max_server_memory_usage_*","href":"/pt-BR/reference/settings/server-settings/settings/max-server-memory-usage"},{"title":"configurações do servidor max_snapshot_*","sidebarTitle":"max_snapshot_*","href":"/pt-BR/reference/settings/server-settings/settings/max-snapshot"},{"title":"configurações do servidor max_table_*","sidebarTitle":"max_table_*","href":"/pt-BR/reference/settings/server-settings/settings/max-table"},{"title":"configurações do servidor max_thread_*","sidebarTitle":"max_thread_*","href":"/pt-BR/reference/settings/server-settings/settings/max-thread"},{"title":"configurações de servidor max_view_*","sidebarTitle":"max_view_*","href":"/pt-BR/reference/settings/server-settings/settings/max-view"},{"title":"configurações do servidor memory_worker_*","sidebarTitle":"memory_worker_*","href":"/pt-BR/reference/settings/server-settings/settings/memory-worker"},{"title":"configurações de servidor merge_*","sidebarTitle":"merge_*","href":"/pt-BR/reference/settings/server-settings/settings/merge"},{"title":"configurações do servidor merges_mutations_*","sidebarTitle":"merges_mutations_*","href":"/pt-BR/reference/settings/server-settings/settings/merges-mutations"},{"title":"configurações do servidor min_*","sidebarTitle":"min_*","href":"/pt-BR/reference/settings/server-settings/settings/min"},{"title":"mlock_executable_*: configurações do servidor","sidebarTitle":"mlock_executable_*","href":"/pt-BR/reference/settings/server-settings/settings/mlock-executable"},{"title":"configurações do servidor mysql_*","sidebarTitle":"mysql_*","href":"/pt-BR/reference/settings/server-settings/settings/mysql"},{"title":"configurações de servidor oom_canary_*","sidebarTitle":"oom_canary_*","href":"/pt-BR/reference/settings/server-settings/settings/oom-canary"},{"title":"Configurações do servidor openSSL.client.requireTLSv1_*","sidebarTitle":"openSSL.client.requireTLSv1_*","href":"/pt-BR/reference/settings/server-settings/settings/openssl-client-requiretlsv1"},{"title":"configurações do servidor openSSL.server.requireTLSv1_*","sidebarTitle":"openSSL.server.requireTLSv1_*","href":"/pt-BR/reference/settings/server-settings/settings/openssl-server-requiretlsv1"},{"title":"configurações do servidor os_*","sidebarTitle":"os_*","href":"/pt-BR/reference/settings/server-settings/settings/os"},{"title":"configurações do servidor os_threads_*","sidebarTitle":"os_threads_*","href":"/pt-BR/reference/settings/server-settings/settings/os-threads"},{"title":"configurações do servidor page_cache_*","sidebarTitle":"page_cache_*","href":"/pt-BR/reference/settings/server-settings/settings/page-cache"},{"title":"configurações do servidor paimon_metadata_*","sidebarTitle":"paimon_metadata_*","href":"/pt-BR/reference/settings/server-settings/settings/paimon-metadata"},{"title":"configurações do servidor parquet_metadata_*","sidebarTitle":"parquet_metadata_*","href":"/pt-BR/reference/settings/server-settings/settings/parquet-metadata"},{"title":"Configurações do servidor parts_kill_delay_period_*","sidebarTitle":"parts_kill_delay_period_*","href":"/pt-BR/reference/settings/server-settings/settings/parts-kill-delay-period"},{"title":"configurações do servidor parts_killer_*","sidebarTitle":"parts_killer_*","href":"/pt-BR/reference/settings/server-settings/settings/parts-killer"},{"title":"configurações do servidor postgresql_*","sidebarTitle":"postgresql_*","href":"/pt-BR/reference/settings/server-settings/settings/postgresql"},{"title":"configurações do servidor prefetch_threadpool_*","sidebarTitle":"prefetch_threadpool_*","href":"/pt-BR/reference/settings/server-settings/settings/prefetch-threadpool"},{"title":"configurações do servidor primary_index_*","sidebarTitle":"primary_index_*","href":"/pt-BR/reference/settings/server-settings/settings/primary-index"},{"title":"configurações de servidor query_*","sidebarTitle":"query_*","href":"/pt-BR/reference/settings/server-settings/settings/query"},{"title":"configurações do servidor query_cache.max_*","sidebarTitle":"query_cache.max_*","href":"/pt-BR/reference/settings/server-settings/settings/query-cache-max"},{"title":"configurações do servidor query_condition_*","sidebarTitle":"query_condition_*","href":"/pt-BR/reference/settings/server-settings/settings/query-condition"},{"title":"Configurações de servidor reader_executor_*","sidebarTitle":"reader_executor_*","href":"/pt-BR/reference/settings/server-settings/settings/reader-executor"},{"title":"configurações do servidor remote_*","sidebarTitle":"remote_*","href":"/pt-BR/reference/settings/server-settings/settings/remote"},{"title":"configurações do servidor replicated_fetches_*","sidebarTitle":"replicated_fetches_*","href":"/pt-BR/reference/settings/server-settings/settings/replicated-fetches"},{"title":"configurações do servidor s3_*","sidebarTitle":"s3_*","href":"/pt-BR/reference/settings/server-settings/settings/s3"},{"title":"configurações do servidor s3queue_*","sidebarTitle":"s3queue_*","href":"/pt-BR/reference/settings/server-settings/settings/s3queue"},{"title":"configurações do servidor show_*","sidebarTitle":"show_*","href":"/pt-BR/reference/settings/server-settings/settings/show"},{"title":"configurações de servidor shutdown_wait_*","sidebarTitle":"shutdown_wait_*","href":"/pt-BR/reference/settings/server-settings/settings/shutdown-wait"},{"title":"Configurações do servidor skip_*","sidebarTitle":"skip_*","href":"/pt-BR/reference/settings/server-settings/settings/skip"},{"title":"configurações de servidor snapshot_cleaner_*","sidebarTitle":"snapshot_cleaner_*","href":"/pt-BR/reference/settings/server-settings/settings/snapshot-cleaner"},{"title":"configurações de servidor startup_*","sidebarTitle":"startup_*","href":"/pt-BR/reference/settings/server-settings/settings/startup"},{"title":"configurações do servidor storage_*","sidebarTitle":"storage_*","href":"/pt-BR/reference/settings/server-settings/settings/storage"},{"title":"configurações do servidor storage_connections_*","sidebarTitle":"storage_connections_*","href":"/pt-BR/reference/settings/server-settings/settings/storage-connections"},{"title":"configurações do servidor tables_loader_*","sidebarTitle":"tables_loader_*","href":"/pt-BR/reference/settings/server-settings/settings/tables-loader"},{"title":"configurações do servidor tcp_close_*","sidebarTitle":"tcp_close_*","href":"/pt-BR/reference/settings/server-settings/settings/tcp-close"},{"title":"configurações do servidor tcp_port_*","sidebarTitle":"tcp_port_*","href":"/pt-BR/reference/settings/server-settings/settings/tcp-port"},{"title":"configurações do servidor temporary_data_*","sidebarTitle":"temporary_data_*","href":"/pt-BR/reference/settings/server-settings/settings/temporary-data"},{"title":"configurações de servidor text_index_*","sidebarTitle":"text_index_*","href":"/pt-BR/reference/settings/server-settings/settings/text-index"},{"title":"configurações do servidor threadpool_local_*","sidebarTitle":"threadpool_local_*","href":"/pt-BR/reference/settings/server-settings/settings/threadpool-local"},{"title":"configurações do servidor para threadpool_remote_*","sidebarTitle":"threadpool_remote_*","href":"/pt-BR/reference/settings/server-settings/settings/threadpool-remote"},{"title":"configurações de servidor threadpool_writer_*","sidebarTitle":"threadpool_writer_*","href":"/pt-BR/reference/settings/server-settings/settings/threadpool-writer"},{"title":"configurações do servidor tmp_*","sidebarTitle":"tmp_*","href":"/pt-BR/reference/settings/server-settings/settings/tmp"},{"title":"configurações do servidor top_level_*","sidebarTitle":"top_level_*","href":"/pt-BR/reference/settings/server-settings/settings/top-level"},{"title":"configurações de servidor total_memory_*","sidebarTitle":"total_memory_*","href":"/pt-BR/reference/settings/server-settings/settings/total-memory"},{"title":"configurações do servidor uncompressed_cache_*","sidebarTitle":"uncompressed_cache_*","href":"/pt-BR/reference/settings/server-settings/settings/uncompressed-cache"},{"title":"configurações do servidor unique_key_*","sidebarTitle":"unique_key_*","href":"/pt-BR/reference/settings/server-settings/settings/unique-key"},{"title":"configurações do servidor use_*","sidebarTitle":"use_*","href":"/pt-BR/reference/settings/server-settings/settings/use"},{"title":"configurações do servidor user_*","sidebarTitle":"user_*","href":"/pt-BR/reference/settings/server-settings/settings/user"},{"title":"configurações do servidor user_defined_*","sidebarTitle":"user_defined_*","href":"/pt-BR/reference/settings/server-settings/settings/user-defined"},{"title":"configurações do servidor users_*","sidebarTitle":"users_*","href":"/pt-BR/reference/settings/server-settings/settings/users"},{"title":"configurações do servidor vector_similarity_*","sidebarTitle":"vector_similarity_*","href":"/pt-BR/reference/settings/server-settings/settings/vector-similarity"},{"title":"configurações do servidor workload_*","sidebarTitle":"workload_*","href":"/pt-BR/reference/settings/server-settings/settings/workload"},{"title":"configurações de servidor zookeeper_*","sidebarTitle":"zookeeper_*","href":"/pt-BR/reference/settings/server-settings/settings/zookeeper"},{"title":"Outras configurações do servidor","sidebarTitle":"Outras","href":"/pt-BR/reference/settings/server-settings/settings/other"}]},{"group":"Configurações de sessão","root":{"title":"Configurações da sessão","sidebarTitle":"Visão geral","href":"/pt-BR/reference/settings/session-settings"},"directory":"none","pages":[{"title":"configurações de sessão additional_*","sidebarTitle":"additional_*","href":"/pt-BR/reference/settings/session-settings/additional"},{"title":"configurações de sessão aggregate_*","sidebarTitle":"aggregate_*","href":"/pt-BR/reference/settings/session-settings/aggregate"},{"title":"configurações de sessão de aggregation_*","sidebarTitle":"aggregation_*","href":"/pt-BR/reference/settings/session-settings/aggregation"},{"title":"configurações de sessão ai_function_*","sidebarTitle":"ai_function_*","href":"/pt-BR/reference/settings/session-settings/ai-function"},{"title":"configurações de sessão allow_*","sidebarTitle":"allow_*","href":"/pt-BR/reference/settings/session-settings/allow"},{"title":"configurações de sessão allow_deprecated_*","sidebarTitle":"allow_deprecated_*","href":"/pt-BR/reference/settings/session-settings/allow-deprecated"},{"title":"configurações de sessão allow_experimental_*","sidebarTitle":"allow_experimental_*","href":"/pt-BR/reference/settings/session-settings/allow-experimental"},{"title":"configurações de sessão allow_nondeterministic_*","sidebarTitle":"allow_nondeterministic_*","href":"/pt-BR/reference/settings/session-settings/allow-nondeterministic"},{"title":"configurações de sessão allow_prefetched_*","sidebarTitle":"allow_prefetched_*","href":"/pt-BR/reference/settings/session-settings/allow-prefetched"},{"title":"configurações de sessão allow_push_*","sidebarTitle":"allow_push_*","href":"/pt-BR/reference/settings/session-settings/allow-push"},{"title":"configurações de sessão allow_statistics_*","sidebarTitle":"allow_statistics_*","href":"/pt-BR/reference/settings/session-settings/allow-statistics"},{"title":"configurações de sessão allow_suspicious_*","sidebarTitle":"allow_suspicious_*","href":"/pt-BR/reference/settings/session-settings/allow-suspicious"},{"title":"configurações de sessão alter_*","sidebarTitle":"alter_*","href":"/pt-BR/reference/settings/session-settings/alter"},{"title":"configurações de sessão de analyzer_compatibility_*","sidebarTitle":"analyzer_compatibility_*","href":"/pt-BR/reference/settings/session-settings/analyzer-compatibility"},{"title":"configurações de sessão apply_*","sidebarTitle":"apply_*","href":"/pt-BR/reference/settings/session-settings/apply"},{"title":"configurações de sessão apply_patch_parts_*","sidebarTitle":"apply_patch_parts_*","href":"/pt-BR/reference/settings/session-settings/apply-patch-parts"},{"title":"configurações de sessão ast_fuzzer_*","sidebarTitle":"ast_fuzzer_*","href":"/pt-BR/reference/settings/session-settings/ast-fuzzer"},{"title":"configurações de sessão asterisk_include_*","sidebarTitle":"asterisk_include_*","href":"/pt-BR/reference/settings/session-settings/asterisk-include"},{"title":"configurações de sessão async_*","sidebarTitle":"async_*","href":"/pt-BR/reference/settings/session-settings/async"},{"title":"configurações de sessão async_insert_*","sidebarTitle":"async_insert_*","href":"/pt-BR/reference/settings/session-settings/async-insert"},{"title":"configurações de sessão automatic_parallel_*","sidebarTitle":"automatic_parallel_*","href":"/pt-BR/reference/settings/session-settings/automatic-parallel"},{"title":"configurações de sessão de azure_*","sidebarTitle":"azure_*","href":"/pt-BR/reference/settings/session-settings/azure"},{"title":"configurações de sessão azure_max_*","sidebarTitle":"azure_max_*","href":"/pt-BR/reference/settings/session-settings/azure-max"},{"title":"configurações de sessão do azure_sdk_*","sidebarTitle":"azure_sdk_*","href":"/pt-BR/reference/settings/session-settings/azure-sdk"},{"title":"configurações de sessão azure_upload_*","sidebarTitle":"azure_upload_*","href":"/pt-BR/reference/settings/session-settings/azure-upload"},{"title":"configurações de sessão backup_restore_*","sidebarTitle":"backup_restore_*","href":"/pt-BR/reference/settings/session-settings/backup-restore"},{"title":"configurações de sessão cast_*","sidebarTitle":"cast_*","href":"/pt-BR/reference/settings/session-settings/cast"},{"title":"configurações de sessão cast_string_*","sidebarTitle":"cast_string_*","href":"/pt-BR/reference/settings/session-settings/cast-string"},{"title":"configurações de sessão check_*","sidebarTitle":"check_*","href":"/pt-BR/reference/settings/session-settings/check"},{"title":"configurações de sessão cloud_mode_*","sidebarTitle":"cloud_mode_*","href":"/pt-BR/reference/settings/session-settings/cloud-mode"},{"title":"configurações de sessão de cluster_*","sidebarTitle":"cluster_*","href":"/pt-BR/reference/settings/session-settings/cluster"},{"title":"configurações de sessão de cluster_table_*","sidebarTitle":"cluster_table_*","href":"/pt-BR/reference/settings/session-settings/cluster-table"},{"title":"configurações de sessão collect_hash_*","sidebarTitle":"collect_hash_*","href":"/pt-BR/reference/settings/session-settings/collect-hash"},{"title":"Configurações de sessão columns_cache_*","sidebarTitle":"columns_cache_*","href":"/pt-BR/reference/settings/session-settings/columns-cache"},{"title":"configurações de sessão compatibility_*","sidebarTitle":"compatibility_*","href":"/pt-BR/reference/settings/session-settings/compatibility"},{"title":"compatibility_ignore_*: configurações de sessão","sidebarTitle":"compatibility_ignore_*","href":"/pt-BR/reference/settings/session-settings/compatibility-ignore"},{"title":"configurações de sessão compile_*","sidebarTitle":"compile_*","href":"/pt-BR/reference/settings/session-settings/compile"},{"title":"configurações de sessão connect_timeout_*","sidebarTitle":"connect_timeout_*","href":"/pt-BR/reference/settings/session-settings/connect-timeout"},{"title":"correlated_subqueries_* configurações de sessão","sidebarTitle":"correlated_subqueries_*","href":"/pt-BR/reference/settings/session-settings/correlated-subqueries"},{"title":"configurações de sessão de count_distinct_*","sidebarTitle":"count_distinct_*","href":"/pt-BR/reference/settings/session-settings/count-distinct"},{"title":"configurações de sessão create_*","sidebarTitle":"create_*","href":"/pt-BR/reference/settings/session-settings/create"},{"title":"configurações de sessão cross_join_*","sidebarTitle":"cross_join_*","href":"/pt-BR/reference/settings/session-settings/cross-join"},{"title":"configurações de sessão database_*","sidebarTitle":"database_*","href":"/pt-BR/reference/settings/session-settings/database"},{"title":"configurações de sessão de database_replicated_*","sidebarTitle":"database_replicated_*","href":"/pt-BR/reference/settings/session-settings/database-replicated"},{"title":"configurações de sessão dead_blobs_*","sidebarTitle":"dead_blobs_*","href":"/pt-BR/reference/settings/session-settings/dead-blobs"},{"title":"configurações de sessão deduplicate_insert_*","sidebarTitle":"deduplicate_insert_*","href":"/pt-BR/reference/settings/session-settings/deduplicate-insert"},{"title":"configurações de sessão default_*","sidebarTitle":"default_*","href":"/pt-BR/reference/settings/session-settings/default"},{"title":"configurações de sessão delta_lake_*","sidebarTitle":"delta_lake_*","href":"/pt-BR/reference/settings/session-settings/delta-lake"},{"title":"configurações de sessão de describe_include_*","sidebarTitle":"describe_include_*","href":"/pt-BR/reference/settings/session-settings/describe-include"},{"title":"configurações de sessão de dictionary_*","sidebarTitle":"dictionary_*","href":"/pt-BR/reference/settings/session-settings/dictionary"},{"title":"configurações de sessão distributed_*","sidebarTitle":"distributed_*","href":"/pt-BR/reference/settings/session-settings/distributed"},{"title":"configurações de sessão distributed_background_*","sidebarTitle":"distributed_background_*","href":"/pt-BR/reference/settings/session-settings/distributed-background"},{"title":"configurações de sessão distributed_cache_*","sidebarTitle":"distributed_cache_*","href":"/pt-BR/reference/settings/session-settings/distributed-cache"},{"title":"configurações de sessão de distributed_ddl_*","sidebarTitle":"distributed_ddl_*","href":"/pt-BR/reference/settings/session-settings/distributed-ddl"},{"title":"configurações de sessão de distributed_index_analysis_*","sidebarTitle":"distributed_index_analysis_*","href":"/pt-BR/reference/settings/session-settings/distributed-index-analysis"},{"title":"configurações de sessão distributed_plan_*","sidebarTitle":"distributed_plan_*","href":"/pt-BR/reference/settings/session-settings/distributed-plan"},{"title":"configurações de sessão distributed_replica_*","sidebarTitle":"distributed_replica_*","href":"/pt-BR/reference/settings/session-settings/distributed-replica"},{"title":"configurações de sessão de dynamic_disk_*","sidebarTitle":"dynamic_disk_*","href":"/pt-BR/reference/settings/session-settings/dynamic-disk"},{"title":"configurações de sessão empty_result_*","sidebarTitle":"empty_result_*","href":"/pt-BR/reference/settings/session-settings/empty-result"},{"title":"configurações de sessão enable_*","sidebarTitle":"enable_*","href":"/pt-BR/reference/settings/session-settings/enable"},{"title":"configurações de sessão enable_blob_storage_log_*","sidebarTitle":"enable_blob_storage_log_*","href":"/pt-BR/reference/settings/session-settings/enable-blob-storage-log"},{"title":"configurações de sessão enable_filesystem_*","sidebarTitle":"enable_filesystem_*","href":"/pt-BR/reference/settings/session-settings/enable-filesystem"},{"title":"configurações de sessão enable_join_*","sidebarTitle":"enable_join_*","href":"/pt-BR/reference/settings/session-settings/enable-join"},{"title":"configurações de sessão enable_lightweight_*","sidebarTitle":"enable_lightweight_*","href":"/pt-BR/reference/settings/session-settings/enable-lightweight"},{"title":"configurações de sessão enable_optimize_predicate_expression_*","sidebarTitle":"enable_optimize_predicate_expression_*","href":"/pt-BR/reference/settings/session-settings/enable-optimize-predicate-expression"},{"title":"configurações de sessão enable_parallel_*","sidebarTitle":"enable_parallel_*","href":"/pt-BR/reference/settings/session-settings/enable-parallel"},{"title":"configurações de sessão enable_positional_arguments_*","sidebarTitle":"enable_positional_arguments_*","href":"/pt-BR/reference/settings/session-settings/enable-positional-arguments"},{"title":"configurações de sessão enable_software_*","sidebarTitle":"enable_software_*","href":"/pt-BR/reference/settings/session-settings/enable-software"},{"title":"configurações de sessão de engine_file_*","sidebarTitle":"engine_file_*","href":"/pt-BR/reference/settings/session-settings/engine-file"},{"title":"configurações de sessão de external_storage_*","sidebarTitle":"external_storage_*","href":"/pt-BR/reference/settings/session-settings/external-storage"},{"title":"configurações de sessão de external_table_*","sidebarTitle":"external_table_*","href":"/pt-BR/reference/settings/session-settings/external-table"},{"title":"configurações de sessão de filesystem_cache_*","sidebarTitle":"filesystem_cache_*","href":"/pt-BR/reference/settings/session-settings/filesystem-cache"},{"title":"configurações de sessão de filesystem_prefetch_*","sidebarTitle":"filesystem_prefetch_*","href":"/pt-BR/reference/settings/session-settings/filesystem-prefetch"},{"title":"configurações de sessão force_*","sidebarTitle":"force_*","href":"/pt-BR/reference/settings/session-settings/force"},{"title":"configurações de sessão force_optimize_*","sidebarTitle":"force_optimize_*","href":"/pt-BR/reference/settings/session-settings/force-optimize"},{"title":"configurações de sessão formatdatetime_*","sidebarTitle":"formatdatetime_*","href":"/pt-BR/reference/settings/session-settings/formatdatetime"},{"title":"formatdatetime_f_* configurações de sessão","sidebarTitle":"formatdatetime_f_*","href":"/pt-BR/reference/settings/session-settings/formatdatetime-f"},{"title":"configurações de sessão de function_*","sidebarTitle":"function_*","href":"/pt-BR/reference/settings/session-settings/function"},{"title":"configurações de sessão de function_json_*","sidebarTitle":"function_json_*","href":"/pt-BR/reference/settings/session-settings/function-json"},{"title":"configurações de sessão grace_hash_*","sidebarTitle":"grace_hash_*","href":"/pt-BR/reference/settings/session-settings/grace-hash"},{"title":"configurações de sessão de group_by_*","sidebarTitle":"group_by_*","href":"/pt-BR/reference/settings/session-settings/group-by"},{"title":"configurações de sessão hdfs_*","sidebarTitle":"hdfs_*","href":"/pt-BR/reference/settings/session-settings/hdfs"},{"title":"configurações de sessão http_*","sidebarTitle":"http_*","href":"/pt-BR/reference/settings/session-settings/http"},{"title":"configurações de sessão http_headers_*","sidebarTitle":"http_headers_*","href":"/pt-BR/reference/settings/session-settings/http-headers"},{"title":"configurações de sessão http_max_*","sidebarTitle":"http_max_*","href":"/pt-BR/reference/settings/session-settings/http-max"},{"title":"configurações de sessão de http_response_*","sidebarTitle":"http_response_*","href":"/pt-BR/reference/settings/session-settings/http-response"},{"title":"configurações de sessão http_retry_*","sidebarTitle":"http_retry_*","href":"/pt-BR/reference/settings/session-settings/http-retry"},{"title":"configurações de sessão iceberg_*","sidebarTitle":"iceberg_*","href":"/pt-BR/reference/settings/session-settings/iceberg"},{"title":"iceberg_compaction_* configurações de sessão","sidebarTitle":"iceberg_compaction_*","href":"/pt-BR/reference/settings/session-settings/iceberg-compaction"},{"title":"configurações de sessão iceberg_data_*","sidebarTitle":"iceberg_data_*","href":"/pt-BR/reference/settings/session-settings/iceberg-data"},{"title":"configurações de sessão iceberg_expire_*","sidebarTitle":"iceberg_expire_*","href":"/pt-BR/reference/settings/session-settings/iceberg-expire"},{"title":"configurações de sessão iceberg_insert_*","sidebarTitle":"iceberg_insert_*","href":"/pt-BR/reference/settings/session-settings/iceberg-insert"},{"title":"configurações de sessão iceberg_metadata_*","sidebarTitle":"iceberg_metadata_*","href":"/pt-BR/reference/settings/session-settings/iceberg-metadata"},{"title":"configurações de sessão ignore_*","sidebarTitle":"ignore_*","href":"/pt-BR/reference/settings/session-settings/ignore"},{"title":"configurações de sessão ignore_on_*","sidebarTitle":"ignore_on_*","href":"/pt-BR/reference/settings/session-settings/ignore-on"},{"title":"configurações de sessão implicit_*","sidebarTitle":"implicit_*","href":"/pt-BR/reference/settings/session-settings/implicit"},{"title":"configurações de sessão insert_*","sidebarTitle":"insert_*","href":"/pt-BR/reference/settings/session-settings/insert"},{"title":"configurações de sessão insert_keeper_*","sidebarTitle":"insert_keeper_*","href":"/pt-BR/reference/settings/session-settings/insert-keeper"},{"title":"configurações de sessão de insert_quorum_*","sidebarTitle":"insert_quorum_*","href":"/pt-BR/reference/settings/session-settings/insert-quorum"},{"title":"configurações de sessão jemalloc_*","sidebarTitle":"jemalloc_*","href":"/pt-BR/reference/settings/session-settings/jemalloc"},{"title":"configurações de sessão jemalloc_profile_*","sidebarTitle":"jemalloc_profile_*","href":"/pt-BR/reference/settings/session-settings/jemalloc-profile"},{"title":"configurações de sessão join_*","sidebarTitle":"join_*","href":"/pt-BR/reference/settings/session-settings/join"},{"title":"configurações de sessão join_runtime_*","sidebarTitle":"join_runtime_*","href":"/pt-BR/reference/settings/session-settings/join-runtime"},{"title":"configurações de sessão join_to_*","sidebarTitle":"join_to_*","href":"/pt-BR/reference/settings/session-settings/join-to"},{"title":"configurações de sessão joined_*","sidebarTitle":"joined_*","href":"/pt-BR/reference/settings/session-settings/joined"},{"title":"configurações de sessão de kafka_*","sidebarTitle":"kafka_*","href":"/pt-BR/reference/settings/session-settings/kafka"},{"title":"configurações de sessão keeper_*","sidebarTitle":"keeper_*","href":"/pt-BR/reference/settings/session-settings/keeper"},{"title":"configurações de sessão keeper_retry_*","sidebarTitle":"keeper_retry_*","href":"/pt-BR/reference/settings/session-settings/keeper-retry"},{"title":"configurações de sessão lightweight_*","sidebarTitle":"lightweight_*","href":"/pt-BR/reference/settings/session-settings/lightweight"},{"title":"configurações de sessão de load_balancing_*","sidebarTitle":"load_balancing_*","href":"/pt-BR/reference/settings/session-settings/load-balancing"},{"title":"configurações de sessão local_filesystem_*","sidebarTitle":"local_filesystem_*","href":"/pt-BR/reference/settings/session-settings/local-filesystem"},{"title":"configurações de sessão log_*","sidebarTitle":"log_*","href":"/pt-BR/reference/settings/session-settings/log"},{"title":"configurações de sessão de log_queries_*","sidebarTitle":"log_queries_*","href":"/pt-BR/reference/settings/session-settings/log-queries"},{"title":"configurações de sessão de log_query_*","sidebarTitle":"log_query_*","href":"/pt-BR/reference/settings/session-settings/log-query"},{"title":"Configurações de sessão logsql_*","sidebarTitle":"logsql_*","href":"/pt-BR/reference/settings/session-settings/logsql"},{"title":"configurações de sessão de low_cardinality_*","sidebarTitle":"low_cardinality_*","href":"/pt-BR/reference/settings/session-settings/low-cardinality"},{"title":"configurações de sessão materialize_*","sidebarTitle":"materialize_*","href":"/pt-BR/reference/settings/session-settings/materialize"},{"title":"Configurações de sessão de materialize_statistics_on_insert_*","sidebarTitle":"materialize_statistics_on_insert_*","href":"/pt-BR/reference/settings/session-settings/materialize-statistics-on-insert"},{"title":"configurações de sessão de materialized_views_*","sidebarTitle":"materialized_views_*","href":"/pt-BR/reference/settings/session-settings/materialized-views"},{"title":"configurações de sessão max_*","sidebarTitle":"max_*","href":"/pt-BR/reference/settings/session-settings/max"},{"title":"configurações de sessão max_ast_*","sidebarTitle":"max_ast_*","href":"/pt-BR/reference/settings/session-settings/max-ast"},{"title":"configurações de sessão max_bytes_*","sidebarTitle":"max_bytes_*","href":"/pt-BR/reference/settings/session-settings/max-bytes"},{"title":"configurações de sessão max_concurrent_*","sidebarTitle":"max_concurrent_*","href":"/pt-BR/reference/settings/session-settings/max-concurrent"},{"title":"Configurações de sessão max_distributed_*","sidebarTitle":"max_distributed_*","href":"/pt-BR/reference/settings/session-settings/max-distributed"},{"title":"configurações de sessão max_download_*","sidebarTitle":"max_download_*","href":"/pt-BR/reference/settings/session-settings/max-download"},{"title":"configurações de sessão max_execution_*","sidebarTitle":"max_execution_*","href":"/pt-BR/reference/settings/session-settings/max-execution"},{"title":"configurações de sessão max_hyperscan_*","sidebarTitle":"max_hyperscan_*","href":"/pt-BR/reference/settings/session-settings/max-hyperscan"},{"title":"configurações de sessão max_insert_*","sidebarTitle":"max_insert_*","href":"/pt-BR/reference/settings/session-settings/max-insert"},{"title":"configurações de sessão max_joined_*","sidebarTitle":"max_joined_*","href":"/pt-BR/reference/settings/session-settings/max-joined"},{"title":"configurações de sessão max_local_*","sidebarTitle":"max_local_*","href":"/pt-BR/reference/settings/session-settings/max-local"},{"title":"configurações de sessão max_memory_usage_*","sidebarTitle":"max_memory_usage_*","href":"/pt-BR/reference/settings/session-settings/max-memory-usage"},{"title":"configurações de sessão max_network_*","sidebarTitle":"max_network_*","href":"/pt-BR/reference/settings/session-settings/max-network"},{"title":"configurações de sessão max_number_*","sidebarTitle":"max_number_*","href":"/pt-BR/reference/settings/session-settings/max-number"},{"title":"configurações de sessão max_parser_*","sidebarTitle":"max_parser_*","href":"/pt-BR/reference/settings/session-settings/max-parser"},{"title":"configurações de sessão max_partitions_*","sidebarTitle":"max_partitions_*","href":"/pt-BR/reference/settings/session-settings/max-partitions"},{"title":"configurações de sessão max_rand_*","sidebarTitle":"max_rand_*","href":"/pt-BR/reference/settings/session-settings/max-rand"},{"title":"configurações de sessão de max_read_buffer_size_*","sidebarTitle":"max_read_buffer_size_*","href":"/pt-BR/reference/settings/session-settings/max-read-buffer-size"},{"title":"configurações de sessão max_remote_*","sidebarTitle":"max_remote_*","href":"/pt-BR/reference/settings/session-settings/max-remote"},{"title":"configurações de sessão max_result_*","sidebarTitle":"max_result_*","href":"/pt-BR/reference/settings/session-settings/max-result"},{"title":"configurações de sessão max_rows_*","sidebarTitle":"max_rows_*","href":"/pt-BR/reference/settings/session-settings/max-rows"},{"title":"configurações de sessão max_size_*","sidebarTitle":"max_size_*","href":"/pt-BR/reference/settings/session-settings/max-size"},{"title":"configurações de sessão max_skip_*","sidebarTitle":"max_skip_*","href":"/pt-BR/reference/settings/session-settings/max-skip"},{"title":"configurações de sessão max_streams_*","sidebarTitle":"max_streams_*","href":"/pt-BR/reference/settings/session-settings/max-streams"},{"title":"configurações de sessão max_temporary_*","sidebarTitle":"max_temporary_*","href":"/pt-BR/reference/settings/session-settings/max-temporary"},{"title":"configurações de sessão max_threads_*","sidebarTitle":"max_threads_*","href":"/pt-BR/reference/settings/session-settings/max-threads"},{"title":"configurações de sessão memory_*","sidebarTitle":"memory_*","href":"/pt-BR/reference/settings/session-settings/memory"},{"title":"configurações de sessão memory_overcommit_ratio_denominator_*","sidebarTitle":"memory_overcommit_ratio_denominator_*","href":"/pt-BR/reference/settings/session-settings/memory-overcommit-ratio-denominator"},{"title":"configurações de sessão memory_profiler_*","sidebarTitle":"memory_profiler_*","href":"/pt-BR/reference/settings/session-settings/memory-profiler"},{"title":"configurações de sessão merge_tree_*","sidebarTitle":"merge_tree_*","href":"/pt-BR/reference/settings/session-settings/merge-tree"},{"title":"configurações de sessão metrics_perf_*","sidebarTitle":"metrics_perf_*","href":"/pt-BR/reference/settings/session-settings/metrics-perf"},{"title":"configurações de sessão min_*","sidebarTitle":"min_*","href":"/pt-BR/reference/settings/session-settings/min"},{"title":"configurações de sessão min_bytes_*","sidebarTitle":"min_bytes_*","href":"/pt-BR/reference/settings/session-settings/min-bytes"},{"title":"configurações de sessão min_count_*","sidebarTitle":"min_count_*","href":"/pt-BR/reference/settings/session-settings/min-count"},{"title":"Configurações de sessão min_execution_speed_*","sidebarTitle":"min_execution_speed_*","href":"/pt-BR/reference/settings/session-settings/min-execution-speed"},{"title":"configurações de sessão min_external_*","sidebarTitle":"min_external_*","href":"/pt-BR/reference/settings/session-settings/min-external"},{"title":"configurações de sessão min_free_*","sidebarTitle":"min_free_*","href":"/pt-BR/reference/settings/session-settings/min-free"},{"title":"configurações de sessão min_insert_*","sidebarTitle":"min_insert_*","href":"/pt-BR/reference/settings/session-settings/min-insert"},{"title":"configurações de sessão min_joined_*","sidebarTitle":"min_joined_*","href":"/pt-BR/reference/settings/session-settings/min-joined"},{"title":"configurações de sessão move_*","sidebarTitle":"move_*","href":"/pt-BR/reference/settings/session-settings/move"},{"title":"mutações_* configurações de sessão","sidebarTitle":"mutações_*","href":"/pt-BR/reference/settings/session-settings/mutations"},{"title":"configurações de sessão mutations_execute_*","sidebarTitle":"mutations_execute_*","href":"/pt-BR/reference/settings/session-settings/mutations-execute"},{"title":"configurações de sessão mysql_*","sidebarTitle":"mysql_*","href":"/pt-BR/reference/settings/session-settings/mysql"},{"title":"configurações de sessão mysql_map_*","sidebarTitle":"mysql_map_*","href":"/pt-BR/reference/settings/session-settings/mysql-map"},{"title":"configurações de sessão network_*","sidebarTitle":"network_*","href":"/pt-BR/reference/settings/session-settings/network"},{"title":"configurações de sessão number_of_*","sidebarTitle":"number_of_*","href":"/pt-BR/reference/settings/session-settings/number-of"},{"title":"configurações de sessão do odbc_bridge_*","sidebarTitle":"odbc_bridge_*","href":"/pt-BR/reference/settings/session-settings/odbc-bridge"},{"title":"configurações de sessão opentelemetry_start_*","sidebarTitle":"opentelemetry_start_*","href":"/pt-BR/reference/settings/session-settings/opentelemetry-start"},{"title":"configurações de sessão opentelemetry_trace_*","sidebarTitle":"opentelemetry_trace_*","href":"/pt-BR/reference/settings/session-settings/opentelemetry-trace"},{"title":"configurações de sessão optimize_*","sidebarTitle":"optimize_*","href":"/pt-BR/reference/settings/session-settings/optimize"},{"title":"configurações de sessão de optimize_aggregation_in_order_*","sidebarTitle":"optimize_aggregation_in_order_*","href":"/pt-BR/reference/settings/session-settings/optimize-aggregation-in-order"},{"title":"configurações de sessão de optimize_and_compare_chain_*","sidebarTitle":"optimize_and_compare_chain_*","href":"/pt-BR/reference/settings/session-settings/optimize-and-compare-chain"},{"title":"configurações de sessão optimize_group_*","sidebarTitle":"optimize_group_*","href":"/pt-BR/reference/settings/session-settings/optimize-group"},{"title":"configurações de sessão optimize_if_*","sidebarTitle":"optimize_if_*","href":"/pt-BR/reference/settings/session-settings/optimize-if"},{"title":"configurações de sessão de optimize_injective_*","sidebarTitle":"optimize_injective_*","href":"/pt-BR/reference/settings/session-settings/optimize-injective"},{"title":"configurações de sessão optimize_limit_*","sidebarTitle":"optimize_limit_*","href":"/pt-BR/reference/settings/session-settings/optimize-limit"},{"title":"configurações de sessão optimize_min_*","sidebarTitle":"optimize_min_*","href":"/pt-BR/reference/settings/session-settings/optimize-min"},{"title":"configurações de sessão optimize_move_to_prewhere_*","sidebarTitle":"optimize_move_to_prewhere_*","href":"/pt-BR/reference/settings/session-settings/optimize-move-to-prewhere"},{"title":"configurações de sessão de optimize_or_like_chain_*","sidebarTitle":"optimize_or_like_chain_*","href":"/pt-BR/reference/settings/session-settings/optimize-or-like-chain"},{"title":"configurações de sessão optimize_redundant_*","sidebarTitle":"optimize_redundant_*","href":"/pt-BR/reference/settings/session-settings/optimize-redundant"},{"title":"configurações de sessão optimize_rewrite_*","sidebarTitle":"optimize_rewrite_*","href":"/pt-BR/reference/settings/session-settings/optimize-rewrite"},{"title":"configurações de sessão optimize_skip_*","sidebarTitle":"optimize_skip_*","href":"/pt-BR/reference/settings/session-settings/optimize-skip"},{"title":"configurações de sessão optimize_trivial_*","sidebarTitle":"optimize_trivial_*","href":"/pt-BR/reference/settings/session-settings/optimize-trivial"},{"title":"configurações de sessão optimize_use_*","sidebarTitle":"optimize_use_*","href":"/pt-BR/reference/settings/session-settings/optimize-use"},{"title":"configurações de sessão de os_threads_*","sidebarTitle":"os_threads_*","href":"/pt-BR/reference/settings/session-settings/os-threads"},{"title":"configurações de sessão de page_cache_*","sidebarTitle":"page_cache_*","href":"/pt-BR/reference/settings/session-settings/page-cache"},{"title":"configurações de sessão parallel_*","sidebarTitle":"parallel_*","href":"/pt-BR/reference/settings/session-settings/parallel"},{"title":"configurações de sessão parallel_replicas_*","sidebarTitle":"parallel_replicas_*","href":"/pt-BR/reference/settings/session-settings/parallel-replicas"},{"title":"parsedatetime_* configurações de sessão","sidebarTitle":"parsedatetime_*","href":"/pt-BR/reference/settings/session-settings/parsedatetime"},{"title":"configurações de sessão partial_merge_*","sidebarTitle":"partial_merge_*","href":"/pt-BR/reference/settings/session-settings/partial-merge"},{"title":"configurações de sessão parts_to_*","sidebarTitle":"parts_to_*","href":"/pt-BR/reference/settings/session-settings/parts-to"},{"title":"configurações de sessão de postgresql_connection_*","sidebarTitle":"postgresql_connection_*","href":"/pt-BR/reference/settings/session-settings/postgresql-connection"},{"title":"configurações de sessão prefer_*","sidebarTitle":"prefer_*","href":"/pt-BR/reference/settings/session-settings/prefer"},{"title":"configurações de sessão preferred_*","sidebarTitle":"preferred_*","href":"/pt-BR/reference/settings/session-settings/preferred"},{"title":"configurações de sessão de promql_*","sidebarTitle":"promql_*","href":"/pt-BR/reference/settings/session-settings/promql"},{"title":"configurações de sessão de query_cache_*","sidebarTitle":"query_cache_*","href":"/pt-BR/reference/settings/session-settings/query-cache"},{"title":"configurações de sessão query_plan_*","sidebarTitle":"query_plan_*","href":"/pt-BR/reference/settings/session-settings/query-plan"},{"title":"configurações de sessão query_profiler_*","sidebarTitle":"query_profiler_*","href":"/pt-BR/reference/settings/session-settings/query-profiler"},{"title":"configurações de sessão read_*","sidebarTitle":"read_*","href":"/pt-BR/reference/settings/session-settings/read"},{"title":"configurações de sessão read_backoff_*","sidebarTitle":"read_backoff_*","href":"/pt-BR/reference/settings/session-settings/read-backoff"},{"title":"configurações de sessão read_from_*","sidebarTitle":"read_from_*","href":"/pt-BR/reference/settings/session-settings/read-from"},{"title":"configurações de sessão read_in_*","sidebarTitle":"read_in_*","href":"/pt-BR/reference/settings/session-settings/read-in"},{"title":"configurações de sessão read_overflow_mode_*","sidebarTitle":"read_overflow_mode_*","href":"/pt-BR/reference/settings/session-settings/read-overflow-mode"},{"title":"configurações de sessão do reader_executor_*","sidebarTitle":"reader_executor_*","href":"/pt-BR/reference/settings/session-settings/reader-executor"},{"title":"configurações de sessão receive_*","sidebarTitle":"receive_*","href":"/pt-BR/reference/settings/session-settings/receive"},{"title":"configurações de sessão regexp_dict_*","sidebarTitle":"regexp_dict_*","href":"/pt-BR/reference/settings/session-settings/regexp-dict"},{"title":"configurações de sessão de remote_filesystem_*","sidebarTitle":"remote_filesystem_*","href":"/pt-BR/reference/settings/session-settings/remote-filesystem"},{"title":"configurações de sessão remote_fs_*","sidebarTitle":"remote_fs_*","href":"/pt-BR/reference/settings/session-settings/remote-fs"},{"title":"configurações de sessão de replace_running_query_*","sidebarTitle":"replace_running_query_*","href":"/pt-BR/reference/settings/session-settings/replace-running-query"},{"title":"configurações de sessão restore_replace_*","sidebarTitle":"restore_replace_*","href":"/pt-BR/reference/settings/session-settings/restore-replace"},{"title":"configurações de sessão rewrite_*","sidebarTitle":"rewrite_*","href":"/pt-BR/reference/settings/session-settings/rewrite"},{"title":"configurações de sessão s3_*","sidebarTitle":"s3_*","href":"/pt-BR/reference/settings/session-settings/s3"},{"title":"configurações de sessão s3_allow_*","sidebarTitle":"s3_allow_*","href":"/pt-BR/reference/settings/session-settings/s3-allow"},{"title":"configurações de sessão s3_max_*","sidebarTitle":"s3_max_*","href":"/pt-BR/reference/settings/session-settings/s3-max"},{"title":"configurações de sessão s3_upload_*","sidebarTitle":"s3_upload_*","href":"/pt-BR/reference/settings/session-settings/s3-upload"},{"title":"configurações de sessão s3_validate_*","sidebarTitle":"s3_validate_*","href":"/pt-BR/reference/settings/session-settings/s3-validate"},{"title":"configurações de sessão de s3queue_*","sidebarTitle":"s3queue_*","href":"/pt-BR/reference/settings/session-settings/s3queue"},{"title":"configurações de sessão de schema_inference_*","sidebarTitle":"schema_inference_*","href":"/pt-BR/reference/settings/session-settings/schema-inference"},{"title":"Configurações de sessão send_*","sidebarTitle":"send_*","href":"/pt-BR/reference/settings/session-settings/send"},{"title":"send_logs_*: configurações de sessão","sidebarTitle":"send_logs_*","href":"/pt-BR/reference/settings/session-settings/send-logs"},{"title":"configurações de sessão serialize_*","sidebarTitle":"serialize_*","href":"/pt-BR/reference/settings/session-settings/serialize"},{"title":"configurações de sessão shared_merge_*","sidebarTitle":"shared_merge_*","href":"/pt-BR/reference/settings/session-settings/shared-merge"},{"title":"configurações de sessão short_circuit_function_evaluation_*","sidebarTitle":"short_circuit_function_evaluation_*","href":"/pt-BR/reference/settings/session-settings/short-circuit-function-evaluation"},{"title":"configurações de sessão show_*","sidebarTitle":"show_*","href":"/pt-BR/reference/settings/session-settings/show"},{"title":"configurações de sessão shrink_over_*","sidebarTitle":"shrink_over_*","href":"/pt-BR/reference/settings/session-settings/shrink-over"},{"title":"configurações de sessão skip_unavailable_shards_*","sidebarTitle":"skip_unavailable_shards_*","href":"/pt-BR/reference/settings/session-settings/skip-unavailable-shards"},{"title":"configurações de sessão sleep_in_*","sidebarTitle":"sleep_in_*","href":"/pt-BR/reference/settings/session-settings/sleep-in"},{"title":"configurações de sessão split_*","sidebarTitle":"split_*","href":"/pt-BR/reference/settings/session-settings/split"},{"title":"configurações de sessão storage_*","sidebarTitle":"storage_*","href":"/pt-BR/reference/settings/session-settings/storage"},{"title":"configurações de sessão stream_*","sidebarTitle":"stream_*","href":"/pt-BR/reference/settings/session-settings/stream"},{"title":"configurações de sessão stream_like_*","sidebarTitle":"stream_like_*","href":"/pt-BR/reference/settings/session-settings/stream-like"},{"title":"configurações de sessão de system_*","sidebarTitle":"system_*","href":"/pt-BR/reference/settings/session-settings/system"},{"title":"configurações de sessão de table_*","sidebarTitle":"table_*","href":"/pt-BR/reference/settings/session-settings/table"},{"title":"configurações de sessão temporary_files_*","sidebarTitle":"temporary_files_*","href":"/pt-BR/reference/settings/session-settings/temporary-files"},{"title":"configurações de sessão de text_index_*","sidebarTitle":"text_index_*","href":"/pt-BR/reference/settings/session-settings/text-index"},{"title":"configurações de sessão throw_on_*","sidebarTitle":"throw_on_*","href":"/pt-BR/reference/settings/session-settings/throw-on"},{"title":"configurações de sessão timeout_overflow_mode_*","sidebarTitle":"timeout_overflow_mode_*","href":"/pt-BR/reference/settings/session-settings/timeout-overflow-mode"},{"title":"configurações de sessão totals_*","sidebarTitle":"totals_*","href":"/pt-BR/reference/settings/session-settings/totals"},{"title":"configurações de sessão trace_profile_events_*","sidebarTitle":"trace_profile_events_*","href":"/pt-BR/reference/settings/session-settings/trace-profile-events"},{"title":"Configurações de sessão de unique_key_*","sidebarTitle":"unique_key_*","href":"/pt-BR/reference/settings/session-settings/unique-key"},{"title":"configurações de sessão update_*","sidebarTitle":"update_*","href":"/pt-BR/reference/settings/session-settings/update"},{"title":"configurações de sessão url_*","sidebarTitle":"url_*","href":"/pt-BR/reference/settings/session-settings/url"},{"title":"configurações de sessão use_*","sidebarTitle":"use_*","href":"/pt-BR/reference/settings/session-settings/use"},{"title":"configurações de sessão use_iceberg_*","sidebarTitle":"use_iceberg_*","href":"/pt-BR/reference/settings/session-settings/use-iceberg"},{"title":"configurações de sessão use_index_for_in_with_subqueries_*","sidebarTitle":"use_index_for_in_with_subqueries_*","href":"/pt-BR/reference/settings/session-settings/use-index-for-in-with-subqueries"},{"title":"configurações de sessão use_page_*","sidebarTitle":"use_page_*","href":"/pt-BR/reference/settings/session-settings/use-page"},{"title":"configurações de sessão use_paimon_*","sidebarTitle":"use_paimon_*","href":"/pt-BR/reference/settings/session-settings/use-paimon"},{"title":"configurações de sessão use_partition_*","sidebarTitle":"use_partition_*","href":"/pt-BR/reference/settings/session-settings/use-partition"},{"title":"configurações de sessão use_query_*","sidebarTitle":"use_query_*","href":"/pt-BR/reference/settings/session-settings/use-query"},{"title":"configurações de sessão use_skip_indexes_*","sidebarTitle":"use_skip_indexes_*","href":"/pt-BR/reference/settings/session-settings/use-skip-indexes"},{"title":"configurações de sessão use_statistics_*","sidebarTitle":"use_statistics_*","href":"/pt-BR/reference/settings/session-settings/use-statistics"},{"title":"configurações de sessão use_text_*","sidebarTitle":"use_text_*","href":"/pt-BR/reference/settings/session-settings/use-text"},{"title":"configurações de sessão use_top_k_dynamic_filtering_*","sidebarTitle":"use_top_k_dynamic_filtering_*","href":"/pt-BR/reference/settings/session-settings/use-top-k-dynamic-filtering"},{"title":"Configurações de sessão use_variant_*","sidebarTitle":"use_variant_*","href":"/pt-BR/reference/settings/session-settings/use-variant"},{"title":"configurações de sessão validate_*","sidebarTitle":"validate_*","href":"/pt-BR/reference/settings/session-settings/validate"},{"title":"configurações de sessão vector_search_*","sidebarTitle":"vector_search_*","href":"/pt-BR/reference/settings/session-settings/vector-search"},{"title":"Configurações de sessão wait_for_*","sidebarTitle":"wait_for_*","href":"/pt-BR/reference/settings/session-settings/wait-for"},{"title":"configurações de sessão de webassembly_udf_*","sidebarTitle":"webassembly_udf_*","href":"/pt-BR/reference/settings/session-settings/webassembly-udf"},{"title":"Configurações de sessão weight_lowering_*","sidebarTitle":"weight_lowering_*","href":"/pt-BR/reference/settings/session-settings/weight-lowering"},{"title":"configurações de sessão write_through_distributed_cache_*","sidebarTitle":"write_through_distributed_cache_*","href":"/pt-BR/reference/settings/session-settings/write-through-distributed-cache"},{"title":"Outras configurações de sessão","sidebarTitle":"Outras","href":"/pt-BR/reference/settings/session-settings/other"}]},{"group":"Configurações de tabelas MergeTree","root":{"title":"Configurações das tabelas MergeTree","sidebarTitle":"Visão geral","href":"/pt-BR/reference/settings/merge-tree-settings"},"directory":"none","pages":[{"title":"configurações de tabela MergeTree add_minmax_*","sidebarTitle":"add_minmax_*","href":"/pt-BR/reference/settings/merge-tree-settings/add-minmax"},{"title":"configurações de tabela do MergeTree allow_*","sidebarTitle":"allow_*","href":"/pt-BR/reference/settings/merge-tree-settings/allow"},{"title":"configurações de tabela do MergeTree allow_experimental_*","sidebarTitle":"allow_experimental_*","href":"/pt-BR/reference/settings/merge-tree-settings/allow-experimental"},{"title":"Configurações always_fetch_* de tabelas MergeTree","sidebarTitle":"always_fetch_*","href":"/pt-BR/reference/settings/merge-tree-settings/always-fetch"},{"title":"configurações de tabela do MergeTree async_*","sidebarTitle":"async_*","href":"/pt-BR/reference/settings/merge-tree-settings/async"},{"title":"cache_populated_by_fetch_* configurações de tabela do MergeTree","sidebarTitle":"cache_populated_by_fetch_*","href":"/pt-BR/reference/settings/merge-tree-settings/cache-populated-by-fetch"},{"title":"configurações de tabela MergeTree check_*","sidebarTitle":"check_*","href":"/pt-BR/reference/settings/merge-tree-settings/check"},{"title":"configurações de tabela MergeTree cleanup_*","sidebarTitle":"cleanup_*","href":"/pt-BR/reference/settings/merge-tree-settings/cleanup"},{"title":"configurações de tabela MergeTree cleanup_delay_period_*","sidebarTitle":"cleanup_delay_period_*","href":"/pt-BR/reference/settings/merge-tree-settings/cleanup-delay-period"},{"title":"configurações de tabela columns_* do MergeTree","sidebarTitle":"columns_*","href":"/pt-BR/reference/settings/merge-tree-settings/columns"},{"title":"configurações de tabela compact_parts_* do MergeTree","sidebarTitle":"compact_parts_*","href":"/pt-BR/reference/settings/merge-tree-settings/compact-parts"},{"title":"configurações de tabela do MergeTree compress_*","sidebarTitle":"compress_*","href":"/pt-BR/reference/settings/merge-tree-settings/compress"},{"title":"concurrent_part_removal_threshold_* configurações de tabela do MergeTree","sidebarTitle":"concurrent_part_removal_threshold_*","href":"/pt-BR/reference/settings/merge-tree-settings/concurrent-part-removal-threshold"},{"title":"configurações de tabela do MergeTree dead_blobs_*","sidebarTitle":"dead_blobs_*","href":"/pt-BR/reference/settings/merge-tree-settings/dead-blobs"},{"title":"configurações de tabela MergeTree detach_*","sidebarTitle":"detach_*","href":"/pt-BR/reference/settings/merge-tree-settings/detach"},{"title":"configurações disable_* de tabelas MergeTree","sidebarTitle":"disable_*","href":"/pt-BR/reference/settings/merge-tree-settings/disable"},{"title":"configurações de tabela MergeTree distributed_index_*","sidebarTitle":"distributed_index_*","href":"/pt-BR/reference/settings/merge-tree-settings/distributed-index"},{"title":"configurações de tabela enable_* do MergeTree","sidebarTitle":"enable_*","href":"/pt-BR/reference/settings/merge-tree-settings/enable"},{"title":"configurações de tabela do MergeTree enable_block_*","sidebarTitle":"enable_block_*","href":"/pt-BR/reference/settings/merge-tree-settings/enable-block"},{"title":"escape_* configurações de tabela do MergeTree","sidebarTitle":"escape_*","href":"/pt-BR/reference/settings/merge-tree-settings/escape"},{"title":"configurações de tabela exclude_* do MergeTree","sidebarTitle":"exclude_*","href":"/pt-BR/reference/settings/merge-tree-settings/exclude"},{"title":"configurações de tabela do MergeTree fault_probability_*","sidebarTitle":"fault_probability_*","href":"/pt-BR/reference/settings/merge-tree-settings/fault-probability"},{"title":"configurações de tabela MergeTree fsync_*","sidebarTitle":"fsync_*","href":"/pt-BR/reference/settings/merge-tree-settings/fsync"},{"title":"configurações de tabela do MergeTree in_memory_*","sidebarTitle":"in_memory_*","href":"/pt-BR/reference/settings/merge-tree-settings/in-memory"},{"title":"configurações de tabela do MergeTree inactive_parts_*","sidebarTitle":"inactive_parts_*","href":"/pt-BR/reference/settings/merge-tree-settings/inactive-parts"},{"title":"configurações de tabela do MergeTree index_granularity_*","sidebarTitle":"index_granularity_*","href":"/pt-BR/reference/settings/merge-tree-settings/index-granularity"},{"title":"configurações de tabela MergeTree de kill_delay_period_*","sidebarTitle":"kill_delay_period_*","href":"/pt-BR/reference/settings/merge-tree-settings/kill-delay-period"},{"title":"configurações de tabela do MergeTree map_buckets_*","sidebarTitle":"map_buckets_*","href":"/pt-BR/reference/settings/merge-tree-settings/map-buckets"},{"title":"configurações de tabela do MergeTree map_serialization_version_*","sidebarTitle":"map_serialization_version_*","href":"/pt-BR/reference/settings/merge-tree-settings/map-serialization-version"},{"title":"configurações de tabela do MergeTree marks_*","sidebarTitle":"marks_*","href":"/pt-BR/reference/settings/merge-tree-settings/marks"},{"title":"configurações de tabela materialize_* do MergeTree","sidebarTitle":"materialize_*","href":"/pt-BR/reference/settings/merge-tree-settings/materialize"},{"title":"materialize_projections_* configurações de tabela MergeTree","sidebarTitle":"materialize_projections_*","href":"/pt-BR/reference/settings/merge-tree-settings/materialize-projections"},{"title":"configurações de tabela do MergeTree max_*","sidebarTitle":"max_*","href":"/pt-BR/reference/settings/merge-tree-settings/max"},{"title":"configurações de tabela max_bytes_* do MergeTree","sidebarTitle":"max_bytes_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-bytes"},{"title":"configurações de tabela MergeTree max_delay_*","sidebarTitle":"max_delay_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-delay"},{"title":"configurações de tabela max_files_* do MergeTree","sidebarTitle":"max_files_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-files"},{"title":"Configurações de tabela MergeTree max_merge_*","sidebarTitle":"max_merge_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-merge"},{"title":"configurações de tabela do MergeTree max_number_*","sidebarTitle":"max_number_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-number"},{"title":"configurações de tabela do MergeTree max_part_*","sidebarTitle":"max_part_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-part"},{"title":"configurações de tabela do MergeTree max_parts_*","sidebarTitle":"max_parts_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-parts"},{"title":"configurações de tabela do MergeTree max_postpone_*","sidebarTitle":"max_postpone_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-postpone"},{"title":"configurações de tabela do MergeTree max_replicated_*","sidebarTitle":"max_replicated_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-replicated"},{"title":"configurações de tabela do MergeTree max_suspicious_broken_parts_*","sidebarTitle":"max_suspicious_broken_parts_*","href":"/pt-BR/reference/settings/merge-tree-settings/max-suspicious-broken-parts"},{"title":"configurações de tabela merge_* do MergeTree","sidebarTitle":"merge_*","href":"/pt-BR/reference/settings/merge-tree-settings/merge"},{"title":"configurações de tabela MergeTree merge_max_*","sidebarTitle":"merge_max_*","href":"/pt-BR/reference/settings/merge-tree-settings/merge-max"},{"title":"merge_selecting_* configurações de tabela do MergeTree","sidebarTitle":"merge_selecting_*","href":"/pt-BR/reference/settings/merge-tree-settings/merge-selecting"},{"title":"configurações de tabela MergeTree merge_selector_*","sidebarTitle":"merge_selector_*","href":"/pt-BR/reference/settings/merge-tree-settings/merge-selector"},{"title":"configurações da tabela MergeTree merge_tree_*","sidebarTitle":"merge_tree_*","href":"/pt-BR/reference/settings/merge-tree-settings/merge-tree"},{"title":"configurações de tabela merge_with_* do MergeTree","sidebarTitle":"merge_with_*","href":"/pt-BR/reference/settings/merge-tree-settings/merge-with"},{"title":"configurações de tabela do MergeTree min_*","sidebarTitle":"min_*","href":"/pt-BR/reference/settings/merge-tree-settings/min"},{"title":"configurações de tabela MergeTree min_age_*","sidebarTitle":"min_age_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-age"},{"title":"configurações de tabela do MergeTree min_bytes_*","sidebarTitle":"min_bytes_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-bytes"},{"title":"configurações de tabela MergeTree min_compressed_*","sidebarTitle":"min_compressed_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-compressed"},{"title":"configurações de tabela do MergeTree min_delay_*","sidebarTitle":"min_delay_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-delay"},{"title":"configurações de tabela MergeTree min_free_*","sidebarTitle":"min_free_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-free"},{"title":"configurações de tabela MergeTree min_level_*","sidebarTitle":"min_level_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-level"},{"title":"configurações de tabela do MergeTree min_relative_*","sidebarTitle":"min_relative_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-relative"},{"title":"configurações de tabela MergeTree min_rows_*","sidebarTitle":"min_rows_*","href":"/pt-BR/reference/settings/merge-tree-settings/min-rows"},{"title":"configurações number_of_* de tabelas MergeTree","sidebarTitle":"number_of_*","href":"/pt-BR/reference/settings/merge-tree-settings/number-of"},{"title":"configurações da tabela MergeTree object_shared_*","sidebarTitle":"object_shared_*","href":"/pt-BR/reference/settings/merge-tree-settings/object-shared"},{"title":"configurações da tabela MergeTree part_moves_*","sidebarTitle":"part_moves_*","href":"/pt-BR/reference/settings/merge-tree-settings/part-moves"},{"title":"configurações de tabela do MergeTree parts_to_*","sidebarTitle":"parts_to_*","href":"/pt-BR/reference/settings/merge-tree-settings/parts-to"},{"title":"configurações de tabela do MergeTree prefer_fetch_*","sidebarTitle":"prefer_fetch_*","href":"/pt-BR/reference/settings/merge-tree-settings/prefer-fetch"},{"title":"configurações de tabela prewarm_* do MergeTree","sidebarTitle":"prewarm_*","href":"/pt-BR/reference/settings/merge-tree-settings/prewarm"},{"title":"configurações de tabela MergeTree primary_key_*","sidebarTitle":"primary_key_*","href":"/pt-BR/reference/settings/merge-tree-settings/primary-key"},{"title":"configurações de tabela do MergeTree refresh_*","sidebarTitle":"refresh_*","href":"/pt-BR/reference/settings/merge-tree-settings/refresh"},{"title":"configurações de tabela do MergeTree remote_fs_*","sidebarTitle":"remote_fs_*","href":"/pt-BR/reference/settings/merge-tree-settings/remote-fs"},{"title":"configurações de tabela MergeTree remove_*","sidebarTitle":"remove_*","href":"/pt-BR/reference/settings/merge-tree-settings/remove"},{"title":"configurações de tabela MergeTree replicated_deduplication_window_*","sidebarTitle":"replicated_deduplication_window_*","href":"/pt-BR/reference/settings/merge-tree-settings/replicated-deduplication-window"},{"title":"configurações de tabela do MergeTree replicated_fetches_*","sidebarTitle":"replicated_fetches_*","href":"/pt-BR/reference/settings/merge-tree-settings/replicated-fetches"},{"title":"configurações de tabela do MergeTree replicated_max_*","sidebarTitle":"replicated_max_*","href":"/pt-BR/reference/settings/merge-tree-settings/replicated-max"},{"title":"configurações de tabela do MergeTree shared_merge_*","sidebarTitle":"shared_merge_*","href":"/pt-BR/reference/settings/merge-tree-settings/shared-merge"},{"title":"Configurações de tabela sleep_before_* do MergeTree","sidebarTitle":"sleep_before_*","href":"/pt-BR/reference/settings/merge-tree-settings/sleep-before"},{"title":"configurações table_* de tabelas MergeTree","sidebarTitle":"table_*","href":"/pt-BR/reference/settings/merge-tree-settings/table"},{"title":"configurações de tabela do MergeTree text_index_*","sidebarTitle":"text_index_*","href":"/pt-BR/reference/settings/merge-tree-settings/text-index"},{"title":"configurações de tabela MergeTree use_*","sidebarTitle":"use_*","href":"/pt-BR/reference/settings/merge-tree-settings/use"},{"title":"configurações de tabela do MergeTree use_minimalistic_*","sidebarTitle":"use_minimalistic_*","href":"/pt-BR/reference/settings/merge-tree-settings/use-minimalistic"},{"title":"configurações de tabela do MergeTree vertical_merge_*","sidebarTitle":"vertical_merge_*","href":"/pt-BR/reference/settings/merge-tree-settings/vertical-merge"},{"title":"configurações de tabela do MergeTree write_*","sidebarTitle":"write_*","href":"/pt-BR/reference/settings/merge-tree-settings/write"},{"title":"configurações de tabela MergeTree para write_ahead_*","sidebarTitle":"write_ahead_*","href":"/pt-BR/reference/settings/merge-tree-settings/write-ahead"},{"title":"configurações de tabela do MergeTree zero_copy_*","sidebarTitle":"zero_copy_*","href":"/pt-BR/reference/settings/merge-tree-settings/zero-copy"},{"title":"Outras configurações de tabela MergeTree","sidebarTitle":"Outras","href":"/pt-BR/reference/settings/merge-tree-settings/other"}]},{"group":"Configurações de formato","root":{"title":"Configurações de formato","sidebarTitle":"Visão geral","href":"/pt-BR/reference/settings/formats"},"directory":"none","pages":[{"title":"Configurações de formato bool_*","sidebarTitle":"bool_*","href":"/pt-BR/reference/settings/formats/bool"},{"title":"configurações de formato date_time_*","sidebarTitle":"date_time_*","href":"/pt-BR/reference/settings/formats/date-time"},{"title":"configurações de formato format_*","sidebarTitle":"format_*","href":"/pt-BR/reference/settings/formats/format"},{"title":"configurações do formato format_avro_*","sidebarTitle":"format_avro_*","href":"/pt-BR/reference/settings/formats/format-avro"},{"title":"configurações do formato format_binary_*","sidebarTitle":"format_binary_*","href":"/pt-BR/reference/settings/formats/format-binary"},{"title":"configurações do formato format_capn_*","sidebarTitle":"format_capn_*","href":"/pt-BR/reference/settings/formats/format-capn"},{"title":"configurações do formato format_csv_*","sidebarTitle":"format_csv_*","href":"/pt-BR/reference/settings/formats/format-csv"},{"title":"configurações do formato format_custom_*","sidebarTitle":"format_custom_*","href":"/pt-BR/reference/settings/formats/format-custom"},{"title":"configurações de formato do format_regexp_*","sidebarTitle":"format_regexp_*","href":"/pt-BR/reference/settings/formats/format-regexp"},{"title":"configurações de formato format_schema_*","sidebarTitle":"format_schema_*","href":"/pt-BR/reference/settings/formats/format-schema"},{"title":"configurações do formato format_template_*","sidebarTitle":"format_template_*","href":"/pt-BR/reference/settings/formats/format-template"},{"title":"configurações de formato input_format_*","sidebarTitle":"input_format_*","href":"/pt-BR/reference/settings/formats/input-format"},{"title":"configurações de formato output_format_*","sidebarTitle":"output_format_*","href":"/pt-BR/reference/settings/formats/output-format"},{"title":"configurações de formato de schema_inference_*","sidebarTitle":"schema_inference_*","href":"/pt-BR/reference/settings/formats/schema-inference"},{"title":"configurações de formato de show_create_*","sidebarTitle":"show_create_*","href":"/pt-BR/reference/settings/formats/show-create"},{"title":"configurações de formato de type_json_*","sidebarTitle":"type_json_*","href":"/pt-BR/reference/settings/formats/type-json"},{"title":"Outras configurações de formato","sidebarTitle":"Outros","href":"/pt-BR/reference/settings/formats/other"}]},{"sidebarTitle":"Recursos Beta e Experimentais","title":"Recursos Beta e Experimentais","href":"/pt-BR/reference/settings/beta-and-experimental-features"}]},{"group":"Tabelas de sistema","expanded":false,"pages":[{"sidebarTitle":"Visão geral","title":"Visão geral das tabelas do sistema","href":"/pt-BR/reference/system-tables/overview"},{"title":"system.aggregate_function_combinators","href":"/pt-BR/reference/system-tables/aggregate_function_combinators"},{"title":"system.aggregated_zookeeper_log","href":"/pt-BR/reference/system-tables/aggregated_zookeeper_log"},{"title":"system.asynchronous_insert_log","href":"/pt-BR/reference/system-tables/asynchronous_insert_log"},{"title":"system.asynchronous_inserts","href":"/pt-BR/reference/system-tables/asynchronous_inserts"},{"title":"system.asynchronous_loader","href":"/pt-BR/reference/system-tables/asynchronous_loader"},{"title":"system.asynchronous_metric_log","href":"/pt-BR/reference/system-tables/asynchronous_metric_log"},{"title":"system.asynchronous_metrics","href":"/pt-BR/reference/system-tables/asynchronous_metrics"},{"title":"system.azure_queue_log","href":"/pt-BR/reference/system-tables/azure_queue_log"},{"sidebarTitle":"system.azure_queue_metadata","title":"system.azure_queue_metadata","href":"/pt-BR/reference/system-tables/azure_queue_metadata"},{"title":"system.azure_queue_metadata_cache","href":"/pt-BR/reference/system-tables/azure_queue_metadata_cache"},{"title":"system.azure_queue_settings","href":"/pt-BR/reference/system-tables/azure_queue_settings"},{"title":"system.backup_log","href":"/pt-BR/reference/system-tables/backup_log"},{"title":"system.backups","href":"/pt-BR/reference/system-tables/backups"},{"title":"system.background_schedule_pool","href":"/pt-BR/reference/system-tables/background_schedule_pool"},{"title":"system.background_schedule_pool_log","href":"/pt-BR/reference/system-tables/background_schedule_pool_log"},{"title":"system.blob_storage_log","href":"/pt-BR/reference/system-tables/blob_storage_log"},{"title":"system.build_options","href":"/pt-BR/reference/system-tables/build_options"},{"title":"system.certificates","href":"/pt-BR/reference/system-tables/certificates"},{"title":"system.clusters","href":"/pt-BR/reference/system-tables/clusters"},{"title":"system.codecs","href":"/pt-BR/reference/system-tables/codecs"},{"title":"system.collations","href":"/pt-BR/reference/system-tables/collations"},{"title":"system.columns","href":"/pt-BR/reference/system-tables/columns"},{"sidebarTitle":"system.columns_cache","title":"system.columns_cache","href":"/pt-BR/reference/system-tables/columns_cache"},{"title":"system.completions","href":"/pt-BR/reference/system-tables/completions"},{"sidebarTitle":"system.constraints","title":"system.constraints","href":"/pt-BR/reference/system-tables/constraints"},{"title":"system.contributors","href":"/pt-BR/reference/system-tables/contributors"},{"title":"system.crash_log","href":"/pt-BR/reference/system-tables/crash_log"},{"title":"system.current_roles","href":"/pt-BR/reference/system-tables/current_roles"},{"title":"system.dashboards","href":"/pt-BR/reference/system-tables/dashboards"},{"title":"system.data_skipping_index_types","href":"/pt-BR/reference/system-tables/data_skipping_index_types"},{"title":"system.data_skipping_indices","href":"/pt-BR/reference/system-tables/data_skipping_indices"},{"title":"system.data_type_families","href":"/pt-BR/reference/system-tables/data_type_families"},{"title":"system.database_engines","href":"/pt-BR/reference/system-tables/database_engines"},{"title":"system.database_replicas","href":"/pt-BR/reference/system-tables/database_replicas"},{"title":"system.databases","href":"/pt-BR/reference/system-tables/databases"},{"title":"system.dead_letter_queue","href":"/pt-BR/reference/system-tables/dead_letter_queue"},{"sidebarTitle":"system.delta_lake_metadata_log","title":"system.delta_lake_metadata_log","href":"/pt-BR/reference/system-tables/delta_lake_metadata_log"},{"title":"system.delta_lake_metadata_log","href":"/pt-BR/reference/system-tables/delta_metadata_log"},{"title":"system.detached_parts","href":"/pt-BR/reference/system-tables/detached_parts"},{"title":"system.detached_tables","href":"/pt-BR/reference/system-tables/detached_tables"},{"title":"system.dictionaries","href":"/pt-BR/reference/system-tables/dictionaries"},{"title":"system.dictionary_layouts","href":"/pt-BR/reference/system-tables/dictionary_layouts"},{"title":"system.dictionary_sources","href":"/pt-BR/reference/system-tables/dictionary_sources"},{"title":"system.dimensional_metrics","href":"/pt-BR/reference/system-tables/dimensional_metrics"},{"title":"system.disks","href":"/pt-BR/reference/system-tables/disks"},{"title":"system.disk_types","href":"/pt-BR/reference/system-tables/disk_types"},{"title":"system.distributed_ddl_queue","href":"/pt-BR/reference/system-tables/distributed_ddl_queue"},{"title":"system.distribution_queue","href":"/pt-BR/reference/system-tables/distribution_queue"},{"title":"system.dns_cache","href":"/pt-BR/reference/system-tables/dns_cache"},{"title":"system.documentation","href":"/pt-BR/reference/system-tables/documentation"},{"title":"system.dropped_tables","href":"/pt-BR/reference/system-tables/dropped_tables"},{"title":"system.dropped_tables_parts","href":"/pt-BR/reference/system-tables/dropped_tables_parts"},{"title":"system.enabled_roles","href":"/pt-BR/reference/system-tables/enabled_roles"},{"title":"system.error_log","href":"/pt-BR/reference/system-tables/error_log"},{"title":"system.errors","href":"/pt-BR/reference/system-tables/errors"},{"title":"system.events","href":"/pt-BR/reference/system-tables/events"},{"title":"system.fail_points","href":"/pt-BR/reference/system-tables/fail_points"},{"title":"system.formats","href":"/pt-BR/reference/system-tables/formats"},{"title":"system.filesystem_cache_log","href":"/pt-BR/reference/system-tables/filesystem_cache_log"},{"title":"system.filesystem_cache_settings","href":"/pt-BR/reference/system-tables/filesystem_cache_settings"},{"title":"system.filesystem_cache","href":"/pt-BR/reference/system-tables/filesystem_cache"},{"title":"system.filesystem_read_prefetches_log","href":"/pt-BR/reference/system-tables/filesystem_read_prefetches_log"},{"title":"system.functions","href":"/pt-BR/reference/system-tables/functions"},{"title":"system.grants","href":"/pt-BR/reference/system-tables/grants"},{"title":"system.graphite_retentions","href":"/pt-BR/reference/system-tables/graphite_retentions"},{"sidebarTitle":"system.handlers","title":"system.handlers","href":"/pt-BR/reference/system-tables/handlers"},{"sidebarTitle":"histogram_metric_log","title":"system.histogram_metric_log","href":"/pt-BR/reference/system-tables/histogram_metric_log"},{"title":"system.histogram_metrics","href":"/pt-BR/reference/system-tables/histogram_metrics"},{"sidebarTitle":"hypothetical_indexes","title":"system.hypothetical_indexes","href":"/pt-BR/reference/system-tables/hypothetical_indexes"},{"sidebarTitle":"hypothetical_projections","title":"system.hypothetical_projections","href":"/pt-BR/reference/system-tables/hypothetical_projections"},{"title":"system.iceberg_files","href":"/pt-BR/reference/system-tables/iceberg_files"},{"title":"system.iceberg_history","href":"/pt-BR/reference/system-tables/iceberg_history"},{"title":"system.iceberg_metadata_log","href":"/pt-BR/reference/system-tables/iceberg_metadata_log"},{"title":"INFORMATION_SCHEMA","href":"/pt-BR/reference/system-tables/information_schema"},{"title":"system.instrumentation","href":"/pt-BR/reference/system-tables/instrumentation"},{"sidebarTitle":"system.jemalloc_arena_bins","title":"system.jemalloc_arena_bins","href":"/pt-BR/reference/system-tables/jemalloc_arena_bins"},{"title":"system.jemalloc_bins","href":"/pt-BR/reference/system-tables/jemalloc_bins"},{"title":"system.jemalloc_profile_text","href":"/pt-BR/reference/system-tables/jemalloc_profile_text"},{"sidebarTitle":"system.jemalloc_sampled_allocations","title":"system.jemalloc_sampled_allocations","href":"/pt-BR/reference/system-tables/jemalloc_sampled_allocations"},{"title":"system.jemalloc_stats","href":"/pt-BR/reference/system-tables/jemalloc_stats"},{"title":"system.kafka_consumers","href":"/pt-BR/reference/system-tables/kafka_consumers"},{"title":"system.keeper_changelogs","href":"/pt-BR/reference/system-tables/keeper_changelogs"},{"title":"system.keeper_cluster","href":"/pt-BR/reference/system-tables/keeper_cluster"},{"title":"system.keeper_snapshots","href":"/pt-BR/reference/system-tables/keeper_snapshots"},{"sidebarTitle":"keeper_storage","title":"system.keeper_storage","href":"/pt-BR/reference/system-tables/keeper_storage"},{"title":"system.keywords","href":"/pt-BR/reference/system-tables/keywords"},{"title":"system.licenses","href":"/pt-BR/reference/system-tables/licenses"},{"title":"system.macros","href":"/pt-BR/reference/system-tables/macros"},{"title":"system.masking_policies","href":"/pt-BR/reference/system-tables/masking_policies"},{"title":"system.merge_tree_settings","href":"/pt-BR/reference/system-tables/merge_tree_settings"},{"title":"system.merges","href":"/pt-BR/reference/system-tables/merges"},{"title":"system.metric_log","href":"/pt-BR/reference/system-tables/metric_log"},{"title":"system.metrics","href":"/pt-BR/reference/system-tables/metrics"},{"sidebarTitle":"models","title":"system.models","href":"/pt-BR/reference/system-tables/models"},{"title":"system.moves","href":"/pt-BR/reference/system-tables/moves"},{"title":"system.mutations","href":"/pt-BR/reference/system-tables/mutations"},{"title":"system.named_collections","href":"/pt-BR/reference/system-tables/named_collections"},{"title":"system.numbers","href":"/pt-BR/reference/system-tables/numbers"},{"title":"system.numbers_mt","href":"/pt-BR/reference/system-tables/numbers_mt"},{"title":"system.one","href":"/pt-BR/reference/system-tables/one"},{"title":"system.opentelemetry_span_log","href":"/pt-BR/reference/system-tables/opentelemetry_span_log"},{"title":"system.part_log","href":"/pt-BR/reference/system-tables/part_log"},{"title":"system.part_moves_between_shards","href":"/pt-BR/reference/system-tables/part_moves_between_shards"},{"title":"system.parts","href":"/pt-BR/reference/system-tables/parts"},{"title":"system.parts_columns","href":"/pt-BR/reference/system-tables/parts_columns"},{"title":"system.predicate_statistics_log","href":"/pt-BR/reference/system-tables/predicate_statistics_log"},{"title":"system.primes","href":"/pt-BR/reference/system-tables/primes"},{"title":"system.privileges","href":"/pt-BR/reference/system-tables/privileges"},{"title":"system.processes","href":"/pt-BR/reference/system-tables/processes"},{"title":"system.processors_profile_log","href":"/pt-BR/reference/system-tables/processors_profile_log"},{"title":"system.projection_parts","href":"/pt-BR/reference/system-tables/projection_parts"},{"title":"system.projection_parts_columns","href":"/pt-BR/reference/system-tables/projection_parts_columns"},{"title":"system.projections","href":"/pt-BR/reference/system-tables/projections"},{"title":"system.query_cache","href":"/pt-BR/reference/system-tables/query_cache"},{"title":"system.query_condition_cache","href":"/pt-BR/reference/system-tables/query_condition_cache"},{"title":"system.query_log","href":"/pt-BR/reference/system-tables/query_log"},{"title":"system.query_metric_log","href":"/pt-BR/reference/system-tables/query_metric_log"},{"title":"system.query_thread_log","href":"/pt-BR/reference/system-tables/query_thread_log"},{"title":"system.query_views_log","href":"/pt-BR/reference/system-tables/query_views_log"},{"title":"system.quota_limits","href":"/pt-BR/reference/system-tables/quota_limits"},{"title":"system.quota_usage","href":"/pt-BR/reference/system-tables/quota_usage"},{"title":"system.quotas","href":"/pt-BR/reference/system-tables/quotas"},{"title":"system.quotas_usage","href":"/pt-BR/reference/system-tables/quotas_usage"},{"title":"system.remote_data_paths","href":"/pt-BR/reference/system-tables/remote_data_paths"},{"title":"system.replicas","href":"/pt-BR/reference/system-tables/replicas"},{"title":"system.replicated_fetches","href":"/pt-BR/reference/system-tables/replicated_fetches"},{"title":"system.replicated_merge_tree_settings","href":"/pt-BR/reference/system-tables/replicated_merge_tree_settings"},{"title":"system.replication_queue","href":"/pt-BR/reference/system-tables/replication_queue"},{"title":"system.resources","href":"/pt-BR/reference/system-tables/resources"},{"title":"system.rocksdb","href":"/pt-BR/reference/system-tables/rocksdb"},{"title":"system.role_grants","href":"/pt-BR/reference/system-tables/role_grants"},{"title":"system.roles","href":"/pt-BR/reference/system-tables/roles"},{"title":"system.row_policies","href":"/pt-BR/reference/system-tables/row_policies"},{"sidebarTitle":"system.s3_queue_metadata","title":"system.s3_queue_metadata","href":"/pt-BR/reference/system-tables/s3_queue_metadata"},{"title":"system.s3_queue_settings","href":"/pt-BR/reference/system-tables/s3_queue_settings"},{"title":"system.s3queue_log","href":"/pt-BR/reference/system-tables/s3queue_log"},{"title":"system.s3queue_metadata_cache","href":"/pt-BR/reference/system-tables/s3queue_metadata_cache"},{"title":"system.scheduler","href":"/pt-BR/reference/system-tables/scheduler"},{"title":"system.schema_inference_cache","href":"/pt-BR/reference/system-tables/schema_inference_cache"},{"title":"system.server_settings","href":"/pt-BR/reference/system-tables/server_settings"},{"title":"system.session_log","href":"/pt-BR/reference/system-tables/session_log"},{"sidebarTitle":"system.session_query_ids","title":"system.session_query_ids","href":"/pt-BR/reference/system-tables/session_query_ids"},{"title":"system.settings","href":"/pt-BR/reference/system-tables/settings"},{"title":"system.settings_changes","href":"/pt-BR/reference/system-tables/settings_changes"},{"title":"system.settings_profile_elements","href":"/pt-BR/reference/system-tables/settings_profile_elements"},{"title":"system.settings_profiles","href":"/pt-BR/reference/system-tables/settings_profiles"},{"title":"system.stack_trace","href":"/pt-BR/reference/system-tables/stack_trace"},{"sidebarTitle":"system.statements","title":"system.statements","href":"/pt-BR/reference/system-tables/statements"},{"sidebarTitle":"system.stemmers","title":"system.stemmers","href":"/pt-BR/reference/system-tables/stemmers"},{"title":"system.storage_policies","href":"/pt-BR/reference/system-tables/storage_policies"},{"title":"system.symbols","href":"/pt-BR/reference/system-tables/symbols"},{"title":"system.warnings","href":"/pt-BR/reference/system-tables/system_warnings"},{"title":"system.table_engines","href":"/pt-BR/reference/system-tables/table_engines"},{"title":"system.table_functions","href":"/pt-BR/reference/system-tables/table_functions"},{"title":"system.tables","href":"/pt-BR/reference/system-tables/tables"},{"title":"system.text_log","href":"/pt-BR/reference/system-tables/text_log"},{"title":"system.time_zones","href":"/pt-BR/reference/system-tables/time_zones"},{"title":"system.tokenizers","href":"/pt-BR/reference/system-tables/tokenizers"},{"title":"system.trace_log","href":"/pt-BR/reference/system-tables/trace_log"},{"title":"system.transactions","href":"/pt-BR/reference/system-tables/transactions"},{"title":"system.transactions_info_log","href":"/pt-BR/reference/system-tables/transactions_info_log"},{"title":"system.unicode","href":"/pt-BR/reference/system-tables/unicode"},{"title":"system.user_defined_functions","href":"/pt-BR/reference/system-tables/user_defined_functions"},{"title":"system.user_directories","href":"/pt-BR/reference/system-tables/user_directories"},{"title":"system.user_processes","href":"/pt-BR/reference/system-tables/user_processes"},{"sidebarTitle":"user_query_log","title":"system.user_query_log","href":"/pt-BR/reference/system-tables/user_query_log"},{"title":"system.users","href":"/pt-BR/reference/system-tables/users"},{"title":"system.view_refreshes","href":"/pt-BR/reference/system-tables/view_refreshes"},{"title":"system.warnings","href":"/pt-BR/reference/system-tables/warnings"},{"title":"system.workloads","href":"/pt-BR/reference/system-tables/workloads"},{"title":"system.zeros","href":"/pt-BR/reference/system-tables/zeros"},{"title":"system.zeros_mt","href":"/pt-BR/reference/system-tables/zeros_mt"},{"title":"system.zookeeper","href":"/pt-BR/reference/system-tables/zookeeper"},{"title":"system.zookeeper_info","href":"/pt-BR/reference/system-tables/zookeeper_info"},{"title":"system.zookeeper_connection","href":"/pt-BR/reference/system-tables/zookeeper_connection"},{"title":"system.zookeeper_connection_log","href":"/pt-BR/reference/system-tables/zookeeper_connection_log"},{"title":"system.zookeeper_log","href":"/pt-BR/reference/system-tables/zookeeper_log"},{"title":"system.zookeeper_watches","href":"/pt-BR/reference/system-tables/zookeeper_watches"}]},{"group":"Lagos de dados","pages":[{"sidebarTitle":"Visão geral","title":"Lagos de dados","href":"/pt-BR/reference/datalakes"}]}]}]},{"tab":"Soluções","menu":[{"item":"ClickHouse Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickHouse Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"ClickHouse Cloud","href":"/pt-BR/products/cloud/getting-started/cloud-get-started"}]},{"item":"ClickHouse Managed Postgres","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-postgres.svg","pages":[{"title":"ClickHouse Managed Postgres","href":"/pt-BR/products/managed-postgres/overview"}]},{"item":"Langfuse","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/logo-langfuse.svg","href":"https://langfuse.com/docs"},{"item":"Código aberto","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickstack.svg","pages":[{"title":"ClickStack","href":"/pt-BR/clickstack"}]},{"item":"Agentic Data Stack","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-agentic-data-stack.svg","pages":[{"title":"Agentic Data Stack","href":"/pt-BR/products/agentic-data-stack/overview"}]},{"item":"chDB","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-chdb.svg","pages":[{"title":"chDB","href":"/pt-BR/chdb"}]},{"item":"Operador do Kubernetes","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-kubernetes-operator.svg","pages":[{"title":"Operador do Kubernetes","href":"/pt-BR/products/kubernetes-operator/overview"}]}],"pages":[{"title":"Soluções","href":"/pt-BR/products/cloud/getting-started/cloud-get-started"}]},{"tab":"Integrações","menu":[{"item":"Ecossistema","pages":[{"title":"Ecossistema","href":"/pt-BR/integrations/home"}]},{"item":"ClickPipes","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickpipes.svg","pages":[{"title":"ClickPipes","href":"/pt-BR/integrations/clickpipes/home"}]},{"item":"Clientes por linguagem","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-language-clients.svg","pages":[{"title":"Clientes por linguagem","href":"/pt-BR/integrations/language-clients"}]},{"item":"Conectores","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-connectors.svg","pages":[{"title":"Conectores","href":"/pt-BR/integrations/connectors/data-sources"}]}],"pages":[{"title":"Integrações","href":"/pt-BR/integrations/home"}]},{"tab":"Recursos","menu":[{"item":"Central de suporte","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-support-center.svg","pages":[{"title":"Central de suporte","href":"/pt-BR/resources/support-center/home"}]},{"item":"Desenvolvimento e contribuições","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-contribute.svg","pages":[{"title":"Desenvolvimento e contribuições","href":"/pt-BR/resources/develop-contribute/introduction/developer-instruction"}]},{"item":"Registros de alterações","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-changelogs.svg","dropdowns":[{"dropdown":"Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"Cloud","href":"/pt-BR/resources/changelogs/cloud"}]},{"dropdown":"Código aberto","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-server.svg","pages":[{"title":"Código aberto","href":"/pt-BR/resources/changelogs/oss/2026"}]}]},{"item":"Sobre","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-about.svg","pages":[{"title":"Sobre","href":"/pt-BR/resources/about"}]}],"pages":[{"title":"Recursos","href":"/pt-BR/resources/support-center/home"}]}]},{"language":"ru","pages":[{"title":"ru","href":"/ru/reference/functions/regular-functions/in-functions"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/reference/functions/regular-functions/in-functions"}]}]},"basePath":"","title":"Funções para implementação do operador IN - ClickHouse Documentation","buildId":"dpl_9yaRmq8qi7yyMZn9oEWmKEdYMvGZ","deploymentId":"dpl_9yaRmq8qi7yyMZn9oEWmKEdYMvGZ","dynamics":[],"chunks":[]}
