{"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.2709","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":"6ae8d9fc28a88ed9db40f71c","collectionId":"2dfa09da-3a3e-4782-ad6a-6694be472bd7","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ae8d9fc28a88ed9db40f71c"},"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":"6ae8d9fc28a88ed9db40f71c","clientVersion":"0.0.4045","searchFilterCounts":[{"language":"en","tag":"Database","count":1751},{"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":1576},{"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":560},{"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":509},{"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":256},{"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":125},{"language":"default","tag":"ClickHouse Cloud","count":125},{"language":"default","tag":"Cloud API","count":83},{"language":"default","tag":"API reference","count":83},{"language":"default","tag":"ClickHouse Private","count":42},{"language":"default","tag":"ClickStack","count":31},{"language":"default","tag":"Service","count":24},{"language":"default","tag":"Organization","count":21},{"language":"default","tag":"Postgres","count":18},{"language":"default","tag":"How-To Guides","count":17}],"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":"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":"byok-sep-25","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":"billing-updated-9-15","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}],"googleFontsInlined":false},"customCss":[{"filePath":"_site/styles.css","href":"/docs/_mintlify/custom/private-7c7dfe99/2a1d0d506d6c7ad1/_site/styles.css"},{"filePath":"snippets/components/Badges/badges_styles.css","content":".ClickHouseSupportedBadge,.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:.875rem}.betaBadge::before{content:\"β\";flex:0 0 auto;margin-right:8px;font-size:1rem;font-weight:600;line-height:1}.dark a.betaBadge,a.betaBadge{color:#1d4ed8!important;text-decoration:none!important}.dark .betaBadge{background-color:#1e3a6b;color:#93c5fd}.dark a.betaBadge{color:#93c5fd!important}.ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.ClickHouseSupportedIcon{margin-right:8px}.ClickHouseSupportedIcon svg path{fill:#282828}.ClickHouseSupportedBadge a{color:#000}.dark .ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.dark .ClickHouseSupportedBadge a{color:#161517}.dark .ClickHouseSupportedIcon svg path{fill:#161517}.cloudNotSupportedBadge{background-color:#f6e5ff;color:#609;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:.875rem}.cloudNotSupportedIcon{margin-right:8px}a.cloudNotSupportedBadge{color:#609!important;text-decoration:none!important}.cloudNotSupportedIcon svg path{stroke:#609}.dark .cloudNotSupportedBadge{background-color:#33004d;color:#ecf}.dark a.cloudNotSupportedBadge{color:#ecf!important;text-decoration:none!important}.dark .cloudNotSupportedIcon svg path{stroke:#ecf}.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:.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:#fff;display:inline-flex;margin-right:5px;font-size:.875rem}.CommunityMaintainedIcon{margin-right:8px}.CommunityMaintainedIcon svg path,.dark .CommunityMaintainedIcon svg path{fill:#fff;stroke:none}.CommunityMaintainedBadge a,.CommunityMaintainedBadge svg path{color:#69afff}.dark .CommunityMaintainedBadge{background-color:#69afff;color:#fff}.dark .CommunityMaintainedBadge a{color:#fff}.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:.875rem}.deprecatedIcon{margin-right:8px}.dark .deprecatedBadge a,.deprecatedBadge a{color:inherit}.dark .deprecatedBadge{background-color:#414141;color:#e6e7e9}.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:.875rem}.enterprisePlanFeatureContainer p,.scalePlanFeatureContainer p{margin:0;padding:0}.enterprisePlanFeatureBadge,.experimentalBadge{border-radius:16px;display:flex;align-items:center;display:inline-flex;font-size:.875rem}.enterprisePlanFeatureBadge{background-color:#008a0b;border:1px;border-color:#437eef;color:#fff;padding:2px 12px;margin-bottom:8px}.dark .enterprisePlanFeatureContainer{background-color:#1f1f1c;border:1px solid #414141}.dark .enterprisePlanFeatureBadge{background-color:#99ffa1;color:#1f1f1c}.experimentalBadge{background-color:#f3e8ff;color:#6d28d9;padding:5px 12px;margin-right:5px}.experimentalIcon{margin-right:8px}.dark a.experimentalBadge,a.experimentalBadge{color:#6d28d9!important;text-decoration:none!important}.dark .experimentalBadge{background-color:#3b1d6b;color:#d8b4fe}.dark a.experimentalBadge{color:#d8b4fe!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:#fff;display:inline-flex;margin-right:5px;font-size:.875rem}.PartnerBadgeIcon{margin-right:8px}.PartnerBadgeIcon svg path{fill:#fbc9ef;stroke:#990073}.PartnerBadge a,.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:.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:.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:.875rem}.scalePlanFeatureBadge{border-radius:16px;display:flex;align-items:center;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:.875rem}.dark .scalePlanFeatureContainer{background-color:#1f1f1c;border:1px solid #414141}.dark .scalePlanFeatureBadge,.scalePlanFeatureBadge{background-color:#1d64ec;color:#fff}"},{"filePath":"snippets/components/ClickStackAnimation/ClickStackAnimation.css","content":"@keyframes fadeInOut{0%,to{opacity:.3}50%{opacity:.8}}.clickstack-animation-wrapper{width:100%;max-width:max-content;transition:opacity .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:.375rem;padding:1rem;flex-shrink:0;border:1px solid rgba(113,113,122,.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,.6);filter:blur(40px)}.clickstack-logo-box{position:absolute;inset:0;z-index:10;display:flex;border-radius:.5rem;border:2px solid #faff69;background-color:#262626;background-image:linear-gradient(to bottom right,rgba(250,255,105,.2),rgba(250,255,105,.4))}.clickstack-logo-svg{margin:auto}:is(.light) .clickstack-logo-glow{display:none}:is(.light) .clickstack-logo-box{border-color:#faff69;background-color:#000;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/settings/formats","slug":"/pt-BR/reference/settings/formats","pageMetadata":{"title":"Configurações de formato","sidebarTitle":"Visão geral","slug":"/operations/settings/formats","toc_max_heading_level":2,"description":"Configurações que controlam os formatos de entrada e saída.","doc_type":"reference","href":"/pt-BR/reference/settings/formats"},"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: \"Configurações que controlam os formatos de entrada e saída.\"\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];const __snippet_galaxyOnClick_xk7ifz=eventName=>()=>{try{if(typeof window!==`undefined`\u0026\u0026window.galaxy\u0026\u0026eventName){window.galaxy.track(eventName,{interaction:`click`})}}catch(e){}};const BetaBadge=({link,galaxyTrack,galaxyEvent})=>{const _components={a:`a`,..._provideComponents()};if(link){return _jsx(_components.a,{href:link,target:`_blank`,rel:`noopener noreferrer`,className:`betaBadge`,onClick:galaxyTrack\u0026\u0026galaxyEvent?__snippet_galaxyOnClick_xk7ifz(galaxyEvent):undefined,children:_jsx(`span`,{children:`Beta`})})}return _jsx(`a`,{href:`https://clickhouse.com/docs/reference/settings/beta-and-experimental-features#beta-features`,className:`betaBadge`,children:_jsx(`span`,{children:`Recurso beta`})})};const ExperimentalBadge=()=>{return _jsxs(`a`,{href:`https://clickhouse.com/docs/reference/settings/beta-and-experimental-features#experimental-features`,className:`experimentalBadge`,children:[_jsx(`div`,{className:`experimentalIcon`,children:_jsxs(`svg`,{width:`16`,height:`16`,viewBox:`0 0 16 16`,fill:`none`,xmlns:`http://www.w3.org/2000/svg`,children:[_jsx(`path`,{strokeWidth:`1.25`,d:`M5.5 2H10.5`,stroke:`currentColor`,strokeLinecap:`round`,strokeLinejoin:`round`}),_jsx(`path`,{strokeWidth:`1.25`,d:`M9.50015 2V6.19625L13.4283 12.7425C13.4738 12.8183 13.4985 12.9049 13.4996 12.9934C13.5008 13.0818 13.4785 13.169 13.435 13.246C13.3914 13.323 13.3283 13.3871 13.2519 13.4317C13.1755 13.4764 13.0886 13.4999 13.0002 13.5H3.00015C2.91164 13.5 2.8247 13.4766 2.74822 13.432C2.67174 13.3874 2.60847 13.3233 2.56487 13.2463C2.52126 13.1693 2.49889 13.082 2.50004 12.9935C2.50119 12.905 2.52582 12.8184 2.5714 12.7425L6.50015 6.19625V2`,stroke:`currentColor`,strokeLinecap:`round`,strokeLinejoin:`round`}),_jsx(`path`,{strokeWidth:`1.25`,d:`M4.47656 9.56754C5.30344 9.41254 6.47656 9.47942 7.99969 10.25C10.0153 11.2707 11.4216 11.0569 12.2184 10.7282`,stroke:`currentColor`,strokeLinecap:`round`,strokeLinejoin:`round`})]})}),`Recurso experimental`]})};const FormatSettingsExplorer=({href:baseRoute})=>{const _components={a:`a`,..._provideComponents()};const[entries]=useState(()=>[{label:`bool_*`,count:2,settings:[{name:`bool_false_representation`,path:`/bool#bool_false_representation`,default:`false`},{name:`bool_true_representation`,path:`/bool#bool_true_representation`,default:`true`}],children:[]},{label:`date_time_*`,count:4,settings:[{name:`date_time_64_output_format_cut_trailing_zeros_align_to_groups_of_thousands`,path:`/date-time#date_time_64_output_format_cut_trailing_zeros_align_to_groups_of_thousands`,default:`0`},{name:`date_time_input_format`,path:`/date-time#date_time_input_format`,default:`best_effort`},{name:`date_time_output_format`,path:`/date-time#date_time_output_format`,default:`simple`},{name:`date_time_overflow_behavior`,path:`/date-time#date_time_overflow_behavior`,default:`ignore`}],children:[]},{label:`format_*`,count:6,settings:[{name:`format_display_secrets_in_show_and_select`,path:`/format#format_display_secrets_in_show_and_select`,default:`0`},{name:`format_geojson_validate_geometry`,path:`/format#format_geojson_validate_geometry`,default:`1`},{name:`format_hive_text_rows_delimiter`,path:`/format#format_hive_text_rows_delimiter`,default:`\"\"`},{name:`format_json_object_each_row_column_for_object_name`,path:`/format#format_json_object_each_row_column_for_object_name`,default:`\"\"`},{name:`format_protobuf_use_autogenerated_schema`,path:`/format#format_protobuf_use_autogenerated_schema`,default:`1`},{name:`format_tsv_null_representation`,path:`/format#format_tsv_null_representation`,default:`\\\\N`}],children:[]},{label:`format_avro_*`,count:6,settings:[{name:`format_avro_schema_registry_connection_timeout`,path:`/format-avro#format_avro_schema_registry_connection_timeout`,default:`1`},{name:`format_avro_schema_registry_max_retries`,path:`/format-avro#format_avro_schema_registry_max_retries`,default:`5`},{name:`format_avro_schema_registry_receive_timeout`,path:`/format-avro#format_avro_schema_registry_receive_timeout`,default:`1`},{name:`format_avro_schema_registry_retry_initial_backoff_ms`,path:`/format-avro#format_avro_schema_registry_retry_initial_backoff_ms`,default:`100`},{name:`format_avro_schema_registry_send_timeout`,path:`/format-avro#format_avro_schema_registry_send_timeout`,default:`1`},{name:`format_avro_schema_registry_url`,path:`/format-avro#format_avro_schema_registry_url`,default:`\"\"`}],children:[]},{label:`format_binary_*`,count:3,settings:[{name:`format_binary_max_array_size`,path:`/format-binary#format_binary_max_array_size`,default:`1073741824`},{name:`format_binary_max_object_size`,path:`/format-binary#format_binary_max_object_size`,default:`100000`},{name:`format_binary_max_string_size`,path:`/format-binary#format_binary_max_string_size`,default:`1073741824`}],children:[]},{label:`format_capn_*`,count:3,settings:[{name:`format_capn_proto_enum_comparising_mode`,path:`/format-capn#format_capn_proto_enum_comparising_mode`,default:`by_values`},{name:`format_capn_proto_max_message_size`,path:`/format-capn#format_capn_proto_max_message_size`,default:`1073741824`},{name:`format_capn_proto_use_autogenerated_schema`,path:`/format-capn#format_capn_proto_use_autogenerated_schema`,default:`1`}],children:[]},{label:`format_csv_*`,count:4,settings:[{name:`format_csv_allow_double_quotes`,path:`/format-csv#format_csv_allow_double_quotes`,default:`1`},{name:`format_csv_allow_single_quotes`,path:`/format-csv#format_csv_allow_single_quotes`,default:`0`},{name:`format_csv_delimiter`,path:`/format-csv#format_csv_delimiter`,default:`,`},{name:`format_csv_null_representation`,path:`/format-csv#format_csv_null_representation`,default:`\\\\N`}],children:[]},{label:`format_custom_*`,count:7,settings:[{name:`format_custom_escaping_rule`,path:`/format-custom#format_custom_escaping_rule`,default:`Escaped`},{name:`format_custom_field_delimiter`,path:`/format-custom#format_custom_field_delimiter`,default:`\"\"`},{name:`format_custom_result_after_delimiter`,path:`/format-custom#format_custom_result_after_delimiter`,default:`\"\"`},{name:`format_custom_result_before_delimiter`,path:`/format-custom#format_custom_result_before_delimiter`,default:`\"\"`},{name:`format_custom_row_after_delimiter`,path:`/format-custom#format_custom_row_after_delimiter`,default:`\"\"`},{name:`format_custom_row_before_delimiter`,path:`/format-custom#format_custom_row_before_delimiter`,default:`\"\"`},{name:`format_custom_row_between_delimiter`,path:`/format-custom#format_custom_row_between_delimiter`,default:`\"\"`}],children:[]},{label:`format_regexp_*`,count:3,settings:[{name:`format_regexp`,path:`/format-regexp#format_regexp`,default:`\"\"`},{name:`format_regexp_escaping_rule`,path:`/format-regexp#format_regexp_escaping_rule`,default:`Raw`},{name:`format_regexp_skip_unmatched`,path:`/format-regexp#format_regexp_skip_unmatched`,default:`0`}],children:[]},{label:`format_schema_*`,count:3,settings:[{name:`format_schema`,path:`/format-schema#format_schema`,default:`\"\"`},{name:`format_schema_message_name`,path:`/format-schema#format_schema_message_name`,default:`\"\"`},{name:`format_schema_source`,path:`/format-schema#format_schema_source`,default:`file`}],children:[]},{label:`format_template_*`,count:5,settings:[{name:`format_template_resultset`,path:`/format-template#format_template_resultset`,default:`\"\"`},{name:`format_template_resultset_format`,path:`/format-template#format_template_resultset_format`,default:`\"\"`},{name:`format_template_row`,path:`/format-template#format_template_row`,default:`\"\"`},{name:`format_template_row_format`,path:`/format-template#format_template_row_format`,default:`\"\"`},{name:`format_template_rows_between_delimiter`,path:`/format-template#format_template_rows_between_delimiter`,default:`\"\"`}],children:[]},{label:`input_format_*`,count:132,settings:[{name:`input_format_allow_errors_num`,path:`/input-format#input_format_allow_errors_num`,default:`0`},{name:`input_format_allow_errors_ratio`,path:`/input-format#input_format_allow_errors_ratio`,default:`0`},{name:`input_format_allow_seeks`,path:`/input-format#input_format_allow_seeks`,default:`1`},{name:`input_format_arrow_allow_missing_columns`,path:`/input-format#input_format_arrow_allow_missing_columns`,default:`1`},{name:`input_format_arrow_case_insensitive_column_matching`,path:`/input-format#input_format_arrow_case_insensitive_column_matching`,default:`0`},{name:`input_format_arrow_skip_columns_with_unsupported_types_in_schema_inference`,path:`/input-format#input_format_arrow_skip_columns_with_unsupported_types_in_schema_inference`,default:`0`},{name:`input_format_avro_allow_missing_fields`,path:`/input-format#input_format_avro_allow_missing_fields`,default:`0`},{name:`input_format_avro_null_as_default`,path:`/input-format#input_format_avro_null_as_default`,default:`0`},{name:`input_format_binary_decode_types_in_binary_format`,path:`/input-format#input_format_binary_decode_types_in_binary_format`,default:`0`},{name:`input_format_binary_max_type_complexity`,path:`/input-format#input_format_binary_max_type_complexity`,default:`1000`},{name:`input_format_binary_read_json_as_string`,path:`/input-format#input_format_binary_read_json_as_string`,default:`0`},{name:`input_format_bson_skip_fields_with_unsupported_types_in_schema_inference`,path:`/input-format#input_format_bson_skip_fields_with_unsupported_types_in_schema_inference`,default:`0`},{name:`input_format_capn_proto_skip_fields_with_unsupported_types_in_schema_inference`,path:`/input-format#input_format_capn_proto_skip_fields_with_unsupported_types_in_schema_inference`,default:`0`},{name:`input_format_column_name_matching_mode`,path:`/input-format#input_format_column_name_matching_mode`,default:`auto`},{name:`input_format_connection_handling`,path:`/input-format#input_format_connection_handling`,default:`0`},{name:`input_format_csv_allow_cr_end_of_line`,path:`/input-format#input_format_csv_allow_cr_end_of_line`,default:`0`},{name:`input_format_csv_allow_variable_number_of_columns`,path:`/input-format#input_format_csv_allow_variable_number_of_columns`,default:`0`},{name:`input_format_csv_allow_whitespace_or_tab_as_delimiter`,path:`/input-format#input_format_csv_allow_whitespace_or_tab_as_delimiter`,default:`0`},{name:`input_format_csv_arrays_as_nested_csv`,path:`/input-format#input_format_csv_arrays_as_nested_csv`,default:`0`},{name:`input_format_csv_deserialize_separate_columns_into_tuple`,path:`/input-format#input_format_csv_deserialize_separate_columns_into_tuple`,default:`1`},{name:`input_format_csv_detect_header`,path:`/input-format#input_format_csv_detect_header`,default:`1`},{name:`input_format_csv_empty_as_default`,path:`/input-format#input_format_csv_empty_as_default`,default:`1`},{name:`input_format_csv_enum_as_number`,path:`/input-format#input_format_csv_enum_as_number`,default:`0`},{name:`input_format_csv_missing_nullable_as_empty_string`,path:`/input-format#input_format_csv_missing_nullable_as_empty_string`,default:`0`},{name:`input_format_csv_skip_first_lines`,path:`/input-format#input_format_csv_skip_first_lines`,default:`0`},{name:`input_format_csv_skip_trailing_empty_lines`,path:`/input-format#input_format_csv_skip_trailing_empty_lines`,default:`0`},{name:`input_format_csv_trim_whitespaces`,path:`/input-format#input_format_csv_trim_whitespaces`,default:`1`},{name:`input_format_csv_try_infer_numbers_from_strings`,path:`/input-format#input_format_csv_try_infer_numbers_from_strings`,default:`0`},{name:`input_format_csv_try_infer_strings_from_quoted_tuples`,path:`/input-format#input_format_csv_try_infer_strings_from_quoted_tuples`,default:`1`},{name:`input_format_csv_use_best_effort_in_schema_inference`,path:`/input-format#input_format_csv_use_best_effort_in_schema_inference`,default:`1`},{name:`input_format_csv_use_default_on_bad_values`,path:`/input-format#input_format_csv_use_default_on_bad_values`,default:`0`},{name:`input_format_custom_allow_variable_number_of_columns`,path:`/input-format#input_format_custom_allow_variable_number_of_columns`,default:`0`},{name:`input_format_custom_detect_header`,path:`/input-format#input_format_custom_detect_header`,default:`1`},{name:`input_format_custom_skip_trailing_empty_lines`,path:`/input-format#input_format_custom_skip_trailing_empty_lines`,default:`0`},{name:`input_format_defaults_for_omitted_fields`,path:`/input-format#input_format_defaults_for_omitted_fields`,default:`1`},{name:`input_format_force_null_for_omitted_fields`,path:`/input-format#input_format_force_null_for_omitted_fields`,default:`0`},{name:`input_format_freeform_max_search_steps`,path:`/input-format#input_format_freeform_max_search_steps`,default:`4096`},{name:`input_format_geojson_unsupported_geometry_handling`,path:`/input-format#input_format_geojson_unsupported_geometry_handling`,default:`throw`},{name:`input_format_hive_text_allow_variable_number_of_columns`,path:`/input-format#input_format_hive_text_allow_variable_number_of_columns`,default:`1`},{name:`input_format_hive_text_collection_items_delimiter`,path:`/input-format#input_format_hive_text_collection_items_delimiter`,default:`\u0002`},{name:`input_format_hive_text_fields_delimiter`,path:`/input-format#input_format_hive_text_fields_delimiter`,default:`\u0001`},{name:`input_format_hive_text_map_keys_delimiter`,path:`/input-format#input_format_hive_text_map_keys_delimiter`,default:`\u0003`},{name:`input_format_import_nested_json`,path:`/input-format#input_format_import_nested_json`,default:`0`},{name:`input_format_ipv4_default_on_conversion_error`,path:`/input-format#input_format_ipv4_default_on_conversion_error`,default:`0`},{name:`input_format_ipv6_default_on_conversion_error`,path:`/input-format#input_format_ipv6_default_on_conversion_error`,default:`0`},{name:`input_format_json_compact_allow_variable_number_of_columns`,path:`/input-format#input_format_json_compact_allow_variable_number_of_columns`,default:`0`},{name:`input_format_json_defaults_for_missing_elements_in_named_tuple`,path:`/input-format#input_format_json_defaults_for_missing_elements_in_named_tuple`,default:`1`},{name:`input_format_json_empty_as_default`,path:`/input-format#input_format_json_empty_as_default`,default:`0`},{name:`input_format_json_ignore_unknown_keys_in_named_tuple`,path:`/input-format#input_format_json_ignore_unknown_keys_in_named_tuple`,default:`1`},{name:`input_format_json_ignore_unnecessary_fields`,path:`/input-format#input_format_json_ignore_unnecessary_fields`,default:`1`},{name:`input_format_json_infer_array_of_dynamic_from_array_of_different_types`,path:`/input-format#input_format_json_infer_array_of_dynamic_from_array_of_different_types`,default:`1`},{name:`input_format_json_infer_incomplete_types_as_strings`,path:`/input-format#input_format_json_infer_incomplete_types_as_strings`,default:`1`},{name:`input_format_json_map_as_array_of_tuples`,path:`/input-format#input_format_json_map_as_array_of_tuples`,default:`0`},{name:`input_format_json_max_depth`,path:`/input-format#input_format_json_max_depth`,default:`1000`},{name:`input_format_json_max_object_size`,path:`/input-format#input_format_json_max_object_size`,default:`536870912`},{name:`input_format_json_max_string_column_growth_step`,path:`/input-format#input_format_json_max_string_column_growth_step`,default:`0`},{name:`input_format_json_named_tuples_as_objects`,path:`/input-format#input_format_json_named_tuples_as_objects`,default:`1`},{name:`input_format_json_read_arrays_as_strings`,path:`/input-format#input_format_json_read_arrays_as_strings`,default:`1`},{name:`input_format_json_read_bools_as_numbers`,path:`/input-format#input_format_json_read_bools_as_numbers`,default:`1`},{name:`input_format_json_read_bools_as_strings`,path:`/input-format#input_format_json_read_bools_as_strings`,default:`1`},{name:`input_format_json_read_numbers_as_strings`,path:`/input-format#input_format_json_read_numbers_as_strings`,default:`1`},{name:`input_format_json_read_objects_as_strings`,path:`/input-format#input_format_json_read_objects_as_strings`,default:`1`},{name:`input_format_json_throw_on_bad_escape_sequence`,path:`/input-format#input_format_json_throw_on_bad_escape_sequence`,default:`1`},{name:`input_format_json_try_infer_named_tuples_from_objects`,path:`/input-format#input_format_json_try_infer_named_tuples_from_objects`,default:`1`},{name:`input_format_json_try_infer_numbers_from_strings`,path:`/input-format#input_format_json_try_infer_numbers_from_strings`,default:`0`},{name:`input_format_json_use_string_type_for_ambiguous_paths_in_named_tuples_inference_from_objects`,path:`/input-format#input_format_json_use_string_type_for_ambiguous_paths_in_named_tuples_inference_from_objects`,default:`0`},{name:`input_format_json_validate_types_from_metadata`,path:`/input-format#input_format_json_validate_types_from_metadata`,default:`1`},{name:`input_format_max_block_size_bytes`,path:`/input-format#input_format_max_block_size_bytes`,default:`0`},{name:`input_format_max_block_wait_ms`,path:`/input-format#input_format_max_block_wait_ms`,default:`0`},{name:`input_format_max_bytes_to_read_for_schema_inference`,path:`/input-format#input_format_max_bytes_to_read_for_schema_inference`,default:`33554432`},{name:`input_format_max_rows_to_read_for_schema_inference`,path:`/input-format#input_format_max_rows_to_read_for_schema_inference`,default:`25000`},{name:`input_format_msgpack_number_of_columns`,path:`/input-format#input_format_msgpack_number_of_columns`,default:`0`},{name:`input_format_mysql_dump_map_column_names`,path:`/input-format#input_format_mysql_dump_map_column_names`,default:`1`},{name:`input_format_mysql_dump_table_name`,path:`/input-format#input_format_mysql_dump_table_name`,default:`\"\"`},{name:`input_format_native_allow_types_conversion`,path:`/input-format#input_format_native_allow_types_conversion`,default:`1`},{name:`input_format_native_decode_types_in_binary_format`,path:`/input-format#input_format_native_decode_types_in_binary_format`,default:`0`},{name:`input_format_null_as_default`,path:`/input-format#input_format_null_as_default`,default:`1`},{name:`input_format_orc_allow_missing_columns`,path:`/input-format#input_format_orc_allow_missing_columns`,default:`1`},{name:`input_format_orc_case_insensitive_column_matching`,path:`/input-format#input_format_orc_case_insensitive_column_matching`,default:`0`},{name:`input_format_orc_dictionary_as_low_cardinality`,path:`/input-format#input_format_orc_dictionary_as_low_cardinality`,default:`1`},{name:`input_format_orc_filter_push_down`,path:`/input-format#input_format_orc_filter_push_down`,default:`1`},{name:`input_format_orc_reader_time_zone_name`,path:`/input-format#input_format_orc_reader_time_zone_name`,default:`GMT`},{name:`input_format_orc_row_batch_size`,path:`/input-format#input_format_orc_row_batch_size`,default:`100000`},{name:`input_format_orc_skip_columns_with_unsupported_types_in_schema_inference`,path:`/input-format#input_format_orc_skip_columns_with_unsupported_types_in_schema_inference`,default:`0`},{name:`input_format_parallel_parsing`,path:`/input-format#input_format_parallel_parsing`,default:`1`},{name:`input_format_parquet_allow_geoparquet_parser`,path:`/input-format#input_format_parquet_allow_geoparquet_parser`,default:`1`},{name:`input_format_parquet_allow_missing_columns`,path:`/input-format#input_format_parquet_allow_missing_columns`,default:`1`},{name:`input_format_parquet_bloom_filter_push_down`,path:`/input-format#input_format_parquet_bloom_filter_push_down`,default:`1`},{name:`input_format_parquet_case_insensitive_column_matching`,path:`/input-format#input_format_parquet_case_insensitive_column_matching`,default:`0`},{name:`input_format_parquet_dictionary_filter_push_down`,path:`/input-format#input_format_parquet_dictionary_filter_push_down`,default:`1048576`},{name:`input_format_parquet_enable_json_parsing`,path:`/input-format#input_format_parquet_enable_json_parsing`,default:`1`},{name:`input_format_parquet_enable_row_group_prefetch`,path:`/input-format#input_format_parquet_enable_row_group_prefetch`,default:`1`},{name:`input_format_parquet_filter_push_down`,path:`/input-format#input_format_parquet_filter_push_down`,default:`1`},{name:`input_format_parquet_footer_read_size`,path:`/input-format#input_format_parquet_footer_read_size`,default:`0`},{name:`input_format_parquet_local_file_min_bytes_for_seek`,path:`/input-format#input_format_parquet_local_file_min_bytes_for_seek`,default:`8192`},{name:`input_format_parquet_local_time_as_utc`,path:`/input-format#input_format_parquet_local_time_as_utc`,default:`1`},{name:`input_format_parquet_max_block_size`,path:`/input-format#input_format_parquet_max_block_size`,default:`65409`},{name:`input_format_parquet_memory_high_watermark`,path:`/input-format#input_format_parquet_memory_high_watermark`,default:`4294967296`},{name:`input_format_parquet_memory_low_watermark`,path:`/input-format#input_format_parquet_memory_low_watermark`,default:`2097152`},{name:`input_format_parquet_page_filter_push_down`,path:`/input-format#input_format_parquet_page_filter_push_down`,default:`1`},{name:`input_format_parquet_prefer_block_bytes`,path:`/input-format#input_format_parquet_prefer_block_bytes`,default:`16744704`},{name:`input_format_parquet_preserve_order`,path:`/input-format#input_format_parquet_preserve_order`,default:`0`},{name:`input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference`,path:`/input-format#input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference`,default:`0`},{name:`input_format_parquet_spatial_filter_push_down`,path:`/input-format#input_format_parquet_spatial_filter_push_down`,default:`1`},{name:`input_format_parquet_use_offset_index`,path:`/input-format#input_format_parquet_use_offset_index`,default:`1`},{name:`input_format_parquet_verify_checksums`,path:`/input-format#input_format_parquet_verify_checksums`,default:`1`},{name:`input_format_protobuf_flatten_google_wrappers`,path:`/input-format#input_format_protobuf_flatten_google_wrappers`,default:`0`},{name:`input_format_protobuf_oneof_presence`,path:`/input-format#input_format_protobuf_oneof_presence`,default:`0`},{name:`input_format_protobuf_skip_fields_with_unsupported_types_in_schema_inference`,path:`/input-format#input_format_protobuf_skip_fields_with_unsupported_types_in_schema_inference`,default:`0`},{name:`input_format_read_datetime_number_as_raw_value`,path:`/input-format#input_format_read_datetime_number_as_raw_value`,default:`0`},{name:`input_format_record_errors_file_path`,path:`/input-format#input_format_record_errors_file_path`,default:`\"\"`},{name:`input_format_skip_unknown_fields`,path:`/input-format#input_format_skip_unknown_fields`,default:`1`},{name:`input_format_sqlite_table_name`,path:`/input-format#input_format_sqlite_table_name`,default:`\"\"`},{name:`input_format_try_infer_dates`,path:`/input-format#input_format_try_infer_dates`,default:`1`},{name:`input_format_try_infer_datetimes`,path:`/input-format#input_format_try_infer_datetimes`,default:`1`},{name:`input_format_try_infer_datetimes_only_datetime64`,path:`/input-format#input_format_try_infer_datetimes_only_datetime64`,default:`0`},{name:`input_format_try_infer_exponent_floats`,path:`/input-format#input_format_try_infer_exponent_floats`,default:`0`},{name:`input_format_try_infer_integers`,path:`/input-format#input_format_try_infer_integers`,default:`1`},{name:`input_format_try_infer_variants`,path:`/input-format#input_format_try_infer_variants`,default:`0`},{name:`input_format_tsv_allow_variable_number_of_columns`,path:`/input-format#input_format_tsv_allow_variable_number_of_columns`,default:`0`},{name:`input_format_tsv_crlf_end_of_line`,path:`/input-format#input_format_tsv_crlf_end_of_line`,default:`0`},{name:`input_format_tsv_detect_header`,path:`/input-format#input_format_tsv_detect_header`,default:`1`},{name:`input_format_tsv_empty_as_default`,path:`/input-format#input_format_tsv_empty_as_default`,default:`0`},{name:`input_format_tsv_enum_as_number`,path:`/input-format#input_format_tsv_enum_as_number`,default:`0`},{name:`input_format_tsv_skip_first_lines`,path:`/input-format#input_format_tsv_skip_first_lines`,default:`0`},{name:`input_format_tsv_skip_trailing_empty_lines`,path:`/input-format#input_format_tsv_skip_trailing_empty_lines`,default:`0`},{name:`input_format_tsv_use_best_effort_in_schema_inference`,path:`/input-format#input_format_tsv_use_best_effort_in_schema_inference`,default:`1`},{name:`input_format_values_accurate_types_of_literals`,path:`/input-format#input_format_values_accurate_types_of_literals`,default:`1`},{name:`input_format_values_deduce_templates_of_expressions`,path:`/input-format#input_format_values_deduce_templates_of_expressions`,default:`1`},{name:`input_format_values_interpret_expressions`,path:`/input-format#input_format_values_interpret_expressions`,default:`1`},{name:`input_format_with_names_use_header`,path:`/input-format#input_format_with_names_use_header`,default:`1`},{name:`input_format_with_types_use_header`,path:`/input-format#input_format_with_types_use_header`,default:`1`}],children:[]},{label:`output_format_*`,count:113,settings:[{name:`output_format_always_write_decimal_point_in_float_and_decimal`,path:`/output-format#output_format_always_write_decimal_point_in_float_and_decimal`,default:`0`},{name:`output_format_arrow_compression_method`,path:`/output-format#output_format_arrow_compression_method`,default:`lz4_frame`},{name:`output_format_arrow_date_as_uint16`,path:`/output-format#output_format_arrow_date_as_uint16`,default:`0`},{name:`output_format_arrow_fixed_string_as_fixed_byte_array`,path:`/output-format#output_format_arrow_fixed_string_as_fixed_byte_array`,default:`1`},{name:`output_format_arrow_low_cardinality_as_dictionary`,path:`/output-format#output_format_arrow_low_cardinality_as_dictionary`,default:`0`},{name:`output_format_arrow_record_batch_size`,path:`/output-format#output_format_arrow_record_batch_size`,default:`0`},{name:`output_format_arrow_record_batch_size_bytes`,path:`/output-format#output_format_arrow_record_batch_size_bytes`,default:`0`},{name:`output_format_arrow_string_as_string`,path:`/output-format#output_format_arrow_string_as_string`,default:`1`},{name:`output_format_arrow_unsupported_types`,path:`/output-format#output_format_arrow_unsupported_types`,default:`binary`},{name:`output_format_arrow_unsupported_types_as_binary`,path:`/output-format#output_format_arrow_unsupported_types_as_binary`,default:`1`},{name:`output_format_arrow_use_64_bit_indexes_for_dictionary`,path:`/output-format#output_format_arrow_use_64_bit_indexes_for_dictionary`,default:`0`},{name:`output_format_arrow_use_signed_indexes_for_dictionary`,path:`/output-format#output_format_arrow_use_signed_indexes_for_dictionary`,default:`1`},{name:`output_format_avro_codec`,path:`/output-format#output_format_avro_codec`,default:`\"\"`},{name:`output_format_avro_confluent_subject`,path:`/output-format#output_format_avro_confluent_subject`,default:`\"\"`},{name:`output_format_avro_rows_in_file`,path:`/output-format#output_format_avro_rows_in_file`,default:`1`},{name:`output_format_avro_string_column_pattern`,path:`/output-format#output_format_avro_string_column_pattern`,default:`\"\"`},{name:`output_format_avro_sync_interval`,path:`/output-format#output_format_avro_sync_interval`,default:`16384`},{name:`output_format_binary_encode_types_in_binary_format`,path:`/output-format#output_format_binary_encode_types_in_binary_format`,default:`0`},{name:`output_format_binary_write_json_as_string`,path:`/output-format#output_format_binary_write_json_as_string`,default:`0`},{name:`output_format_bson_string_as_string`,path:`/output-format#output_format_bson_string_as_string`,default:`0`},{name:`output_format_compression_level`,path:`/output-format#output_format_compression_level`,default:`3`},{name:`output_format_compression_zstd_window_log`,path:`/output-format#output_format_compression_zstd_window_log`,default:`0`},{name:`output_format_csv_crlf_end_of_line`,path:`/output-format#output_format_csv_crlf_end_of_line`,default:`0`},{name:`output_format_csv_header_serialize_tuple_into_separate_columns`,path:`/output-format#output_format_csv_header_serialize_tuple_into_separate_columns`,default:`1`},{name:`output_format_csv_serialize_tuple_into_separate_columns`,path:`/output-format#output_format_csv_serialize_tuple_into_separate_columns`,default:`1`},{name:`output_format_decimal_trailing_zeros`,path:`/output-format#output_format_decimal_trailing_zeros`,default:`0`},{name:`output_format_float_precision`,path:`/output-format#output_format_float_precision`,default:`0`},{name:`output_format_image_height`,path:`/output-format#output_format_image_height`,default:`1024`},{name:`output_format_image_streaming_animation`,path:`/output-format#output_format_image_streaming_animation`,default:`0`},{name:`output_format_image_terminal_mode`,path:`/output-format#output_format_image_terminal_mode`,default:`\"\"`},{name:`output_format_image_time_divisor_seconds`,path:`/output-format#output_format_image_time_divisor_seconds`,default:`60`},{name:`output_format_image_time_multiplier_seconds`,path:`/output-format#output_format_image_time_multiplier_seconds`,default:`1`},{name:`output_format_image_width`,path:`/output-format#output_format_image_width`,default:`1024`},{name:`output_format_json_array_of_rows`,path:`/output-format#output_format_json_array_of_rows`,default:`0`},{name:`output_format_json_escape_forward_slashes`,path:`/output-format#output_format_json_escape_forward_slashes`,default:`1`},{name:`output_format_json_map_as_array_of_tuples`,path:`/output-format#output_format_json_map_as_array_of_tuples`,default:`0`},{name:`output_format_json_named_tuples_as_objects`,path:`/output-format#output_format_json_named_tuples_as_objects`,default:`1`},{name:`output_format_json_pretty_print`,path:`/output-format#output_format_json_pretty_print`,default:`1`},{name:`output_format_json_quote_64bit_floats`,path:`/output-format#output_format_json_quote_64bit_floats`,default:`0`},{name:`output_format_json_quote_64bit_integers`,path:`/output-format#output_format_json_quote_64bit_integers`,default:`0`},{name:`output_format_json_quote_decimals`,path:`/output-format#output_format_json_quote_decimals`,default:`0`},{name:`output_format_json_quote_denormals`,path:`/output-format#output_format_json_quote_denormals`,default:`0`},{name:`output_format_json_skip_null_value_in_named_tuples`,path:`/output-format#output_format_json_skip_null_value_in_named_tuples`,default:`0`},{name:`output_format_json_validate_utf8`,path:`/output-format#output_format_json_validate_utf8`,default:`0`},{name:`output_format_markdown_escape_special_characters`,path:`/output-format#output_format_markdown_escape_special_characters`,default:`0`},{name:`output_format_msgpack_uuid_representation`,path:`/output-format#output_format_msgpack_uuid_representation`,default:`ext`},{name:`output_format_native_encode_types_in_binary_format`,path:`/output-format#output_format_native_encode_types_in_binary_format`,default:`0`},{name:`output_format_native_use_flattened_dynamic_and_json_serialization`,path:`/output-format#output_format_native_use_flattened_dynamic_and_json_serialization`,default:`0`},{name:`output_format_native_write_json_as_string`,path:`/output-format#output_format_native_write_json_as_string`,default:`0`},{name:`output_format_orc_compression_block_size`,path:`/output-format#output_format_orc_compression_block_size`,default:`262144`},{name:`output_format_orc_compression_method`,path:`/output-format#output_format_orc_compression_method`,default:`zstd`},{name:`output_format_orc_dictionary_key_size_threshold`,path:`/output-format#output_format_orc_dictionary_key_size_threshold`,default:`0`},{name:`output_format_orc_row_index_stride`,path:`/output-format#output_format_orc_row_index_stride`,default:`10000`},{name:`output_format_orc_string_as_string`,path:`/output-format#output_format_orc_string_as_string`,default:`1`},{name:`output_format_orc_writer_time_zone_name`,path:`/output-format#output_format_orc_writer_time_zone_name`,default:`GMT`},{name:`output_format_parallel_formatting`,path:`/output-format#output_format_parallel_formatting`,default:`1`},{name:`output_format_parquet_batch_size`,path:`/output-format#output_format_parquet_batch_size`,default:`1024`},{name:`output_format_parquet_bloom_filter_bits_per_value`,path:`/output-format#output_format_parquet_bloom_filter_bits_per_value`,default:`10.5`},{name:`output_format_parquet_bloom_filter_flush_threshold_bytes`,path:`/output-format#output_format_parquet_bloom_filter_flush_threshold_bytes`,default:`134217728`},{name:`output_format_parquet_compression_method`,path:`/output-format#output_format_parquet_compression_method`,default:`zstd`},{name:`output_format_parquet_data_page_size`,path:`/output-format#output_format_parquet_data_page_size`,default:`1048576`},{name:`output_format_parquet_date_as_uint16`,path:`/output-format#output_format_parquet_date_as_uint16`,default:`0`},{name:`output_format_parquet_datetime_as_uint32`,path:`/output-format#output_format_parquet_datetime_as_uint32`,default:`0`},{name:`output_format_parquet_enum_as_byte_array`,path:`/output-format#output_format_parquet_enum_as_byte_array`,default:`1`},{name:`output_format_parquet_fixed_string_as_fixed_byte_array`,path:`/output-format#output_format_parquet_fixed_string_as_fixed_byte_array`,default:`1`},{name:`output_format_parquet_geometadata`,path:`/output-format#output_format_parquet_geometadata`,default:`1`},{name:`output_format_parquet_max_dictionary_size`,path:`/output-format#output_format_parquet_max_dictionary_size`,default:`1048576`},{name:`output_format_parquet_parallel_encoding`,path:`/output-format#output_format_parquet_parallel_encoding`,default:`1`},{name:`output_format_parquet_row_group_size`,path:`/output-format#output_format_parquet_row_group_size`,default:`1000000`},{name:`output_format_parquet_row_group_size_bytes`,path:`/output-format#output_format_parquet_row_group_size_bytes`,default:`536870912`},{name:`output_format_parquet_string_as_string`,path:`/output-format#output_format_parquet_string_as_string`,default:`1`},{name:`output_format_parquet_wide_integer_as_decimal`,path:`/output-format#output_format_parquet_wide_integer_as_decimal`,default:`0`},{name:`output_format_parquet_write_bloom_filter`,path:`/output-format#output_format_parquet_write_bloom_filter`,default:`1`},{name:`output_format_parquet_write_checksums`,path:`/output-format#output_format_parquet_write_checksums`,default:`1`},{name:`output_format_parquet_write_page_index`,path:`/output-format#output_format_parquet_write_page_index`,default:`1`},{name:`output_format_pretty_color`,path:`/output-format#output_format_pretty_color`,default:`auto`},{name:`output_format_pretty_display_control_characters`,path:`/output-format#output_format_pretty_display_control_characters`,default:`1`},{name:`output_format_pretty_display_footer_column_names`,path:`/output-format#output_format_pretty_display_footer_column_names`,default:`1`},{name:`output_format_pretty_display_footer_column_names_min_rows`,path:`/output-format#output_format_pretty_display_footer_column_names_min_rows`,default:`50`},{name:`output_format_pretty_fallback_to_vertical`,path:`/output-format#output_format_pretty_fallback_to_vertical`,default:`1`},{name:`output_format_pretty_fallback_to_vertical_max_rows_per_chunk`,path:`/output-format#output_format_pretty_fallback_to_vertical_max_rows_per_chunk`,default:`10`},{name:`output_format_pretty_fallback_to_vertical_min_columns`,path:`/output-format#output_format_pretty_fallback_to_vertical_min_columns`,default:`5`},{name:`output_format_pretty_fallback_to_vertical_min_table_width`,path:`/output-format#output_format_pretty_fallback_to_vertical_min_table_width`,default:`250`},{name:`output_format_pretty_glue_chunks`,path:`/output-format#output_format_pretty_glue_chunks`,default:`auto`},{name:`output_format_pretty_grid_charset`,path:`/output-format#output_format_pretty_grid_charset`,default:`UTF-8`},{name:`output_format_pretty_highlight_digit_groups`,path:`/output-format#output_format_pretty_highlight_digit_groups`,default:`1`},{name:`output_format_pretty_highlight_trailing_spaces`,path:`/output-format#output_format_pretty_highlight_trailing_spaces`,default:`1`},{name:`output_format_pretty_max_column_name_width_cut_to`,path:`/output-format#output_format_pretty_max_column_name_width_cut_to`,default:`24`},{name:`output_format_pretty_max_column_name_width_min_chars_to_cut`,path:`/output-format#output_format_pretty_max_column_name_width_min_chars_to_cut`,default:`4`},{name:`output_format_pretty_max_column_pad_width`,path:`/output-format#output_format_pretty_max_column_pad_width`,default:`250`},{name:`output_format_pretty_max_rows`,path:`/output-format#output_format_pretty_max_rows`,default:`1000`},{name:`output_format_pretty_max_value_width`,path:`/output-format#output_format_pretty_max_value_width`,default:`10000`},{name:`output_format_pretty_max_value_width_apply_for_single_value`,path:`/output-format#output_format_pretty_max_value_width_apply_for_single_value`,default:`0`},{name:`output_format_pretty_multiline_fields`,path:`/output-format#output_format_pretty_multiline_fields`,default:`1`},{name:`output_format_pretty_named_tuples_as_json`,path:`/output-format#output_format_pretty_named_tuples_as_json`,default:`1`},{name:`output_format_pretty_named_tuples_as_subcolumns`,path:`/output-format#output_format_pretty_named_tuples_as_subcolumns`,default:`1`},{name:`output_format_pretty_row_numbers`,path:`/output-format#output_format_pretty_row_numbers`,default:`1`},{name:`output_format_pretty_single_large_number_tip_threshold`,path:`/output-format#output_format_pretty_single_large_number_tip_threshold`,default:`1000000`},{name:`output_format_pretty_squash_consecutive_ms`,path:`/output-format#output_format_pretty_squash_consecutive_ms`,default:`50`},{name:`output_format_pretty_squash_max_wait_ms`,path:`/output-format#output_format_pretty_squash_max_wait_ms`,default:`1000`},{name:`output_format_pretty_use_nbsp_for_padding`,path:`/output-format#output_format_pretty_use_nbsp_for_padding`,default:`0`},{name:`output_format_protobuf_nullables_with_google_wrappers`,path:`/output-format#output_format_protobuf_nullables_with_google_wrappers`,default:`0`},{name:`output_format_schema`,path:`/output-format#output_format_schema`,default:`\"\"`},{name:`output_format_sql_insert_include_column_names`,path:`/output-format#output_format_sql_insert_include_column_names`,default:`1`},{name:`output_format_sql_insert_max_batch_size`,path:`/output-format#output_format_sql_insert_max_batch_size`,default:`65409`},{name:`output_format_sql_insert_quote_names`,path:`/output-format#output_format_sql_insert_quote_names`,default:`1`},{name:`output_format_sql_insert_table_name`,path:`/output-format#output_format_sql_insert_table_name`,default:`table`},{name:`output_format_sql_insert_use_replace`,path:`/output-format#output_format_sql_insert_use_replace`,default:`0`},{name:`output_format_sqlite_table_name`,path:`/output-format#output_format_sqlite_table_name`,default:`table`},{name:`output_format_trim_fixed_string`,path:`/output-format#output_format_trim_fixed_string`,default:`0`},{name:`output_format_tsv_crlf_end_of_line`,path:`/output-format#output_format_tsv_crlf_end_of_line`,default:`0`},{name:`output_format_values_escape_quote_with_quote`,path:`/output-format#output_format_values_escape_quote_with_quote`,default:`0`},{name:`output_format_write_statistics`,path:`/output-format#output_format_write_statistics`,default:`1`}],children:[]},{label:`schema_inference_*`,count:4,settings:[{name:`schema_inference_hints`,path:`/schema-inference#schema_inference_hints`,default:`\"\"`},{name:`schema_inference_make_columns_nullable`,path:`/schema-inference#schema_inference_make_columns_nullable`,default:`3`},{name:`schema_inference_make_json_columns_nullable`,path:`/schema-inference#schema_inference_make_json_columns_nullable`,default:`0`},{name:`schema_inference_mode`,path:`/schema-inference#schema_inference_mode`,default:`default`}],children:[]},{label:`show_create_*`,count:2,settings:[{name:`show_create_query_identifier_quoting_rule`,path:`/show-create#show_create_query_identifier_quoting_rule`,default:`when_necessary`},{name:`show_create_query_identifier_quoting_style`,path:`/show-create#show_create_query_identifier_quoting_style`,default:`Backticks`}],children:[]},{label:`type_json_*`,count:5,settings:[{name:`type_json_allow_duplicated_key_with_literal_and_nested_object`,path:`/type-json#type_json_allow_duplicated_key_with_literal_and_nested_object`,default:`1`},{name:`type_json_skip_duplicated_paths`,path:`/type-json#type_json_skip_duplicated_paths`,default:`0`},{name:`type_json_skip_invalid_typed_paths`,path:`/type-json#type_json_skip_invalid_typed_paths`,default:`0`},{name:`type_json_skip_null_typed_paths`,path:`/type-json#type_json_skip_null_typed_paths`,default:`0`},{name:`type_json_use_partial_match_to_skip_paths_by_regexp`,path:`/type-json#type_json_use_partial_match_to_skip_paths_by_regexp`,default:`1`}],children:[]},{label:`Outros`,count:11,settings:[{name:`allow_special_bool_values_inside_variant`,path:`/other#allow_special_bool_values_inside_variant`,default:`0`},{name:`check_conversion_from_numbers_to_enum`,path:`/other#check_conversion_from_numbers_to_enum`,default:`1`},{name:`column_names_for_schema_inference`,path:`/other#column_names_for_schema_inference`,default:`\"\"`},{name:`errors_output_format`,path:`/other#errors_output_format`,default:`CSV`},{name:`insert_distributed_one_random_shard`,path:`/other#insert_distributed_one_random_shard`,default:`0`},{name:`interval_output_format`,path:`/other#interval_output_format`,default:`numeric`},{name:`into_outfile_create_parent_directories`,path:`/other#into_outfile_create_parent_directories`,default:`0`},{name:`json_type_escape_dots_in_keys`,path:`/other#json_type_escape_dots_in_keys`,default:`0`},{name:`max_dynamic_subcolumns_in_json_type_parsing`,path:`/other#max_dynamic_subcolumns_in_json_type_parsing`,default:`auto`},{name:`precise_float_parsing`,path:`/other#precise_float_parsing`,default:`1`},{name:`validate_experimental_and_suspicious_types_inside_nested_types`,path:`/other#validate_experimental_and_suspicious_types_inside_nested_types`,default:`1`}],children:[]}]);const[allGroupKeys]=useState(()=>{const collectGroupKeys=(items,path=[])=>items.flatMap(entry=>{const key=[...path,entry.label].join(`/`);return[key,...collectGroupKeys(entry.children,[...path,entry.label])]});return collectGroupKeys(entries)});const[expandedGroups,setExpandedGroups]=useState(()=>new Set);const[searchTerm,setSearchTerm]=useState(``);const normalizedSearch=searchTerm.trim().toLowerCase();const toPlainSearchTerms=value=>value.replace(/([a-z0-9])([A-Z])/g,`$1 $2`).toLowerCase().split(/[^a-z0-9]+/).filter(term=>term.length>1).map(term=>term.length>3\u0026\u0026term.endsWith(`s`)?term.slice(0,-1):term);const usesWildcard=normalizedSearch.includes(`%`);const plainSearchTerms=toPlainSearchTerms(searchTerm);const isSearching=usesWildcard?normalizedSearch.replaceAll(`%`,``).trim().length>0:plainSearchTerms.length>0;const matchesSearch=value=>{const candidate=value.toLowerCase();if(!isSearching)return true;if(!usesWildcard){const candidateTerms=toPlainSearchTerms(value);return plainSearchTerms.every(searchTerm=>candidateTerms.some(candidateTerm=>candidateTerm.startsWith(searchTerm)))}const parts=normalizedSearch.split(`%`);let position=0;for(let index=0;index\u003cparts.length;index+=1){const part=parts[index];if(!part)continue;const matchPosition=candidate.indexOf(part,position);if(matchPosition\u003c0)return false;if(index===0\u0026\u0026!normalizedSearch.startsWith(`%`)\u0026\u0026matchPosition!==0){return false}position=matchPosition+part.length}const lastPart=parts[parts.length-1];return normalizedSearch.endsWith(`%`)||!lastPart||position===candidate.length};const filterEntry=entry=>{const settings=entry.settings.filter(setting=>matchesSearch(setting.name));const children=entry.children.map(filterEntry).filter(Boolean);const count=settings.length+children.reduce((total,child)=>total+child.count,0);if(!count)return null;return{...entry,count,settings,children}};const filteredEntries=isSearching?entries.map(filterEntry).filter(Boolean):entries;const matchingCount=filteredEntries.reduce((total,entry)=>total+entry.count,0);const allGroupsExpanded=allGroupKeys.length>0\u0026\u0026allGroupKeys.every(key=>expandedGroups.has(key));const toggleGroup=key=>{setExpandedGroups(current=>{const next=new Set(current);if(next.has(key))next.delete(key);else next.add(key);return next})};const toggleAllGroups=()=>{setExpandedGroups(current=>{const shouldCollapse=allGroupKeys.every(key=>current.has(key));return shouldCollapse?new Set:new Set(allGroupKeys)})};const branchPrefix=(continuations,isLast)=>{const prefix=continuations.map(continued=>continued?`│ `:` `).join(``);return`${prefix}${isLast?`└─ `:`├─ `}`};const branch=value=>_jsx(`span`,{\"aria-hidden\":`true`,className:`mint-shrink-0 mint-select-none mint-text-gray-400 dark:mint-text-gray-600`,style:{whiteSpace:`pre`},children:value});const renderGroup=(entry,continuations=[],isLast=false,path=[])=>{const key=[...path,entry.label].join(`/`);const isOpen=isSearching||expandedGroups.has(key);const items=[...entry.settings.map(setting=>({type:`setting`,value:setting})),...entry.children.map(child=>({type:`group`,value:child}))];const countLabel=`${entry.count} ${entry.count===1?`configuração`:`configurações`}`;return _jsxs(`div`,{className:`mint-min-w-max`,children:[_jsxs(`button`,{type:`button`,\"aria-expanded\":isOpen,disabled:isSearching,onClick:()=>toggleGroup(key),className:`mint-flex mint-min-w-max mint-items-baseline mint-whitespace-nowrap mint-text-left`,style:{appearance:`none`,background:`transparent`,border:0,color:`inherit`,cursor:isSearching?`default`:`pointer`,font:`inherit`,lineHeight:`inherit`,padding:0},children:[_jsx(`span`,{\"aria-hidden\":`true`,style:{display:`inline-block`,width:`1rem`},children:isOpen?`▾`:`▸`}),branch(branchPrefix(continuations,isLast)),_jsx(`span`,{className:`mint-font-medium`,children:entry.label}),_jsx(`span`,{className:`mint-ml-3 mint-text-xs mint-text-gray-500 dark:mint-text-gray-400`,children:countLabel})]}),isOpen\u0026\u0026items.map((item,index)=>{const itemIsLast=index===items.length-1;const childContinuations=[...continuations,!isLast];if(item.type===`group`){return renderGroup(item.value,childContinuations,itemIsLast,[...path,entry.label])}return _jsxs(`div`,{className:`mint-grid mint-min-w-max mint-items-start mint-gap-x-3 mint-whitespace-nowrap`,style:{gridTemplateColumns:`44ch max-content`},children:[_jsxs(`span`,{className:`mint-flex mint-min-w-0 mint-items-start`,children:[_jsx(`span`,{\"aria-hidden\":`true`,className:`mint-w-4 mint-shrink-0`}),branch(branchPrefix(childContinuations,itemIsLast)),_jsx(_components.a,{href:`https://clickhouse.com/docs${baseRoute}${item.value.path}`,className:`mint-min-w-0 mint-whitespace-normal mint-no-underline hover:mint-underline`,style:{overflowWrap:`anywhere`},children:item.value.name.split(`_`).map((part,index,parts)=>_jsxs(`span`,{children:[part,index\u003cparts.length-1?`_`:``,index\u003cparts.length-1\u0026\u0026_jsx(`wbr`,{})]},`${part}-${index}`))})]}),item.value.default!==undefined\u0026\u0026_jsxs(`span`,{title:`Valor padrão`,className:`mint-whitespace-nowrap mint-text-gray-500 dark:mint-text-gray-400`,children:[`(padrão: `,item.value.default,`)`]})]},item.value.name)})]},key)};return _jsxs(`div`,{className:`not-prose mint-my-6 mint-w-full`,children:[_jsxs(`div`,{className:`mint-relative mint-w-full`,children:[_jsxs(`svg`,{\"aria-hidden\":`true`,viewBox:`0 0 24 24`,fill:`none`,stroke:`currentColor`,strokeWidth:`2`,strokeLinecap:`round`,strokeLinejoin:`round`,className:`mint-pointer-events-none mint-absolute mint-left-3 mint-h-4 mint-w-4 mint-text-gray-500 dark:mint-text-gray-400`,style:{top:`50%`,transform:`translateY(-50%)`},children:[_jsx(`circle`,{cx:`11`,cy:`11`,r:`8`}),_jsx(`path`,{d:`m21 21-4.3-4.3`})]}),_jsx(`input`,{\"aria-label\":`Buscar configurações`,type:`search`,value:searchTerm,onChange:event=>setSearchTerm(event.target.value),placeholder:`Buscar configurações, ex.: parallel replicas ou %materialized%`,className:`mint-w-full mint-rounded-lg mint-border mint-border-gray-500 mint-bg-gray-50 mint-py-2 mint-pl-9 mint-pr-3 mint-text-sm mint-text-gray-900 placeholder:mint-text-gray-600 focus:mint-border-gray-600 focus:mint-outline-0 focus-visible:mint-outline-0 dark:mint-border-white/30 dark:mint-bg-white/5 dark:mint-text-white dark:placeholder:mint-text-gray-400 dark:focus:mint-border-[#fdff75]`})]}),isSearching\u0026\u0026_jsx(`div`,{className:`mint-mt-2 mint-text-right mint-text-xs mint-text-gray-500 dark:mint-text-gray-400`,children:_jsxs(`span`,{children:[matchingCount,` `,matchingCount===1?`configuração correspondente`:`configurações correspondentes`]})}),_jsxs(`div`,{className:`mint-mt-3 mint-w-full mint-overflow-x-auto mint-rounded-xl mint-border mint-border-gray-200 mint-bg-gray-50/50 mint-px-4 mint-py-3 mint-font-mono mint-text-sm mint-leading-6 dark:mint-border-white/10 dark:mint-bg-transparent`,children:[_jsxs(`div`,{className:`mint-flex mint-min-w-full mint-items-center mint-justify-between mint-gap-4`,children:[_jsx(`div`,{className:`mint-min-w-max mint-font-semibold`,children:`/format-settings`}),_jsxs(`button`,{type:`button`,\"aria-label\":allGroupsExpanded?`Recolher tudo`:`Expandir tudo`,\"aria-pressed\":allGroupsExpanded,disabled:isSearching,onClick:toggleAllGroups,className:`mint-inline-flex mint-shrink-0 mint-items-center mint-gap-1 mint-whitespace-nowrap mint-rounded mint-border-0 mint-bg-transparent mint-px-1 mint-py-0.5 mint-font-sans mint-text-xs mint-font-medium mint-text-gray-600 hover:mint-text-gray-900 focus:mint-outline-0 focus-visible:mint-text-gray-900 disabled:mint-cursor-not-allowed disabled:mint-opacity-50 dark:mint-text-gray-400 dark:hover:mint-text-[#fdff75] dark:focus-visible:mint-text-[#fdff75]`,children:[_jsx(`svg`,{\"aria-hidden\":`true`,viewBox:`0 0 24 24`,fill:`none`,stroke:`currentColor`,strokeWidth:`2`,strokeLinecap:`round`,strokeLinejoin:`round`,className:`mint-h-3 mint-w-3`,children:allGroupsExpanded?_jsx(`path`,{d:`m6 9 6 6 6-6`}):_jsx(`path`,{d:`m9 18 6-6-6-6`})}),_jsx(`span`,{children:allGroupsExpanded?`Recolher tudo`:`Expandir tudo`})]})]}),filteredEntries.length>0?filteredEntries.map((entry,index)=>renderGroup(entry,[],index===filteredEntries.length-1)):_jsx(`div`,{className:`mint-py-2 mint-text-gray-500 dark:mint-text-gray-400`,children:`Nenhuma configuração encontrada`})]})]})};function _createMdxContent(props){const _components={a:`a`,p:`p`,..._provideComponents(),...props.components},{Heading,_MdxComponentBoundary}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!_MdxComponentBoundary)_missingMdxReference(`_MdxComponentBoundary`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`Essas configurações são geradas automaticamente a partir do `,_jsx(_components.a,{href:`https://github.com/ClickHouse/ClickHouse/blob/master/src/Core/FormatFactorySettings.h`,children:`código-fonte`}),`.`]}),`\n`,_jsx(`div`,{id:`browse-format-settings`,children:_jsx(Heading,{level:`2`,id:`explorar-configurações-de-formato`,children:`Explorar configurações de formato`})}),`\n`,_jsx(_MdxComponentBoundary,{name:`FormatSettingsExplorer`,children:_jsx(FormatSettingsExplorer,{href:`/pt-BR/reference/settings/formats`})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{__snippet_galaxyOnClick_xk7ifz,BetaBadge,ExperimentalBadge,FormatSettingsExplorer,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":{"title":"Configurações de formato","sidebarTitle":"Visão geral","slug":"/operations/settings/formats","toc_max_heading_level":2,"description":"Configurações que controlam os formatos de entrada e saída.","doc_type":"reference","href":"/pt-BR/reference/settings/formats"}}},"mdxSourceWithNoJs":null,"noJsSplices":[[165,50554,"()=>null;const BetaBadge=()=>null;const ExperimentalBadge=()=>null;const FormatSettingsExplorer=()=>null;function _creat"]]},"mdxExtracts":{"tableOfContents":[{"title":"Explorar configurações de formato","slug":"explorar-configurações-de-formato","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/b734912855230cc2/_site/customizations/settings-legacy-routes/format-settings.js","/docs/_mintlify/custom/private-7c7dfe99/e07c37962b288c7e/_site/customizations/settings-legacy-routes/mergetree-settings.js","/docs/_mintlify/custom/private-7c7dfe99/2b8fcba9c043bce4/_site/customizations/settings-legacy-routes/server-settings.js","/docs/_mintlify/custom/private-7c7dfe99/20d8f577c04bd763/_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"],"dynamicCss":".mint-pointer-events-none {\n pointer-events: none\n}\n.mint-absolute {\n position: absolute\n}\n.mint-relative {\n position: relative\n}\n.mint-left-3 {\n left: 0.75rem\n}\n.mint-my-6 {\n margin-top: 1.5rem;\n margin-bottom: 1.5rem\n}\n.mint-ml-3 {\n margin-left: 0.75rem\n}\n.mint-mt-2 {\n margin-top: 0.5rem\n}\n.mint-mt-3 {\n margin-top: 0.75rem\n}\n.mint-flex {\n display: flex\n}\n.mint-inline-flex {\n display: inline-flex\n}\n.mint-grid {\n display: grid\n}\n.mint-h-3 {\n height: 0.75rem\n}\n.mint-h-4 {\n height: 1rem\n}\n.mint-w-3 {\n width: 0.75rem\n}\n.mint-w-4 {\n width: 1rem\n}\n.mint-w-full {\n width: 100%\n}\n.mint-min-w-0 {\n min-width: 0px\n}\n.mint-min-w-full {\n min-width: 100%\n}\n.mint-min-w-max {\n min-width: max-content\n}\n.mint-shrink-0 {\n flex-shrink: 0\n}\n.mint-select-none {\n user-select: none\n}\n.mint-items-start {\n align-items: flex-start\n}\n.mint-items-center {\n align-items: center\n}\n.mint-items-baseline {\n align-items: baseline\n}\n.mint-justify-between {\n justify-content: space-between\n}\n.mint-gap-1 {\n gap: 0.25rem\n}\n.mint-gap-4 {\n gap: 1rem\n}\n.mint-gap-x-3 {\n column-gap: 0.75rem\n}\n.mint-overflow-x-auto {\n overflow-x: auto\n}\n.mint-whitespace-normal {\n white-space: normal\n}\n.mint-whitespace-nowrap {\n white-space: nowrap\n}\n.mint-rounded {\n border-radius: 0.25rem\n}\n.mint-rounded-lg {\n border-radius: 0.5rem\n}\n.mint-rounded-xl {\n border-radius: 0.75rem\n}\n.mint-border {\n border-width: 1px\n}\n.mint-border-0 {\n border-width: 0px\n}\n.mint-border-gray-200 {\n --tw-border-opacity: 1;\n border-color: rgb(229 231 235 / var(--tw-border-opacity, 1))\n}\n.mint-border-gray-500 {\n --tw-border-opacity: 1;\n border-color: rgb(107 114 128 / var(--tw-border-opacity, 1))\n}\n.mint-bg-gray-50 {\n --tw-bg-opacity: 1;\n background-color: rgb(249 250 251 / var(--tw-bg-opacity, 1))\n}\n.mint-bg-gray-50\\/50 {\n background-color: rgb(249 250 251 / 0.5)\n}\n.mint-bg-transparent {\n background-color: transparent\n}\n.mint-px-1 {\n padding-left: 0.25rem;\n padding-right: 0.25rem\n}\n.mint-px-4 {\n padding-left: 1rem;\n padding-right: 1rem\n}\n.mint-py-0\\.5 {\n padding-top: 0.125rem;\n padding-bottom: 0.125rem\n}\n.mint-py-2 {\n padding-top: 0.5rem;\n padding-bottom: 0.5rem\n}\n.mint-py-3 {\n padding-top: 0.75rem;\n padding-bottom: 0.75rem\n}\n.mint-pl-9 {\n padding-left: 2.25rem\n}\n.mint-pr-3 {\n padding-right: 0.75rem\n}\n.mint-text-left {\n text-align: left\n}\n.mint-text-right {\n text-align: right\n}\n.mint-font-mono {\n font-family: ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas, \"Liberation Mono\", \"Courier New\", monospace\n}\n.mint-font-sans {\n font-family: ui-sans-serif, system-ui, sans-serif, \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\", \"Noto Color Emoji\"\n}\n.mint-text-sm {\n font-size: 0.875rem;\n line-height: 1.25rem\n}\n.mint-text-xs {\n font-size: 0.75rem;\n line-height: 1rem\n}\n.mint-font-medium {\n font-weight: 500\n}\n.mint-font-semibold {\n font-weight: 600\n}\n.mint-leading-6 {\n line-height: 1.5rem\n}\n.mint-text-gray-400 {\n --tw-text-opacity: 1;\n color: rgb(156 163 175 / var(--tw-text-opacity, 1))\n}\n.mint-text-gray-500 {\n --tw-text-opacity: 1;\n color: rgb(107 114 128 / var(--tw-text-opacity, 1))\n}\n.mint-text-gray-600 {\n --tw-text-opacity: 1;\n color: rgb(75 85 99 / var(--tw-text-opacity, 1))\n}\n.mint-text-gray-900 {\n --tw-text-opacity: 1;\n color: rgb(17 24 39 / var(--tw-text-opacity, 1))\n}\n.mint-no-underline {\n text-decoration-line: none\n}\n.placeholder\\:mint-text-gray-600::placeholder {\n --tw-text-opacity: 1;\n color: rgb(75 85 99 / var(--tw-text-opacity, 1))\n}\n.hover\\:mint-text-gray-900:hover {\n --tw-text-opacity: 1;\n color: rgb(17 24 39 / var(--tw-text-opacity, 1))\n}\n.hover\\:mint-underline:hover {\n text-decoration-line: underline\n}\n.focus\\:mint-border-gray-600:focus {\n --tw-border-opacity: 1;\n border-color: rgb(75 85 99 / var(--tw-border-opacity, 1))\n}\n.focus\\:mint-outline-0:focus {\n outline-width: 0px\n}\n.focus-visible\\:mint-text-gray-900:focus-visible {\n --tw-text-opacity: 1;\n color: rgb(17 24 39 / var(--tw-text-opacity, 1))\n}\n.focus-visible\\:mint-outline-0:focus-visible {\n outline-width: 0px\n}\n.disabled\\:mint-cursor-not-allowed:disabled {\n cursor: not-allowed\n}\n.disabled\\:mint-opacity-50:disabled {\n opacity: 0.5\n}\n.dark\\:mint-border-white\\/10:is(.dark *) {\n border-color: rgb(255 255 255 / 0.1)\n}\n.dark\\:mint-border-white\\/30:is(.dark *) {\n border-color: rgb(255 255 255 / 0.3)\n}\n.dark\\:mint-bg-transparent:is(.dark *) {\n background-color: transparent\n}\n.dark\\:mint-bg-white\\/5:is(.dark *) {\n background-color: rgb(255 255 255 / 0.05)\n}\n.dark\\:mint-text-gray-400:is(.dark *) {\n --tw-text-opacity: 1;\n color: rgb(156 163 175 / var(--tw-text-opacity, 1))\n}\n.dark\\:mint-text-gray-600:is(.dark *) {\n --tw-text-opacity: 1;\n color: rgb(75 85 99 / var(--tw-text-opacity, 1))\n}\n.dark\\:mint-text-white:is(.dark *) {\n --tw-text-opacity: 1;\n color: rgb(255 255 255 / var(--tw-text-opacity, 1))\n}\n.dark\\:placeholder\\:mint-text-gray-400:is(.dark *)::placeholder {\n --tw-text-opacity: 1;\n color: rgb(156 163 175 / var(--tw-text-opacity, 1))\n}\n.dark\\:hover\\:mint-text-\\[\\#fdff75\\]:hover:is(.dark *) {\n --tw-text-opacity: 1;\n color: rgb(253 255 117 / var(--tw-text-opacity, 1))\n}\n.dark\\:focus\\:mint-border-\\[\\#fdff75\\]:focus:is(.dark *) {\n --tw-border-opacity: 1;\n border-color: rgb(253 255 117 / var(--tw-border-opacity, 1))\n}\n.dark\\:focus-visible\\:mint-text-\\[\\#fdff75\\]:focus-visible:is(.dark *) {\n --tw-text-opacity: 1;\n color: rgb(253 255 117 / var(--tw-text-opacity, 1))\n}","subdomain":"private-7c7dfe99","siteName":"ClickHouse Documentation","title":"Configurações de formato - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/reference/settings/formats","matchLevel":1},"ar":{"href":"/ar/reference/settings/formats","matchLevel":1},"es":{"href":"/es/reference/settings/formats","matchLevel":1},"fr":{"href":"/fr/reference/settings/formats","matchLevel":1},"ja":{"href":"/ja/reference/settings/formats","matchLevel":1},"ko":{"href":"/ko/reference/settings/formats","matchLevel":1},"pt-BR":{"href":"/pt-BR/reference/settings/formats","matchLevel":0},"ru":{"href":"/ru/reference/settings/formats","matchLevel":1},"zh":{"href":"/zh/reference/settings/formats","matchLevel":1}}},"originalFileLocation":"pt-BR/reference/settings/formats.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=\"Configurações que controlam os formatos de entrada e saída.\">\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=\"Configurações de formato - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Configurações que controlam os formatos de entrada e saída.\">\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/settings/formats\">\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=Documentation\u0026amp;title=Configura%C3%A7%C3%B5es+de+formato\u0026amp;description=Configura%C3%A7%C3%B5es+que+controlam+os+formatos+de+entrada+e+sa%C3%ADda.\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=f268301551dab194e03ac85304161d4b450f9ef2619388f72fa2b38b764453d7\">\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=\"Configurações de formato - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Configurações que controlam os formatos de entrada e saída.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.app/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Configura%C3%A7%C3%B5es+de+formato\u0026amp;description=Configura%C3%A7%C3%B5es+que+controlam+os+formatos+de+entrada+e+sa%C3%ADda.\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=f268301551dab194e03ac85304161d4b450f9ef2619388f72fa2b38b764453d7\">\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/settings/formats\">\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/settings/formats.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/reference/settings/formats\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/reference/settings/formats\">\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/settings/formats#webpage\",\"url\":\"https://clickhouse.com/docs/pt-BR/reference/settings/formats\",\"name\":\"Configurações de formato\",\"description\":\"Configurações que controlam os formatos de entrada e saída.\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/settings/formats#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/settings/formats#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Configurações\",\"item\":\"https://clickhouse.com/docs/pt-BR/reference/settings/index\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configurações de formato\",\"item\":\"https://clickhouse.com/docs/pt-BR/reference/settings/formats\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/settings/formats#article\",\"headline\":\"Configurações de formato\",\"name\":\"Configurações de formato\",\"description\":\"Configurações que controlam os formatos de entrada e saída.\",\"url\":\"https://clickhouse.com/docs/pt-BR/reference/settings/formats\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/pt-BR/reference/settings/formats#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/settings/formats"}]},{"language":"ar","pages":[{"title":"ar","href":"/ar/reference/settings/formats"}]},{"language":"es","pages":[{"title":"es","href":"/es/reference/settings/formats"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/reference/settings/formats"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/reference/settings/formats"}]},{"language":"ko","pages":[{"title":"ko","href":"/ko/reference/settings/formats"}]},{"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"}]},{"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"},{"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","description":"Configurações de tabela MergeTree do ClickHouse no grupo gerado \"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_*","description":"Configurações de formato do ClickHouse no grupo bool_* gerado.","href":"/pt-BR/reference/settings/formats/bool"},{"title":"configurações de formato date_time_*","sidebarTitle":"date_time_*","description":"Configurações de formato do ClickHouse no grupo date_time_* gerado.","href":"/pt-BR/reference/settings/formats/date-time"},{"title":"configurações de formato format_*","sidebarTitle":"format_*","description":"As configurações de formato do ClickHouse no grupo gerado format_*.","href":"/pt-BR/reference/settings/formats/format"},{"title":"configurações do formato format_avro_*","sidebarTitle":"format_avro_*","description":"Configurações de formato do ClickHouse no grupo gerado format_avro_*.","href":"/pt-BR/reference/settings/formats/format-avro"},{"title":"configurações do formato format_binary_*","sidebarTitle":"format_binary_*","description":"Configurações de formato do ClickHouse no grupo gerado format_binary_*.","href":"/pt-BR/reference/settings/formats/format-binary"},{"title":"configurações do formato format_capn_*","sidebarTitle":"format_capn_*","description":"Configurações de formato do ClickHouse no grupo gerado format_capn_*.","href":"/pt-BR/reference/settings/formats/format-capn"},{"title":"configurações do formato format_csv_*","sidebarTitle":"format_csv_*","description":"Configurações do formato ClickHouse no grupo gerado format_csv_*.","href":"/pt-BR/reference/settings/formats/format-csv"},{"title":"configurações do formato format_custom_*","sidebarTitle":"format_custom_*","description":"Configurações de formato do ClickHouse no grupo gerado format_custom_*.","href":"/pt-BR/reference/settings/formats/format-custom"},{"title":"configurações de formato do format_regexp_*","sidebarTitle":"format_regexp_*","description":"Configurações de formato do ClickHouse no grupo gerado format_regexp_*.","href":"/pt-BR/reference/settings/formats/format-regexp"},{"title":"configurações de formato format_schema_*","sidebarTitle":"format_schema_*","description":"Configurações de formato do ClickHouse no grupo format_schema_* gerado.","href":"/pt-BR/reference/settings/formats/format-schema"},{"title":"configurações do formato format_template_*","sidebarTitle":"format_template_*","description":"Configurações de formato do ClickHouse no grupo gerado format_template_*.","href":"/pt-BR/reference/settings/formats/format-template"},{"title":"configurações de formato input_format_*","sidebarTitle":"input_format_*","description":"Configurações de formato do ClickHouse no grupo gerado de input_format_*.","href":"/pt-BR/reference/settings/formats/input-format"},{"title":"configurações de formato output_format_*","sidebarTitle":"output_format_*","description":"Configurações de formato do ClickHouse no grupo gerado output_format_*.","href":"/pt-BR/reference/settings/formats/output-format"},{"title":"configurações de formato de schema_inference_*","sidebarTitle":"schema_inference_*","description":"Configurações de formato do ClickHouse no grupo gerado schema_inference_*.","href":"/pt-BR/reference/settings/formats/schema-inference"},{"title":"configurações de formato de show_create_*","sidebarTitle":"show_create_*","description":"Configurações de formato do ClickHouse no grupo gerado por show_create_*.","href":"/pt-BR/reference/settings/formats/show-create"},{"title":"configurações de formato de type_json_*","sidebarTitle":"type_json_*","description":"Configurações de formato do ClickHouse no grupo gerado por type_json_*.","href":"/pt-BR/reference/settings/formats/type-json"},{"title":"Outras configurações de formato","sidebarTitle":"Outros","description":"Configurações de formato do ClickHouse no grupo gerado \"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/settings/formats"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/reference/settings/formats"}]}]},"basePath":"","title":"Configurações de formato - ClickHouse Documentation","buildId":"dpl_Acry4NrQAgjcikyFgVE2eJ7XQCAv","deploymentId":"dpl_Acry4NrQAgjcikyFgVE2eJ7XQCAv","dynamics":[],"chunks":[]}
