{"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.6.1.2455","airgap_keeper_tag":"26.2.1.918","airgap_operator_tag":"1.23255.1","airgap_cr_helm_tag":"1.14.3","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":""},"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":"6afcd0298bb4991509c8693a","clientVersion":"0.0.4177","searchFilterCounts":[{"language":"en","tag":"Databases","count":1813},{"language":"ja","tag":"データベース","count":1792},{"language":"pt-BR","tag":"Bancos de dados","count":1792},{"language":"zh","tag":"数据库","count":1792},{"language":"ar","tag":"قواعد البيانات","count":1791},{"language":"es","tag":"Bases de datos","count":1791},{"language":"fr","tag":"Bases de données","count":1791},{"language":"ko","tag":"데이터베이스","count":1791},{"language":"ru","tag":"Базы данных","count":1791},{"language":"en","tag":"Reference","count":1582},{"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":"Products","count":653},{"language":"es","tag":"Configuración","count":531},{"language":"ja","tag":"設定","count":531},{"language":"en","tag":"Settings","count":512},{"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":"ar","tag":"المنتجات","count":494},{"language":"es","tag":"Productos","count":494},{"language":"fr","tag":"Produits","count":494},{"language":"ja","tag":"製品","count":494},{"language":"ko","tag":"제품","count":494},{"language":"pt-BR","tag":"Produtos","count":494},{"language":"ru","tag":"Продукты","count":494},{"language":"zh","tag":"产品","count":494},{"language":"en","tag":"ClickHouse Observability","count":487},{"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":322},{"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":"Guides","count":265},{"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":243},{"language":"ar","tag":"ClickHouse Cloud","count":236},{"language":"es","tag":"ClickHouse Cloud","count":236},{"language":"fr","tag":"ClickHouse Cloud","count":236},{"language":"ja","tag":"ClickHouse Cloud","count":236},{"language":"ko","tag":"ClickHouse Cloud","count":236},{"language":"pt-BR","tag":"ClickHouse Cloud","count":236},{"language":"ru","tag":"ClickHouse Cloud","count":236},{"language":"zh","tag":"ClickHouse Cloud","count":236},{"language":"ar","tag":"أدلة إرشادية","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":"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":"Products","count":140},{"language":"default","tag":"ClickHouse Cloud","count":140},{"language":"default","tag":"Cloud API","count":94},{"language":"default","tag":"API reference","count":94},{"language":"default","tag":"ClickHouse Private","count":46},{"language":"default","tag":"Service","count":34},{"language":"default","tag":"Organization","count":31},{"language":"default","tag":"ClickStack","count":31},{"language":"default","tag":"How-To Guides","count":20},{"language":"default","tag":"Postgres","count":18}],"searchSettings":{"maxResults":1}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"github-push-net-diff","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"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":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","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/9ce922f719fc2597/_site/styles.css"},{"filePath":"snippets/components/Badges/badges_styles.css","content":".betaBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.betaBadge::before{content:\"β\";flex:0 0 auto;margin-right:8px;font-size:1rem;font-weight:600;line-height:1}a.betaBadge{color:#1D4ED8!important;text-decoration:none!important}.dark .betaBadge{background-color:#1E3A6B;color:#93C5FD}.dark a.betaBadge{color:#93C5FD!important;text-decoration:none!important}.ClickHouseSupportedBadge{background-color:#faff69;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#161517;display:inline-flex;margin-right:5px;font-size:0.875rem}.ClickHouseSupportedIcon{margin-right:8px}.ClickHouseSupportedIcon svg path{fill:#282828}.ClickHouseSupportedBadge a{color:black}.dark .ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.dark .ClickHouseSupportedBadge a{color:#161517}.dark .ClickHouseSupportedIcon svg path{fill:#161517}.cloudNotSupportedBadge{background-color:#F6E5FF;color:#660099;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.cloudNotSupportedIcon{margin-right:8px}a.cloudNotSupportedBadge{color:#660099!important;text-decoration:none!important}.cloudNotSupportedIcon svg path{stroke:#660099}.dark .cloudNotSupportedBadge{background-color:#33004D;color:#EECCFF}.dark a.cloudNotSupportedBadge{color:#EECCFF!important;text-decoration:none!important}.dark .cloudNotSupportedIcon svg path{stroke:#EECCFF}.cloudBadge{background-color:#DAE6FC;color:#061D48;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .cloudBadge{background-color:#061D48;color:#DAE6FC}.cloudIcon{margin-right:8px}.cloudIcon svg path{stroke:#061D48}.dark .cloudIcon svg path{stroke:#DAE6FC}.CommunityMaintainedBadge{background-color:#69afff;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.CommunityMaintainedIcon{margin-right:8px}.CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.CommunityMaintainedBadge a{color:#69afff}.CommunityMaintainedBadge svg path{color:#69afff}.dark .CommunityMaintainedBadge{background-color:#69afff;color:#ffffff}.dark .CommunityMaintainedBadge a{color:#ffffff}.dark .CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.deprecatedBadge{background-color:#DFDFDF;color:#53575F;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.deprecatedIcon{margin-right:8px}.deprecatedBadge a{color:inherit}.dark .deprecatedBadge{background-color:#414141;color:#E6E7E9}.dark .deprecatedBadge a{color:inherit}.deprecatedIcon svg path{stroke:#53575F}.dark .deprecatedIcon svg path{stroke:#E6E7E9}.enterprisePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.enterprisePlanFeatureContainer p{margin:0;padding:0}.enterprisePlanFeatureBadge{background-color:#008A0B;border-style:solid;border:1px;border-color:#437EEF;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .enterprisePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .enterprisePlanFeatureBadge{background-color:#99FFA1;color:#1F1F1C}.experimentalBadge{background-color:#F3E8FF;border-radius:16px;color:#6D28D9;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.experimentalIcon{margin-right:8px}a.experimentalBadge{color:#6D28D9!important;text-decoration:none!important}.dark .experimentalBadge{background-color:#3B1D6B;color:#D8B4FE}.dark a.experimentalBadge{color:#D8B4FE!important;text-decoration:none!important}.experimentalIcon svg path{stroke:#6D28D9}.dark .experimentalIcon svg path{stroke:#D8B4FE}.PartnerBadge{background-color:#990073;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.PartnerBadgeIcon{margin-right:8px}.PartnerBadgeIcon svg path{fill:#fbc9ef;stroke:#990073}.PartnerBadge a{color:#990073}.PartnerBadge svg path{color:#990073}.dark .PartnerBadge{background-color:#990073;color:#fbeff8}.dark .PartnerBadge a{color:#fbeff8}.dark .PartnerBadgeIcon svg path{fill:#990073;stroke:#fbeff8}.privatePreviewBadge{background-color:#FEF3C7;color:#B45309;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .privatePreviewBadge{background-color:#4B3410;color:#FCD34D}.privatePreviewIcon{margin-right:8px}.privatePreviewIcon svg path{stroke:#B45309}.dark .privatePreviewIcon svg path{stroke:#FCD34D}.publicPreviewBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .publicPreviewBadge{background-color:#1E3A6B;color:#93C5FD}.scalePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.scalePlanFeatureContainer p{margin:0;padding:0}.scalePlanFeatureBadge{background-color:#1D64EC;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .scalePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .scalePlanFeatureBadge{background-color:#1D64EC;color:#FFFFFF}"},{"filePath":"snippets/components/ClickStackAnimation/ClickStackAnimation.css","content":".clickstack-animation-wrapper{width:100%;max-width:max-content;transition:opacity 0.3s ease}.clickstack-animation-inner{transform-origin:top left}.clickstack-grid{display:grid;width:537px;height:537px;grid-template-columns:repeat(3, 1fr);grid-template-rows:repeat(3, 1fr)}.clickstack-grid-item{position:relative;display:flex;align-items:center;justify-content:center}.clickstack-grid-column{display:flex;flex-direction:column;align-items:center}.clickstack-icon-box{display:flex;width:4rem;height:4rem;align-items:center;justify-content:center;border-radius:0.375rem;padding:1rem;flex-shrink:0;border:1px solid rgba(113, 113, 122, 0.8);background-color:#171717}.clickstack-svg-absolute{position:absolute}.clickstack-svg-left-center{left:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-right-center{right:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-bottom-left{bottom:50%;left:50%;transform:translateY(-2rem)}.clickstack-svg-bottom-right{bottom:50%;right:50%;transform:translateY(-2rem)}.clickstack-logo-container{position:relative}.clickstack-logo-glow{position:absolute;inset:0;z-index:0;animation:fadeInOut 3s ease-in-out infinite;background-color:rgba(250, 255, 105, 0.6);filter:blur(40px)}.clickstack-logo-box{position:absolute;inset:0;z-index:10;display:flex;border-radius:0.5rem;border:2px solid #faff69;background-color:#262626;background-image:linear-gradient(to bottom right, rgba(250, 255, 105, 0.2), rgba(250, 255, 105, 0.4))}.clickstack-logo-svg{margin:auto}@keyframes fadeInOut{0%,100%{opacity:0.3}50%{opacity:0.8}}:is(.light) .clickstack-logo-glow{display:none}:is(.light) .clickstack-logo-box{border-color:#faff69;background-color:#000000;background-image:none}.clickstack-line-bg{stroke:#414141}.clickstack-line-animated{stroke:#faff69}:is(.light) .clickstack-line-bg{stroke:#d4d4d8}:is(.light) .clickstack-line-animated{stroke:#a1a1aa}@media (max-width: 767px){.clickstack-animation-wrapper{max-width:400px}.clickstack-grid{width:400px;height:400px}}"}],"page":{"pagePath":"ru/concepts/features/operations/update","slug":"/ru/concepts/features/operations/update","pageMetadata":{"slug":"/updating-data","title":"Обновление данных","sidebarTitle":"Обзор","description":"Обновление данных: содержание","keywords":["обновление","обновление данных"],"doc_type":"landing-page","href":"/ru/concepts/features/operations/update/index"},"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: \"Обновление данных: содержание\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,p:`p`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Table}=_components;if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`В этом разделе документации вы узнаете, как обновлять данные.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Страница`}),_jsx(_components.th,{children:`Описание`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/ru/concepts/features/operations/update/overview`,children:`Работа с обновлениями`})}),_jsx(_components.td,{children:`Содержит обзор различий в обновлении данных в ClickHouse и OLTP-базах данных, а также различных методов, доступных в ClickHouse.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/ru/concepts/features/operations/update/replacing-merge-tree`,children:`Работа с ReplacingMergeTree`})}),_jsx(_components.td,{children:`Узнайте, как обновлять данные с помощью ReplacingMergeTree.`})]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"slug":"/updating-data","title":"Обновление данных","sidebarTitle":"Обзор","description":"Обновление данных: содержание","keywords":["обновление","обновление данных"],"doc_type":"landing-page","href":"/ru/concepts/features/operations/update/index"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/private-7c7dfe99/f11c6dde2c89bd05/_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/dce387fc81a6edfe/_site/customizations/custom-footer.js","/docs/_mintlify/custom/private-7c7dfe99/240e3ba1823c3bae/_site/customizations/galaxy.js","/docs/_mintlify/custom/private-7c7dfe99/c00e6cbded147615/_site/customizations/inkeep-init.js","/docs/_mintlify/custom/private-7c7dfe99/ad7415752a665282/_site/customizations/kapa-init.js","/docs/_mintlify/custom/private-7c7dfe99/4b6201cbf0ed537b/_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/12d3dce08bc08c9a/_site/customizations/settings-legacy-routes/format-settings.js","/docs/_mintlify/custom/private-7c7dfe99/715db8995ae06543/_site/customizations/settings-legacy-routes/mergetree-settings.js","/docs/_mintlify/custom/private-7c7dfe99/768b733920354bca/_site/customizations/settings-legacy-routes/server-settings.js","/docs/_mintlify/custom/private-7c7dfe99/0d81a9808360f8e6/_site/customizations/settings-legacy-routes/session-settings.js","/docs/_mintlify/custom/private-7c7dfe99/23432dedeeb54e07/_site/customizations/tab-nav.js","/docs/_mintlify/custom/private-7c7dfe99/5c7ce50607c95a70/_site/customizations/webterminal.js","/docs/_mintlify/custom/private-7c7dfe99/5e0b81ad15d8ede0/_site/customizations/cloud-sidebar-ad.js","/docs/_mintlify/custom/private-7c7dfe99/f017ff835af2f729/_site/customizations/section-ticker.js","/docs/_mintlify/custom/private-7c7dfe99/53fc41cb46bfef11/_site/customizations/clickstack-availability.js"],"subdomain":"private-7c7dfe99","siteName":"ClickHouse Documentation","title":"Обновление данных - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/concepts/features/operations/update/index","matchLevel":1},"ar":{"href":"/ar/concepts/features/operations/update/index","matchLevel":1},"es":{"href":"/es/concepts/features/operations/update/index","matchLevel":1},"fr":{"href":"/fr/concepts/features/operations/update/index","matchLevel":1},"ja":{"href":"/ja/concepts/features/operations/update/index","matchLevel":1},"ko":{"href":"/ko/concepts/features/operations/update/index","matchLevel":1},"pt-BR":{"href":"/pt-BR/concepts/features/operations/update/index","matchLevel":1},"ru":{"href":"/ru/concepts/features/operations/update/index","matchLevel":2},"zh":{"href":"/zh/concepts/features/operations/update/index","matchLevel":1}}},"originalFileLocation":"ru/concepts/features/operations/update/index.mdx","locale":"ru"},"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=\"Обновление данных: содержание\">\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=\"Обновление данных - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Обновление данных: содержание\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://clickhouse.com/docs/ru/concepts/features/operations/update\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5\u0026amp;title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5+%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85\u0026amp;description=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5+%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85%3A+%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B0%D0%BD%D0%B8%D0%B5\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=0f9e1d7fe0919a0d9ef794f65c37f3bac4da3ca2b09b2b5e5cc2adef4721ddbe\">\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=\"Обновление данных - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Обновление данных: содержание\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5\u0026amp;title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5+%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85\u0026amp;description=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5+%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85%3A+%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B0%D0%BD%D0%B8%D0%B5\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=0f9e1d7fe0919a0d9ef794f65c37f3bac4da3ca2b09b2b5e5cc2adef4721ddbe\">\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/ru/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/ru/concepts/features/operations/update.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/concepts/features/operations/update\">\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/ru/concepts/features/operations/update#webpage\",\"url\":\"https://clickhouse.com/docs/ru/concepts/features/operations/update\",\"name\":\"Обновление данных\",\"description\":\"Обновление данных: содержание\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/ru/concepts/features/operations/update#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/ru/concepts/features/operations/update#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Основные понятия ClickHouse\",\"item\":\"https://clickhouse.com/docs/ru/concepts/features\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Операции\",\"item\":\"https://clickhouse.com/docs/ru/concepts/features/operations/background-queries\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Обновление данных\",\"item\":\"https://clickhouse.com/docs/ru/concepts/features/operations/update\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/ru/concepts/features/operations/update#article\",\"headline\":\"Обновление данных\",\"name\":\"Обновление данных\",\"description\":\"Обновление данных: содержание\",\"url\":\"https://clickhouse.com/docs/ru/concepts/features/operations/update\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/ru/concepts/features/operations/update#webpage\"},\"keywords\":\"обновление, обновление данных\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"},\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"}}]}\u003c/script>","agentPointerHref":"/docs/ru/concepts/features/operations/update.md","siteName":"ClickHouse Documentation","nav":{"global":null,"languages":[{"language":"en","pages":[{"title":"en","href":"/concepts/features/operations/update"}]},{"language":"ar","pages":[{"title":"ar","href":"/ar/concepts/features/operations/update"}]},{"language":"es","pages":[{"title":"es","href":"/es/concepts/features/operations/update"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/concepts/features/operations/update"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/concepts/features/operations/update"}]},{"language":"ko","pages":[{"title":"ko","href":"/ko/concepts/features/operations/update"}]},{"language":"pt-BR","pages":[{"title":"pt-BR","href":"/pt-BR/concepts/features/operations/update"}]},{"language":"ru","tabs":[{"tab":"Главная","pages":[{"title":"Главная","href":"/ru"}]},{"tab":"Базы данных","menu":[{"item":"ClickHouse","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse.svg","href":"#"},{"item":"Get started","pages":[{"group":"Get started","icon":"/images/menu-icon-lightning.svg","pages":[{"title":"Начало работы с ClickHouse","sidebarTitle":"Обзор","href":"/ru/get-started"},{"group":"Быстрый старт","expanded":false,"pages":[{"sidebarTitle":"Обзор быстрого старта","title":"Обзор руководств по быстрому старту","mode":"custom","href":"/ru/get-started/quickstarts/home"},{"group":"Все сценарии использования","expanded":false,"pages":[{"sidebarTitle":"Быстрый старт в Cloud","title":"Быстрый старт с ClickHouse Cloud","href":"/ru/get-started/setup/cloud"},{"sidebarTitle":"Как получить сведения о подключении к Cloud","title":"Как получить сведения о подключении к Cloud","href":"/ru/get-started/quickstarts/obtain-your-cloud-connection-details"},{"sidebarTitle":"Вставка данных в ClickHouse Cloud с помощью clickhouse-client","title":"Вставка данных в ClickHouse Cloud с помощью clickhouse-client","href":"/ru/get-started/quickstarts/insert-data-using-clickhouse-client"},{"sidebarTitle":"Создание таблиц в ClickHouse","title":"Создание таблиц в ClickHouse","href":"/ru/get-started/quickstarts/creating-tables"},{"sidebarTitle":"Выборка данных ClickHouse","title":"Выборка данных ClickHouse","href":"/ru/get-started/quickstarts/writing-queries"},{"sidebarTitle":"Создайте первую таблицу MergeTree","title":"Создайте первую таблицу MergeTree","href":"/ru/get-started/quickstarts/create-your-first-mergetree-table"}]},{"group":"Аналитика в реальном времени","expanded":false,"pages":[{"sidebarTitle":"Создайте свое первое materialized view","title":"Создайте свое первое materialized view","href":"/ru/get-started/quickstarts/create-your-first-materialized-view"},{"sidebarTitle":"Создайте первую проекцию","title":"Создайте первую проекцию","href":"/ru/get-started/quickstarts/create-your-first-projection"}]},{"group":"Хранилище данных","expanded":false,"pages":[{"sidebarTitle":"Как подключить каталог Iceberg в ClickHouse Cloud","title":"Как подключить каталог Iceberg в ClickHouse Cloud","href":"/ru/get-started/quickstarts/connect-your-iceberg-catalog"},{"sidebarTitle":"Обновление и удаление данных ClickHouse","title":"Обновление и удаление данных ClickHouse","href":"/ru/get-started/quickstarts/mutations"}]},{"group":"Обсервабилити","expanded":false,"pages":[{"sidebarTitle":"Работа с типом Map в ClickHouse","title":"Работа с типом Map в ClickHouse","href":"/ru/get-started/quickstarts/working-with-the-map-type"}]}]},{"group":"Introduction","expanded":true,"pages":[{"sidebarTitle":"Что такое ClickHouse?","title":"Что такое ClickHouse?","href":"/ru/get-started/about/intro"},{"sidebarTitle":"Почему ClickHouse такой быстрый?","title":"Почему ClickHouse такой быстрый?","href":"/ru/get-started/about/why-clickhouse-is-so-fast"},{"sidebarTitle":"Почему ClickHouse уникален?","title":"Отличительные особенности ClickHouse","href":"/ru/get-started/about/distinctive-features"}]},{"group":"Use cases","expanded":true,"pages":[{"title":"Сценарии использования","sidebarTitle":"Обзор","href":"/ru/get-started/use-cases/overview"},{"title":"Real-time аналитика","sidebarTitle":"Real-time аналитика","href":"/ru/get-started/use-cases/real-time-analytics"},{"title":"Обсервабилити","sidebarTitle":"Обсервабилити","href":"/ru/get-started/use-cases/observability"},{"title":"Хранилище данных","sidebarTitle":"Хранилище данных","href":"/ru/get-started/use-cases/data-warehousing"},{"title":"Агентная аналитика","sidebarTitle":"Агентная аналитика","href":"/ru/get-started/use-cases/agentic-analytics"}]},{"sidebarTitle":"Режимы развертывания","title":"Режимы развертывания","href":"/ru/get-started/about/deployment-modes"}]},{"group":"Setup","icon":"/images/menu-icon-gear.svg","expanded":true,"pages":[{"sidebarTitle":"Установка","title":"Инструкция по установке","href":"/ru/get-started/setup/install"},{"sidebarTitle":"Быстрый старт в Cloud","title":"Быстрый старт с ClickHouse Cloud","href":"/ru/get-started/setup/cloud"},{"group":"Self-managed","expanded":true,"pages":[{"title":"Установка в самоуправляемой среде","sidebarTitle":"Обзор","href":"/ru/get-started/setup/self-managed/overview"},{"group":"Local development","pages":[{"sidebarTitle":"Быстрая установка","title":"Быстрая установка","href":"/ru/get-started/setup/self-managed/quick-install"},{"sidebarTitle":"clickhousectl (CLI)","title":"Установка с помощью ClickHouse CLI","href":"/ru/get-started/setup/self-managed/clickhousectl"},{"sidebarTitle":"Docker","title":"Установка ClickHouse с помощью Docker","href":"/ru/get-started/setup/self-managed/docker"},{"sidebarTitle":"Сборки из исходного кода и CI","title":"Сборки из исходного кода и CI","href":"/ru/get-started/setup/self-managed/advanced"}]},{"group":"Production server","pages":[{"sidebarTitle":"Debian/Ubuntu","title":"Установка ClickHouse в Debian/Ubuntu","href":"/ru/get-started/setup/self-managed/debian-ubuntu"},{"sidebarTitle":"Redhat/CentOS","title":"Установка ClickHouse в RPM-дистрибутивах Linux","href":"/ru/get-started/setup/self-managed/redhat"},{"sidebarTitle":"NixOS","title":"Установка ClickHouse в NixOS","href":"/ru/get-started/setup/self-managed/nixos"},{"sidebarTitle":"Другие дистрибутивы Linux","title":"Установка ClickHouse из архивов tgz","href":"/ru/get-started/setup/self-managed/other-linux"}]}]}]},{"group":"Sample datasets","icon":"/images/menu-icon-database.svg","expanded":true,"pages":[{"sidebarTitle":"Обзор","title":"Руководства и примеры наборов данных","href":"/ru/get-started/sample-datasets/index"},{"sidebarTitle":"Песочница ClickHouse","title":"Песочница ClickHouse","href":"/ru/get-started/sample-datasets/playground"},{"group":"Benchmarks","pages":[{"sidebarTitle":"бенчмарк больших данных AMPLab","title":"Бенчмарк больших данных AMPLab","href":"/ru/get-started/sample-datasets/amplab-benchmark"},{"sidebarTitle":"Бенчмарк Brown University","title":"Бенчмарк Brown University","href":"/ru/get-started/sample-datasets/brown-benchmark"},{"sidebarTitle":"Логи кликов Criteo, 1 ТБ","title":"Терабайт логов кликов от Criteo","href":"/ru/get-started/sample-datasets/criteo"},{"title":"Join Order Benchmark (JOB)","sidebarTitle":"JOB","href":"/ru/get-started/sample-datasets/job"},{"sidebarTitle":"Star Schema Benchmark","title":"Star Schema Benchmark (SSB, 2009)","href":"/ru/get-started/sample-datasets/star-schema"},{"title":"TPC-DS (2012)","sidebarTitle":"TPC-DS","href":"/ru/get-started/sample-datasets/tpcds"},{"title":"TPC-H (1999)","sidebarTitle":"TPC-H","href":"/ru/get-started/sample-datasets/tpch"}]},{"group":"Vector search \u0026 embeddings","pages":[{"sidebarTitle":"набор данных dbpedia","title":"набор данных dbpedia","href":"/ru/get-started/sample-datasets/dbpedia"},{"sidebarTitle":"Датасет для векторного поиска по Hacker News","title":"Датасет для векторного поиска по Hacker News","href":"/ru/get-started/sample-datasets/hacker-news-vector-search"},{"sidebarTitle":"Набор данных Laion-400M","title":"Набор данных Laion-400M","href":"/ru/get-started/sample-datasets/laion"},{"sidebarTitle":"Датасет LAION 5B","title":"Датасет LAION 5B","href":"/ru/get-started/sample-datasets/laion5b"}]},{"group":"Web \u0026 social analytics","pages":[{"sidebarTitle":"Отзывы покупателей Amazon","title":"Отзывы покупателей Amazon","href":"/ru/get-started/sample-datasets/amazon-reviews"},{"sidebarTitle":"Обезличенная веб-аналитика","title":"Обезличенная веб-аналитика","href":"/ru/get-started/sample-datasets/anon-web-analytics-metrica"},{"sidebarTitle":"Репозиторий GitHub","title":"Запросы в ClickHouse с использованием данных GitHub","href":"/ru/get-started/sample-datasets/github"},{"sidebarTitle":"События GitHub","title":"Набор данных о событиях GitHub","href":"/ru/get-started/sample-datasets/github-events"},{"sidebarTitle":"Hacker News","title":"Набор данных Hacker News","href":"/ru/get-started/sample-datasets/hacker-news"},{"sidebarTitle":"Stack Overflow","title":"Анализ данных Stack Overflow с помощью ClickHouse","href":"/ru/get-started/sample-datasets/stackoverflow"},{"sidebarTitle":"Дизлайки YouTube","title":"Набор данных YouTube о дизлайках","href":"/ru/get-started/sample-datasets/youtube-dislikes"}]},{"group":"Geo \u0026 location","pages":[{"sidebarTitle":"Базовые станции сотовой связи","title":"Геопространственный анализ на примере набора данных о базовых станциях сотовой связи","href":"/ru/get-started/sample-datasets/cell-towers"},{"sidebarTitle":"Foursquare OS Places","title":"Набор данных Foursquare OS Places","href":"/ru/get-started/sample-datasets/foursquare-os-places"},{"sidebarTitle":"Данные о такси Нью-Йорка","title":"Геопространственный анализ на наборе данных о такси Нью-Йорка","href":"/ru/get-started/sample-datasets/nyc-taxi"}]},{"group":"Time series \u0026 sensors","pages":[{"sidebarTitle":"Данные с экологических датчиков","title":"Данные с экологических датчиков","href":"/ru/get-started/sample-datasets/environmental-sensors"},{"sidebarTitle":"NOAA Global Historical Climatology Network ","title":"NOAA Global Historical Climatology Network","href":"/ru/get-started/sample-datasets/noaa"},{"sidebarTitle":"Исторические датасеты о погоде Тайваня","title":"Исторические датасеты о погоде Тайваня","href":"/ru/get-started/sample-datasets/tw-weather"},{"sidebarTitle":"WikiStat","title":"WikiStat","href":"/ru/get-started/sample-datasets/wikistat"}]},{"group":"Public records \u0026 open data","pages":[{"sidebarTitle":"Открытые данные COVID-19","title":"Открытые данные COVID-19","href":"/ru/get-started/sample-datasets/covid19"},{"sidebarTitle":"Набор данных New York Public Library \"what's on the menu?\"","title":"Набор данных New York Public Library \"What's on the Menu?\"","href":"/ru/get-started/sample-datasets/menus"},{"sidebarTitle":"Данные о жалобах NYPD","title":"Данные о жалобах NYPD","href":"/ru/get-started/sample-datasets/nypd-complaint-data"},{"sidebarTitle":"Данные OnTime об авиарейсах","title":"OnTime","href":"/ru/get-started/sample-datasets/ontime"},{"sidebarTitle":"Цены на недвижимость в Великобритании","title":"Аналитические запросы к данным о ценах на недвижимость в Великобритании","href":"/ru/get-started/sample-datasets/uk-price-paid"}]}]},{"group":"Migrate","icon":"/images/caret-double-right.svg","expanded":true,"pages":[{"sidebarTitle":"Обзор","title":"Перенос данных в ClickHouse","href":"/ru/get-started/migrate/overview"},{"group":"PostgreSQL","pages":[{"title":"Сравнение PostgreSQL и ClickHouse","sidebarTitle":"Обзор","href":"/ru/get-started/migrate/postgres/overview"},{"group":"Migration guide","pages":[{"title":"Миграция данных","sidebarTitle":"Часть 1","href":"/ru/get-started/migrate/postgres/migration-guide/migration-guide-part1"},{"title":"Переписывание запросов PostgreSQL","sidebarTitle":"Часть 2","href":"/ru/get-started/migrate/postgres/migration-guide/migration-guide-part2"},{"title":"Приёмы моделирования данных","sidebarTitle":"Часть 3","href":"/ru/get-started/migrate/postgres/migration-guide/migration-guide-part3"}]},{"title":"Приложение","href":"/ru/get-started/migrate/postgres/appendix"}]},{"group":"BigQuery","pages":[{"title":"Сравнение BigQuery и ClickHouse Cloud","sidebarTitle":"Обзор","href":"/ru/get-started/migrate/bigquery/overview"},{"title":"Миграция из BigQuery в ClickHouse Cloud","sidebarTitle":"Руководство по миграции","href":"/ru/get-started/migrate/bigquery/migrating-to-clickhouse-cloud"},{"sidebarTitle":"Загрузка данных","title":"Загрузка данных из BigQuery в ClickHouse","href":"/ru/get-started/migrate/bigquery/loading-data"}]},{"group":"Snowflake","pages":[{"sidebarTitle":"Обзор","title":"Миграция из Snowflake в ClickHouse","href":"/ru/get-started/migrate/snowflake/overview"},{"sidebarTitle":"Руководство по миграции","title":"Миграция из Snowflake в ClickHouse","href":"/ru/get-started/migrate/snowflake/migration-guide"},{"sidebarTitle":"Справочник по переводу SQL","title":"Переход с Snowflake на ClickHouse","href":"/ru/get-started/migrate/snowflake/sql-translation-reference"}]},{"group":"Elasticsearch","pages":[{"sidebarTitle":"Обзор","title":"Миграция с Elasticsearch на ClickHouse","href":"/ru/get-started/migrate/elastic/overview"}]},{"group":"Redshift","pages":[{"sidebarTitle":"Обзор","title":"Сравнение ClickHouse Cloud и Amazon Redshift","href":"/ru/get-started/migrate/redshift/overview"},{"sidebarTitle":"Руководство по миграции","title":"Руководство по миграции с Amazon Redshift в ClickHouse","href":"/ru/get-started/migrate/redshift/migration-guide"},{"sidebarTitle":"Справочник по переводу SQL","title":"Руководство по переводу SQL из Amazon Redshift в ClickHouse","href":"/ru/get-started/migrate/redshift/sql-translation-reference"}]},{"group":"OSS to Cloud","pages":[{"sidebarTitle":"Использование remoteSecure","title":"Миграция между самоуправляемым ClickHouse и ClickHouse Cloud с помощью remoteSecure","href":"/ru/get-started/migrate/oss-to-cloud/clickhouse-to-cloud"},{"sidebarTitle":"Использование BACKUP и RESTORE","title":"Миграция из самоуправляемого ClickHouse в ClickHouse Cloud с помощью команд BACKUP","href":"/ru/get-started/migrate/oss-to-cloud/oss-to-cloud-backup-restore"}]},{"group":"Other methods","pages":[{"sidebarTitle":"Использование clickhouse-local","title":"Миграция в ClickHouse с использованием clickhouse-local","href":"/ru/get-started/migrate/other-methods/clickhouse-local-etl"},{"sidebarTitle":"Использование стороннего ETL-инструмента","title":"Использование стороннего ETL-инструмента","href":"/ru/get-started/migrate/other-methods/etl-tool-to-clickhouse"},{"title":"Перенос данных из облачного объектного хранилища в ClickHouse Cloud","href":"/ru/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]}]},{"item":"Руководства","pages":[{"title":"Руководства","href":"/ru/guides/clickhouse"}]},{"item":"Основные понятия","pages":[{"title":"Концепции","sidebarTitle":"Обзор","mode":"wide","href":"/ru/concepts"},{"group":"Основы","expanded":true,"pages":[{"title":"Основные концепции","mode":"wide","href":"/ru/concepts/core-concepts/index"},{"sidebarTitle":"Глоссарий","title":"Глоссарий","mode":"wide","href":"/ru/concepts/core-concepts/glossary"},{"title":"Части таблицы","href":"/ru/concepts/core-concepts/parts"},{"title":"Партиции таблицы","href":"/ru/concepts/core-concepts/partitions"},{"title":"Слияние частей","href":"/ru/concepts/core-concepts/merges"},{"title":"Первичные индексы","href":"/ru/concepts/core-concepts/primary-indexes"},{"sidebarTitle":"Параллелизм запросов","title":"Как ClickHouse выполняет запрос в параллельном режиме","href":"/ru/concepts/core-concepts/query-parallelism"},{"title":"Обзор архитектуры","href":"/ru/concepts/core-concepts/academic-overview"}]},{"group":"Основные понятия ClickHouse","expanded":true,"pages":[{"title":"Концепции ClickHouse","sidebarTitle":"Обзор","mode":"wide","href":"/ru/concepts/features/index"},{"group":"Материализованные представления","pages":[{"title":"Materialized views","sidebarTitle":"Обзор","href":"/ru/concepts/features/materialized-views/index"},{"title":"Incremental materialized view","href":"/ru/concepts/features/materialized-views/incremental-materialized-view"},{"title":"Refreshable materialized view","href":"/ru/concepts/features/materialized-views/refreshable-materialized-view"},{"title":"Каскадные materialized views","href":"/ru/concepts/features/materialized-views/cascading-materialized-views"}]},{"group":"Словари","pages":[{"title":"Словарь","href":"/ru/concepts/features/dictionaries/index"},{"title":"Лучшие практики работы со словарями","sidebarTitle":"Лучшие практики","href":"/ru/concepts/features/dictionaries/best-practices"}]},{"group":"Проекции","pages":[{"title":"Проекции","href":"/ru/concepts/features/projections/projections"},{"sidebarTitle":"Materialized views и проекции","title":"Materialized views и проекции","href":"/ru/concepts/features/projections/materialized-views-versus-projections"}]},{"group":"Производительность","pages":[{"sidebarTitle":"Обзор производительности и оптимизации","title":"Производительность и оптимизация","mode":"wide","href":"/ru/concepts/features/performance/index"},{"sidebarTitle":"Оптимизация PREWHERE","title":"Как работает оптимизация PREWHERE?","href":"/ru/concepts/features/performance/prewhere"},{"sidebarTitle":"Профилирование выделения памяти","title":"Профилирование выделения памяти","href":"/ru/concepts/features/performance/allocation-profiling"},{"sidebarTitle":"Профилирование выделения памяти для версий до 25.9","title":"Профилирование выделения памяти для версий до 25.9","href":"/ru/concepts/features/performance/allocation-profiling-old"},{"group":"Кеши","pages":[{"sidebarTitle":"Кэши","title":"Типы кэшей","href":"/ru/concepts/features/performance/caches/caches"},{"sidebarTitle":"Кэш запросов","title":"Кэш запросов","href":"/ru/concepts/features/performance/caches/query-cache"},{"sidebarTitle":"Кэш условий запроса","title":"Кэш условий запроса","href":"/ru/concepts/features/performance/caches/query-condition-cache"},{"sidebarTitle":"Кэш страниц в пространстве пользователя","title":"Кэш страниц в пространстве пользователя","href":"/ru/concepts/features/performance/caches/userspace-page-cache"}]},{"group":"Индексы пропуска данных","pages":[{"sidebarTitle":"Индексы пропуска данных","title":"Что такое индексы пропуска данных в ClickHouse","href":"/ru/concepts/features/performance/skip-indexes/skipping-indexes"},{"sidebarTitle":"Индексы пропуска данных — примеры","title":"Примеры индексов пропуска данных","href":"/ru/concepts/features/performance/skip-indexes/skipping-indexes-examples"}]},{"sidebarTitle":"Ленивая материализация","title":"Ленивая материализация","href":"/ru/concepts/features/performance/lazy-materialization"},{"group":"Устранение неполадок","pages":[{"sidebarTitle":"Отладка проблем с памятью","title":"Отладка проблем с памятью","href":"/ru/concepts/features/performance/troubleshoot/debugging-memory-issues"},{"title":"OOM-канарейка","href":"/ru/concepts/features/performance/troubleshoot/oom-canary"},{"sidebarTitle":"Тестирование оборудования","title":"Как протестировать оборудование с помощью ClickHouse","href":"/ru/concepts/features/performance/troubleshoot/performance-test"},{"sidebarTitle":"Профилирование запросов","title":"Выборочный профилировщик запросов","href":"/ru/concepts/features/performance/troubleshoot/sampling-query-profiler"}]}]},{"group":"Операции","pages":[{"sidebarTitle":"Фоновые запросы","title":"Фоновые запросы","href":"/ru/concepts/features/operations/background-queries"},{"group":"Вставка","pages":[{"title":"Вставка данных в ClickHouse","sidebarTitle":"Вставка данных в ClickHouse","href":"/ru/concepts/features/operations/insert/inserting-data"},{"sidebarTitle":"Асинхронные вставки","title":"Асинхронные вставки (async_insert)","href":"/ru/concepts/features/operations/insert/asyncinserts"},{"sidebarTitle":"Асинхронный INSERT ... SELECT","title":"Асинхронный INSERT ... SELECT","href":"/ru/concepts/features/operations/insert/async-insert-select"},{"sidebarTitle":"Пакетные вставки","title":"Пакетные вставки","href":"/ru/concepts/features/operations/insert/bulkinserts"},{"sidebarTitle":"Стратегии дедупликации","title":"Стратегии дедупликации","href":"/ru/concepts/features/operations/insert/deduplication"},{"title":"Дедупликация вставок при повторных попытках","href":"/ru/concepts/features/operations/insert/deduplicating-inserts-on-retries"},{"title":"Поддержка транзакций (ACID)","href":"/ru/concepts/features/operations/insert/transactions"}]},{"group":"Выборка","pages":[{"title":"Использование JOIN в ClickHouse","description":"Как использовать JOIN для объединения таблиц в ClickHouse","href":"/ru/concepts/features/operations/select/joining-tables"}]},{"group":"Обновление","pages":[{"title":"Обновление данных","sidebarTitle":"Обзор","href":"/ru/concepts/features/operations/update/index"},{"title":"Обновления в ClickHouse","description":"Руководство по доступным методам обновления и выбору подходящего метода для вашей рабочей нагрузки.","sidebarTitle":"Работа с обновлениями","href":"/ru/concepts/features/operations/update/overview"},{"title":"Работа с движком ReplacingMergeTree","sidebarTitle":"Работа с движком ReplacingMergeTree","href":"/ru/concepts/features/operations/update/replacing-merge-tree"}]},{"group":"Удаление","pages":[{"title":"Удаление данных","href":"/ru/concepts/features/operations/delete/index"},{"title":"Обзор удаления данных","href":"/ru/concepts/features/operations/delete/overview"},{"sidebarTitle":"Удалить партицию","title":"Удаление партиций","href":"/ru/concepts/features/operations/delete/drop-partition"},{"title":"Легковесное удаление","href":"/ru/concepts/features/operations/delete/lightweight-delete"},{"sidebarTitle":"TRUNCATE таблицы","title":"TRUNCATE таблицы","href":"/ru/concepts/features/operations/delete/truncate"},{"sidebarTitle":"TTL (time-to-live)","title":"Управление данными с помощью TTL (time-to-live)","href":"/ru/concepts/features/operations/delete/ttl"}]}]},{"group":"Конфигурация","pages":[{"group":"Настройки","pages":[{"title":"Обзор настроек","href":"/ru/concepts/features/configuration/settings/overview"},{"sidebarTitle":"Настройки сеанса на уровне запроса","title":"Настройки сеанса на уровне запроса","href":"/ru/concepts/features/configuration/settings/settings-query-level"},{"sidebarTitle":"Настройки пользователей","title":"Настройки пользователей и ролей","href":"/ru/concepts/features/configuration/settings/settings-users"},{"sidebarTitle":"Профили настроек","title":"Профили настроек","href":"/ru/concepts/features/configuration/settings/settings-profiles"},{"sidebarTitle":"Ограничения для настроек","title":"Ограничения для настроек","href":"/ru/concepts/features/configuration/settings/constraints-on-settings"},{"sidebarTitle":"Ограничения на сложность запросов","title":"Ограничения на сложность запросов","href":"/ru/concepts/features/configuration/settings/query-complexity"},{"sidebarTitle":"Права для запросов","title":"Права для запросов","href":"/ru/concepts/features/configuration/settings/permissions-for-queries"},{"title":"Оверкоммит памяти","href":"/ru/concepts/features/configuration/settings/memory-overcommit"},{"sidebarTitle":"Перегрузка сервера","title":"Перегрузка сервера","href":"/ru/concepts/features/configuration/settings/server-overload"},{"sidebarTitle":"Ограничения TCP-соединений","title":"Ограничения TCP-соединений","href":"/ru/concepts/features/configuration/settings/tcp-connection-limits"},{"sidebarTitle":"Альтернативные языки запросов","title":"Альтернативные языки запросов","href":"/ru/concepts/features/configuration/settings/alternative-query-languages"}]},{"group":"Конфигурация сервера","pages":[{"sidebarTitle":"Файлы конфигурации","title":"Файлы конфигурации","href":"/ru/concepts/features/configuration/server-config/configuration-files"},{"sidebarTitle":"Внешние диски для хранения данных","title":"Внешние диски для хранения данных","href":"/ru/concepts/features/configuration/server-config/storing-data"},{"sidebarTitle":"Именованные коллекции","title":"Именованные коллекции","href":"/ru/concepts/features/configuration/server-config/named-collections"},{"sidebarTitle":"Планирование рабочих нагрузок","title":"Планирование рабочих нагрузок","href":"/ru/concepts/features/configuration/server-config/workload-scheduling"},{"sidebarTitle":"Квоты","title":"Квоты","href":"/ru/concepts/features/configuration/server-config/quotas"},{"sidebarTitle":"Составные протоколы","title":"Составные протоколы","href":"/ru/concepts/features/configuration/server-config/composable-protocols"},{"sidebarTitle":"Скрипты запуска","title":"Скрипты запуска","href":"/ru/concepts/features/configuration/server-config/startup-scripts"},{"sidebarTitle":"Порт интроспекции","title":"Порт интроспекции","href":"/ru/concepts/features/configuration/server-config/introspection-port"}]}]},{"group":"Безопасность и аутентификация","pages":[{"title":"Безопасность и аутентификация","mode":"wide","href":"/ru/concepts/features/security/index"},{"sidebarTitle":"Пользователи и роли","title":"Система управления доступом и учётными записями","href":"/ru/concepts/features/security/access-rights"},{"sidebarTitle":"Сетевые порты","title":"Сетевые порты","href":"/ru/concepts/features/security/network-ports"},{"group":"TLS","pages":[{"title":"настройка TLS","href":"/ru/concepts/features/security/tls/index"},{"sidebarTitle":"Настройка TLS","title":"Настройка TLS","href":"/ru/concepts/features/security/tls/configuring-tls"},{"sidebarTitle":"Настройка автоматического выпуска TLS-сертификатов через ACME","title":"Настройка автоматического выпуска TLS-сертификатов через ACME","href":"/ru/concepts/features/security/tls/configuring-tls-acme-client"}]},{"group":"Внешние средства аутентификации","pages":[{"sidebarTitle":"Внешние аутентификаторы пользователей и службы каталогов","title":"Внешние аутентификаторы пользователей и службы каталогов","href":"/ru/concepts/features/security/external-authenticators/index"},{"group":"SSL","pages":[{"title":"Аутентификация с помощью сертификата SSL X.509","href":"/ru/concepts/features/security/external-authenticators/ssl-x509"},{"sidebarTitle":"Аутентификация по пользовательскому SSL-сертификату","title":"Настройка пользовательского SSL-сертификата для аутентификации","href":"/ru/concepts/features/security/ssl-user-auth"}]},{"group":"LDAP","pages":[{"title":"LDAP","href":"/ru/concepts/features/security/external-authenticators/ldap"},{"sidebarTitle":"Настройка LDAP","title":"Настройка ClickHouse для использования LDAP при аутентификации и сопоставлении ролей","href":"/ru/concepts/features/security/configuring-ldap"}]},{"title":"HTTP","href":"/ru/concepts/features/security/external-authenticators/http"},{"title":"Kerberos","href":"/ru/concepts/features/security/external-authenticators/kerberos"},{"sidebarTitle":"JWT","title":"Аутентификация JWT","href":"/ru/concepts/features/security/external-authenticators/jwt"}]}]},{"group":"Резервное копирование и восстановление","pages":[{"sidebarTitle":"Обзор","title":"Резервное копирование и восстановление в ClickHouse","href":"/ru/concepts/features/backup-restore/overview"},{"sidebarTitle":"Настройки восстановления","title":"Настройки восстановления","href":"/ru/concepts/features/backup-restore/restore-settings"},{"sidebarTitle":"Локальный диск / S3-диск","title":"BACKUP / RESTORE на диск","href":"/ru/concepts/features/backup-restore/local-disk"},{"sidebarTitle":"Конечная точка S3","title":"BACKUP / RESTORE в конечную точку S3 или из неё","href":"/ru/concepts/features/backup-restore/s3-endpoint"},{"sidebarTitle":"AzureBlobStorage","title":"BACKUP И RESTORE В Azure Blob Storage И ИЗ НЕГО","href":"/ru/concepts/features/backup-restore/azure-blob-storage"},{"sidebarTitle":"Резервное копирование снимков","title":"Резервное копирование и восстановление снимков","href":"/ru/concepts/features/backup-restore/snapshot"},{"sidebarTitle":"Альтернативные методы","title":"Альтернативные методы резервного копирования или восстановления","href":"/ru/concepts/features/backup-restore/alternative-methods"}]},{"group":"Интерфейсы","pages":[{"title":"Нативные клиенты и интерфейсы","mode":"wide","href":"/ru/concepts/features/interfaces/native-clients-interfaces-index"},{"sidebarTitle":"clickhousectl","title":"clickhousectl","href":"/ru/concepts/features/interfaces/cli"},{"sidebarTitle":"Клиент ClickHouse","title":"Клиент ClickHouse","href":"/ru/concepts/features/interfaces/client"},{"sidebarTitle":"Model Context Protocol (MCP)","title":"Model Context Protocol (MCP)","href":"/ru/concepts/features/interfaces/mcp"},{"group":"Драйверы и интерфейсы","pages":[{"sidebarTitle":"Обзор","title":"Драйверы и интерфейсы","href":"/ru/concepts/features/interfaces/overview"},{"sidebarTitle":"HTTP-интерфейс","title":"HTTP-интерфейс","href":"/ru/concepts/features/interfaces/http"},{"sidebarTitle":"Форматы фрейминга","title":"Форматы фрейминга","href":"/ru/concepts/features/interfaces/framing-formats"},{"sidebarTitle":"Собственный интерфейс (TCP)","title":"Собственный интерфейс (TCP)","href":"/ru/concepts/features/interfaces/tcp"},{"sidebarTitle":"Драйвер ADBC","title":"Драйвер ADBC","href":"/ru/concepts/features/interfaces/adbc"},{"sidebarTitle":"Интерфейс MySQL","title":"Интерфейс MySQL","href":"/ru/concepts/features/interfaces/mysql"},{"group":"Драйвер ODBC","pages":[{"sidebarTitle":"Обзор","title":"ODBC-драйвер","href":"/ru/concepts/features/interfaces/odbc/index"}]},{"sidebarTitle":"Интерфейс PostgreSQL","title":"Интерфейс PostgreSQL","href":"/ru/concepts/features/interfaces/postgresql"},{"sidebarTitle":"API Prometheus и PromQL","title":"HTTP API Prometheus и PromQL","href":"/ru/concepts/features/interfaces/prometheus"},{"sidebarTitle":"Конечная точка метрик Prometheus","title":"Конечная точка метрик Prometheus","href":"/ru/concepts/features/interfaces/prometheus-metrics"},{"sidebarTitle":"SSH-интерфейс","title":"SSH-интерфейс с PTY","href":"/ru/concepts/features/interfaces/ssh"},{"sidebarTitle":"gRPC-интерфейс","title":"gRPC-интерфейс","href":"/ru/concepts/features/interfaces/grpc"},{"sidebarTitle":"Интерфейс Arrow Flight","title":"Интерфейс Arrow Flight","href":"/ru/concepts/features/interfaces/arrowflight"}]},{"sidebarTitle":"Определение схемы","title":"Автоматическое определение схемы","href":"/ru/concepts/features/interfaces/schema-inference"},{"sidebarTitle":"Поиск по документации","title":"Поиск по документации","href":"/ru/concepts/features/interfaces/documentation-search"},{"sidebarTitle":"Web SQL UI","title":"Web SQL UI (Play)","href":"/ru/concepts/features/interfaces/web-sql"},{"sidebarTitle":"SQL Console","title":"SQL Console","href":"/ru/concepts/features/interfaces/sql-console"},{"sidebarTitle":"Цветовое кодирование в веб-интерфейсе","title":"Цветовое кодирование в веб-интерфейсе","href":"/ru/concepts/features/interfaces/web-ui-color-coding"},{"sidebarTitle":"Закреплённые столбцы в веб-интерфейсе","title":"Закреплённые столбцы в веб-интерфейсе","href":"/ru/concepts/features/interfaces/web-ui-pinned-columns"},{"sidebarTitle":"Режим блокнота в веб-интерфейсе","title":"Режим блокнота в веб-интерфейсе","href":"/ru/concepts/features/interfaces/web-ui-notebook"},{"sidebarTitle":"Настройка формы результатов в Web UI","title":"Сортировка, фильтрация и разбиение на страницы в Web UI","href":"/ru/concepts/features/interfaces/web-ui-result-shaping"},{"sidebarTitle":"Веб-терминал","title":"Веб-терминал","href":"/ru/concepts/features/interfaces/web-terminal"},{"group":"Сторонние клиенты","pages":[{"title":"Сторонние интерфейсы","href":"/ru/concepts/features/interfaces/third-party/index"}]}]},{"group":"Инструменты и утилиты","pages":[{"sidebarTitle":"Список инструментов и утилит","title":"Список инструментов и утилит","mode":"wide","href":"/ru/concepts/features/tools-and-utilities/index"},{"title":"clickhouse_backupview","href":"/ru/concepts/features/tools-and-utilities/backupview"},{"sidebarTitle":"clickhouse-benchmark","title":"clickhouse-benchmark","href":"/ru/concepts/features/tools-and-utilities/clickhouse-benchmark"},{"title":"clickhouse-compressor","href":"/ru/concepts/features/tools-and-utilities/clickhouse-compressor"},{"sidebarTitle":"clickhouse-disks","title":"clickhouse-disks","href":"/ru/concepts/features/tools-and-utilities/clickhouse-disks"},{"title":"clickhouse-format","href":"/ru/concepts/features/tools-and-utilities/clickhouse-format"},{"sidebarTitle":"clickhouse-keeper-client","title":"Утилита clickhouse-keeper-client","href":"/ru/concepts/features/tools-and-utilities/clickhouse-keeper-client"},{"sidebarTitle":"HTTP API ClickHouse Keeper","title":"HTTP API и панель мониторинга ClickHouse Keeper","href":"/ru/concepts/features/tools-and-utilities/clickhouse-keeper-http-api"},{"sidebarTitle":"clickhouse-local","title":"clickhouse-local","href":"/ru/concepts/features/tools-and-utilities/clickhouse-local"},{"title":"clickhouse-obfuscator","href":"/ru/concepts/features/tools-and-utilities/clickhouse-obfuscator"},{"title":"clickhouse-odbc-bridge","href":"/ru/concepts/features/tools-and-utilities/odbc-bridge"},{"title":"clickhouse-static-files-disk-uploader","href":"/ru/concepts/features/tools-and-utilities/static-files-disk-uploader"}]}]},{"group":"Рекомендации","expanded":true,"pages":[{"title":"Лучшие практики ClickHouse","mode":"wide","href":"/ru/concepts/best-practices/index"},{"sidebarTitle":"Выбор первичного ключа","title":"Выбор первичного ключа","href":"/ru/concepts/best-practices/choosing-a-primary-key"},{"sidebarTitle":"Выбор типов данных","title":"Выбор типов данных","href":"/ru/concepts/best-practices/select-data-type"},{"sidebarTitle":"Используйте materialized views","title":"Используйте materialized views","href":"/ru/concepts/best-practices/use-materialized-views"},{"sidebarTitle":"Минимизация и оптимизация JOIN","title":"Минимизация и оптимизация JOIN","href":"/ru/concepts/best-practices/minimize-optimize-joins"},{"sidebarTitle":"Выбор ключа партиционирования","title":"Выбор ключа партиционирования","href":"/ru/concepts/best-practices/partitioning-keys"},{"sidebarTitle":"Выбор стратегии вставки","title":"Выбор стратегии вставки","href":"/ru/concepts/best-practices/selecting-an-insert-strategy"},{"sidebarTitle":"Индексы пропуска данных","title":"Используйте индексы пропуска данных там, где это целесообразно","href":"/ru/concepts/best-practices/using-data-skipping-indices"},{"sidebarTitle":"Избегайте мутаций","title":"Избегайте мутаций","href":"/ru/concepts/best-practices/avoid-mutations"},{"sidebarTitle":"Избегайте OPTIMIZE FINAL","title":"Избегайте `OPTIMIZE FINAL`","href":"/ru/concepts/best-practices/avoid-optimize-final"},{"sidebarTitle":"Избегайте столбцов с типом Nullable","title":"Избегайте столбцов с типом Nullable","href":"/ru/concepts/best-practices/avoidnullablecolumns"},{"sidebarTitle":"Использование JSON","title":"Используйте JSON там, где это уместно","href":"/ru/concepts/best-practices/json-type"}]}]},{"item":"Справочник","pages":[{"title":"Справочник","href":"/ru/reference/home"}]},{"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":"/ru/products/managed-postgres/overview"}]}]},{"tab":"Продукты","menu":[{"item":"Развертывания","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickHouse Cloud","pages":[{"title":"ClickHouse Cloud","href":"/ru/products/cloud/getting-started/cloud-get-started"}]},{"item":"BYOC","pages":[{"title":"BYOC","href":"/ru/products/cloud/guides/infrastructure/deployment-options/byoc/overview"}]},{"item":"Приложения","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","pages":[{"title":"ClickStack","href":"/ru/clickstack"}]},{"item":"Agents","pages":[{"title":"Agents","href":"/ru/agents"}]},{"item":"Инженерия ИИ","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/logo-langfuse.svg","href":"https://langfuse.com/docs"},{"item":"Безопасность","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/integrations/logos/runreveal.webp","href":"https://docs.runreveal.com/"},{"item":"С открытым исходным кодом","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","pages":[{"title":"ClickStack","href":"/ru/clickstack"}]},{"item":"chDB","pages":[{"title":"chDB","href":"/ru/chdb"}]},{"item":"Оператор Kubernetes","pages":[{"title":"Оператор Kubernetes","href":"/ru/products/kubernetes-operator/overview"}]},{"item":"LibreChat","href":"https://www.librechat.ai/docs"}],"pages":[{"title":"Продукты","href":"/ru/products/cloud/getting-started/cloud-get-started"}]},{"tab":"Интеграции","menu":[{"item":"Экосистема","pages":[{"title":"Экосистема","href":"/ru/integrations/home"}]},{"item":"ClickPipes","pages":[{"title":"ClickPipes","href":"/ru/integrations/clickpipes/home"}]},{"item":"Клиентские библиотеки для языков программирования","pages":[{"title":"Клиентские библиотеки для языков программирования","href":"/ru/integrations/language-clients"}]},{"item":"Коннекторы","pages":[{"title":"Коннекторы","href":"/ru/integrations/connectors/data-sources"}]}],"pages":[{"title":"Интеграции","href":"/ru/integrations/home"}]},{"tab":"Ресурсы","menu":[{"item":"Центр поддержки","pages":[{"title":"Центр поддержки","href":"/ru/resources/support-center/home"}]},{"item":"Разработка и участие в проекте","pages":[{"title":"Разработка и участие в проекте","href":"/ru/resources/develop-contribute/introduction/developer-instruction"}]},{"item":"Журналы изменений","dropdowns":[{"dropdown":"Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"Cloud","href":"/ru/resources/changelogs/cloud"}]},{"dropdown":"С открытым исходным кодом","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-server.svg","pages":[{"title":"С открытым исходным кодом","href":"/ru/resources/changelogs/oss/2026"}]}]},{"item":"О проекте","pages":[{"title":"О проекте","href":"/ru/resources/about"}]}],"pages":[{"title":"Ресурсы","href":"/ru/resources/support-center/home"}]}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/concepts/features/operations/update"}]}]},"basePath":"","title":"Обновление данных - ClickHouse Documentation","deploymentId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","buildId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","dynamics":[],"chunks":[]}