Présente les différences entre la mise à jour des données dans ClickHouse et dans les bases de données OLTP, ainsi que les différentes méthodes disponibles dans ClickHouse pour le faire.
{"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":"fr/concepts/features/operations/update","slug":"/fr/concepts/features/operations/update","pageMetadata":{"slug":"/updating-data","title":"Mise à jour des données","sidebarTitle":"Vue d’ensemble","description":"Table des matières de la mise à jour des données","keywords":["mise à jour","mise à jour des données"],"doc_type":"landing-page","href":"/fr/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: \"Table des matières de la mise à jour des données\"\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:`Dans cette section de la documentation, vous découvrirez comment mettre à jour vos données.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Page`}),_jsx(_components.th,{children:`Description`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/fr/concepts/features/operations/update/overview`,children:`Travailler avec les mises à jour`})}),_jsx(_components.td,{children:`Présente les différences entre la mise à jour des données dans ClickHouse et dans les bases de données OLTP, ainsi que les différentes méthodes disponibles dans ClickHouse pour le faire.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/fr/concepts/features/operations/update/replacing-merge-tree`,children:`Travailler avec ReplacingMergeTree`})}),_jsx(_components.td,{children:`Découvrez comment effectuer des mises à jour avec 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":"Mise à jour des données","sidebarTitle":"Vue d’ensemble","description":"Table des matières de la mise à jour des données","keywords":["mise à jour","mise à jour des données"],"doc_type":"landing-page","href":"/fr/concepts/features/operations/update/index"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"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"],"subdomain":"private-7c7dfe99","siteName":"ClickHouse Documentation","title":"Mise à jour des données - 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":2},"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":1},"zh":{"href":"/zh/concepts/features/operations/update/index","matchLevel":1}}},"originalFileLocation":"fr/concepts/features/operations/update/index.mdx","locale":"fr"},"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=\"Table des matières de la mise à jour des données\">\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=\"Mise à jour des données - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Table des matières de la mise à jour des données\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://clickhouse.com/docs/fr/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.app/_mintlify/api/og/v2?division=Mise+%C3%A0+jour\u0026amp;title=Mise+%C3%A0+jour+des+donn%C3%A9es\u0026amp;description=Table+des+mati%C3%A8res+de+la+mise+%C3%A0+jour+des+donn%C3%A9es\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=1c4b6fc1aecf610b66456fcd73c6f8ac6f9d00d7190990f1b7652180e0de10d3\">\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=\"Mise à jour des données - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Table des matières de la mise à jour des données\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.app/_mintlify/api/og/v2?division=Mise+%C3%A0+jour\u0026amp;title=Mise+%C3%A0+jour+des+donn%C3%A9es\u0026amp;description=Table+des+mati%C3%A8res+de+la+mise+%C3%A0+jour+des+donn%C3%A9es\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=1c4b6fc1aecf610b66456fcd73c6f8ac6f9d00d7190990f1b7652180e0de10d3\">\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/fr/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/fr/concepts/features/operations/update.md\">\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=\"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=\"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=\"ru\" href=\"https://clickhouse.com/docs/ru/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/fr/concepts/features/operations/update#webpage\",\"url\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update\",\"name\":\"Mise à jour des données\",\"description\":\"Table des matières de la mise à jour des données\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Concepts de ClickHouse\",\"item\":\"https://clickhouse.com/docs/fr/concepts/features/index\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Opérations\",\"item\":\"https://clickhouse.com/docs/fr/concepts/features/operations/background-queries\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Mise à jour\",\"item\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update/index\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Mise à jour des données\",\"item\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update#article\",\"headline\":\"Mise à jour des données\",\"name\":\"Mise à jour des données\",\"description\":\"Table des matières de la mise à jour des données\",\"url\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/fr/concepts/features/operations/update#webpage\"},\"keywords\":\"mise à jour, mise à jour des données\",\"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":"/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","tabs":[{"tab":"Accueil","pages":[{"title":"Accueil","href":"/fr"}]},{"tab":"Base de données","menu":[{"item":"Get started","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-get-started.svg","pages":[{"group":"Get started","icon":"/images/menu-icon-lightning.svg","pages":[{"title":"Bien démarrer avec ClickHouse","sidebarTitle":"Vue d’ensemble","href":"/fr/get-started"},{"group":"Guides de démarrage rapide","expanded":false,"pages":[{"sidebarTitle":"Explorer les quickstarts","title":"Explorateur de Quickstarts","mode":"custom","href":"/fr/get-started/quickstarts/home"},{"group":"Tous les cas d’usage","expanded":false,"pages":[{"sidebarTitle":"Démarrage rapide Cloud","title":"Démarrage rapide de ClickHouse Cloud","href":"/fr/get-started/setup/cloud"},{"sidebarTitle":"Obtenez vos informations de connexion Cloud","title":"Obtenez vos informations de connexion Cloud","href":"/fr/get-started/quickstarts/obtain-your-cloud-connection-details"},{"sidebarTitle":"Insérer des données dans ClickHouse Cloud avec clickhouse-client","title":"Insérer des données dans ClickHouse Cloud avec clickhouse-client","href":"/fr/get-started/quickstarts/insert-data-using-clickhouse-client"},{"sidebarTitle":"Créer des tables dans ClickHouse","title":"Créer des tables dans ClickHouse","href":"/fr/get-started/quickstarts/creating-tables"},{"sidebarTitle":"Sélection des données dans ClickHouse","title":"Sélection des données dans ClickHouse","href":"/fr/get-started/quickstarts/writing-queries"},{"sidebarTitle":"Créez votre première table MergeTree","title":"Créez votre première table MergeTree","href":"/fr/get-started/quickstarts/create-your-first-mergetree-table"}]},{"group":"Analytique en temps réel","expanded":false,"pages":[{"sidebarTitle":"Créez votre première vue matérialisée","title":"Créez votre première vue matérialisée","href":"/fr/get-started/quickstarts/create-your-first-materialized-view"},{"sidebarTitle":"Créez votre première projection","title":"Créez votre première projection","href":"/fr/get-started/quickstarts/create-your-first-projection"}]},{"group":"Entrepôt de données","expanded":false,"pages":[{"sidebarTitle":"Comment connecter votre catalogue Iceberg à ClickHouse Cloud","title":"Comment connecter votre catalogue Iceberg à ClickHouse Cloud","href":"/fr/get-started/quickstarts/connect-your-iceberg-catalog"},{"sidebarTitle":"Mettre à jour et supprimer des données ClickHouse","title":"Mettre à jour et supprimer des données ClickHouse","href":"/fr/get-started/quickstarts/mutations"}]},{"group":"Observabilité","expanded":false,"pages":[{"sidebarTitle":"Utilisation du type Map dans ClickHouse","title":"Utilisation du type Map dans ClickHouse","href":"/fr/get-started/quickstarts/working-with-the-map-type"}]}]},{"group":"Introduction","expanded":true,"pages":[{"sidebarTitle":"Qu’est-ce que ClickHouse ?","title":"Qu’est-ce que ClickHouse ?","href":"/fr/get-started/about/intro"},{"sidebarTitle":"Pourquoi ClickHouse est-il si rapide ?","title":"Pourquoi ClickHouse est-il si rapide ?","href":"/fr/get-started/about/why-clickhouse-is-so-fast"},{"sidebarTitle":"Pourquoi ClickHouse est-il unique ?","title":"Caractéristiques distinctives de ClickHouse","href":"/fr/get-started/about/distinctive-features"}]},{"group":"Use cases","expanded":true,"pages":[{"title":"Cas d’usage","sidebarTitle":"Vue d’ensemble","href":"/fr/get-started/use-cases/overview"},{"title":"Analytique en temps réel","sidebarTitle":"Analytique en temps réel","href":"/fr/get-started/use-cases/real-time-analytics"},{"title":"Observabilité","sidebarTitle":"Observabilité","href":"/fr/get-started/use-cases/observability"},{"title":"Entrepôt de données","sidebarTitle":"Entrepôt de données","href":"/fr/get-started/use-cases/data-warehousing"},{"title":"Analytics agentique","sidebarTitle":"Analytics agentique","href":"/fr/get-started/use-cases/agentic-analytics"}]},{"sidebarTitle":"Modes de déploiement","title":"Modes de déploiement","href":"/fr/get-started/about/deployment-modes"}]},{"group":"Setup","icon":"/images/menu-icon-gear.svg","expanded":true,"pages":[{"sidebarTitle":"Installer","title":"Instructions d’installation","href":"/fr/get-started/setup/install"},{"sidebarTitle":"Démarrage rapide Cloud","title":"Démarrage rapide de ClickHouse Cloud","href":"/fr/get-started/setup/cloud"},{"group":"Self-managed","expanded":true,"pages":[{"title":"Installation autogérée","sidebarTitle":"Vue d'ensemble","href":"/fr/get-started/setup/self-managed/overview"},{"group":"Local development","pages":[{"sidebarTitle":"Installation rapide","title":"Installation rapide","href":"/fr/get-started/setup/self-managed/quick-install"},{"sidebarTitle":"clickhousectl (CLI)","title":"Installer avec la CLI de ClickHouse","href":"/fr/get-started/setup/self-managed/clickhousectl"},{"sidebarTitle":"Docker","title":"Installer ClickHouse avec Docker","href":"/fr/get-started/setup/self-managed/docker"},{"sidebarTitle":"Builds source et CI","title":"Builds source et CI","href":"/fr/get-started/setup/self-managed/advanced"}]},{"group":"Production server","pages":[{"sidebarTitle":"Debian/Ubuntu","title":"Installer ClickHouse sur Debian/Ubuntu","href":"/fr/get-started/setup/self-managed/debian-ubuntu"},{"sidebarTitle":"Red Hat/CentOS","title":"Installer ClickHouse sur des distributions Linux basées sur RPM","href":"/fr/get-started/setup/self-managed/redhat"},{"sidebarTitle":"NixOS","title":"Installer ClickHouse sur NixOS","href":"/fr/get-started/setup/self-managed/nixos"},{"sidebarTitle":"Autres Linux","title":"Installer ClickHouse avec des archives tgz","href":"/fr/get-started/setup/self-managed/other-linux"}]}]}]},{"group":"Sample datasets","icon":"/images/menu-icon-database.svg","expanded":true,"pages":[{"sidebarTitle":"Vue d’ensemble","title":"Tutoriels et jeux de données d’exemple","href":"/fr/get-started/sample-datasets/index"},{"sidebarTitle":"ClickHouse playground","title":"ClickHouse playground","href":"/fr/get-started/sample-datasets/playground"},{"group":"Benchmarks","pages":[{"sidebarTitle":"Benchmark big data AMPLab","title":"AMPLab Big Data Benchmark","href":"/fr/get-started/sample-datasets/amplab-benchmark"},{"sidebarTitle":"Benchmark de l’université Brown","title":"Benchmark de l’université Brown","href":"/fr/get-started/sample-datasets/brown-benchmark"},{"sidebarTitle":"Logs de clics Criteo (1 To)","title":"Un téraoctet de logs de clics de Criteo","href":"/fr/get-started/sample-datasets/criteo"},{"title":"Join Order Benchmark (JOB)","sidebarTitle":"JOB","href":"/fr/get-started/sample-datasets/job"},{"sidebarTitle":"Star Schema Benchmark","title":"Star Schema Benchmark (SSB, 2009)","href":"/fr/get-started/sample-datasets/star-schema"},{"title":"TPC-DS (2012)","sidebarTitle":"TPC-DS","href":"/fr/get-started/sample-datasets/tpcds"},{"title":"TPC-H (1999)","sidebarTitle":"TPC-H","href":"/fr/get-started/sample-datasets/tpch"}]},{"group":"Vector search \u0026 embeddings","pages":[{"sidebarTitle":"jeu de données dbpedia","title":"jeu de données dbpedia","href":"/fr/get-started/sample-datasets/dbpedia"},{"sidebarTitle":"Jeu de données Hacker News pour la recherche vectorielle","title":"Jeu de données Hacker News pour la recherche vectorielle","href":"/fr/get-started/sample-datasets/hacker-news-vector-search"},{"sidebarTitle":"Jeu de données Laion-400M","title":"Jeu de données Laion-400M","href":"/fr/get-started/sample-datasets/laion"},{"sidebarTitle":"Jeu de données LAION 5B","title":"Jeu de données LAION 5B","href":"/fr/get-started/sample-datasets/laion5b"}]},{"group":"Web \u0026 social analytics","pages":[{"sidebarTitle":"Avis clients Amazon","title":"Avis clients Amazon","href":"/fr/get-started/sample-datasets/amazon-reviews"},{"sidebarTitle":"Analyse web anonymisée","title":"Analyse web anonymisée","href":"/fr/get-started/sample-datasets/anon-web-analytics-metrica"},{"sidebarTitle":"Dépôt GitHub","title":"Écrire des requêtes dans ClickHouse à l’aide des données GitHub","href":"/fr/get-started/sample-datasets/github"},{"sidebarTitle":"Événements GitHub","title":"Jeu de données des événements GitHub","href":"/fr/get-started/sample-datasets/github-events"},{"sidebarTitle":"Hacker News","title":"Jeu de données Hacker News","href":"/fr/get-started/sample-datasets/hacker-news"},{"sidebarTitle":"Stack Overflow","title":"Analyse des données de Stack Overflow avec ClickHouse","href":"/fr/get-started/sample-datasets/stackoverflow"},{"sidebarTitle":"Je n’aime pas YouTube","title":"Jeu de données YouTube sur les Je n’aime pas","href":"/fr/get-started/sample-datasets/youtube-dislikes"}]},{"group":"Geo \u0026 location","pages":[{"sidebarTitle":"Antennes-relais","title":"Analyse géospatiale avec le jeu de données des antennes-relais","href":"/fr/get-started/sample-datasets/cell-towers"},{"sidebarTitle":"Foursquare OS Places","title":"Jeu de données Foursquare OS Places","href":"/fr/get-started/sample-datasets/foursquare-os-places"},{"sidebarTitle":"Données des taxis new-yorkais","title":"Analyse géospatiale avec le jeu de données des taxis new-yorkais","href":"/fr/get-started/sample-datasets/nyc-taxi"}]},{"group":"Time series \u0026 sensors","pages":[{"sidebarTitle":"Données des capteurs environnementaux","title":"Données des capteurs environnementaux","href":"/fr/get-started/sample-datasets/environmental-sensors"},{"sidebarTitle":"Global Historical Climatology Network de la NOAA ","title":"Global Historical Climatology Network de la NOAA","href":"/fr/get-started/sample-datasets/noaa"},{"sidebarTitle":"Jeux de données météorologiques historiques de Taïwan","title":"Jeux de données météorologiques historiques de Taïwan","href":"/fr/get-started/sample-datasets/tw-weather"},{"sidebarTitle":"WikiStat","title":"WikiStat","href":"/fr/get-started/sample-datasets/wikistat"}]},{"group":"Public records \u0026 open data","pages":[{"sidebarTitle":"Données ouvertes sur le COVID-19","title":"Données ouvertes sur le COVID-19","href":"/fr/get-started/sample-datasets/covid19"},{"sidebarTitle":"Jeu de données « What's on the Menu? » de la New York Public Library","title":"Jeu de données « What's on the Menu? » de la New York Public Library","href":"/fr/get-started/sample-datasets/menus"},{"sidebarTitle":"Données de plaintes du NYPD","title":"Données de plaintes du NYPD","href":"/fr/get-started/sample-datasets/nypd-complaint-data"},{"sidebarTitle":"Données OnTime sur les vols aériens","title":"OnTime","href":"/fr/get-started/sample-datasets/ontime"},{"sidebarTitle":"Prix de l’immobilier au Royaume-Uni","title":"Requêtes analytiques sur les données des prix de l’immobilier au Royaume-Uni","href":"/fr/get-started/sample-datasets/uk-price-paid"}]}]},{"group":"Migrate","icon":"/images/caret-double-right.svg","expanded":true,"pages":[{"sidebarTitle":"Vue d’ensemble","title":"Migrer des données vers ClickHouse","href":"/fr/get-started/migrate/overview"},{"group":"PostgreSQL","pages":[{"title":"Comparaison entre PostgreSQL et ClickHouse","sidebarTitle":"Vue d’ensemble","href":"/fr/get-started/migrate/postgres/overview"},{"group":"Migration guide","pages":[{"title":"Migration des données","sidebarTitle":"Partie 1","href":"/fr/get-started/migrate/postgres/migration-guide/migration-guide-part1"},{"title":"Réécriture des requêtes PostgreSQL","sidebarTitle":"Partie 2","href":"/fr/get-started/migrate/postgres/migration-guide/migration-guide-part2"},{"title":"Techniques de modélisation des données","sidebarTitle":"Partie 3","href":"/fr/get-started/migrate/postgres/migration-guide/migration-guide-part3"}]},{"title":"Annexe","href":"/fr/get-started/migrate/postgres/appendix"}]},{"group":"BigQuery","pages":[{"title":"Comparaison de ClickHouse Cloud et de BigQuery","sidebarTitle":"Vue d’ensemble","href":"/fr/get-started/migrate/bigquery/overview"},{"title":"Migrer de BigQuery vers ClickHouse Cloud","sidebarTitle":"Guide de migration","href":"/fr/get-started/migrate/bigquery/migrating-to-clickhouse-cloud"},{"sidebarTitle":"Chargement des données","title":"Chargement des données de BigQuery vers ClickHouse","href":"/fr/get-started/migrate/bigquery/loading-data"}]},{"group":"Snowflake","pages":[{"sidebarTitle":"Présentation","title":"Migration de Snowflake vers ClickHouse","href":"/fr/get-started/migrate/snowflake/overview"},{"sidebarTitle":"Guide de migration","title":"Migrer depuis Snowflake vers ClickHouse","href":"/fr/get-started/migrate/snowflake/migration-guide"},{"sidebarTitle":"Référence de traduction SQL","title":"Migration de Snowflake vers ClickHouse","href":"/fr/get-started/migrate/snowflake/sql-translation-reference"}]},{"group":"Elasticsearch","pages":[{"sidebarTitle":"Vue d’ensemble","title":"Migrer d’Elasticsearch vers ClickHouse","href":"/fr/get-started/migrate/elastic/overview"}]},{"group":"Redshift","pages":[{"sidebarTitle":"Vue d’ensemble","title":"Comparaison entre ClickHouse Cloud et Amazon Redshift","href":"/fr/get-started/migrate/redshift/overview"},{"sidebarTitle":"Guide de migration","title":"Guide de migration d’Amazon Redshift vers ClickHouse","href":"/fr/get-started/migrate/redshift/migration-guide"},{"sidebarTitle":"Référence de traduction SQL","title":"Guide de traduction SQL pour Amazon Redshift","href":"/fr/get-started/migrate/redshift/sql-translation-reference"}]},{"group":"OSS to Cloud","pages":[{"sidebarTitle":"Utiliser remoteSecure","title":"Migration entre un ClickHouse autogéré et ClickHouse Cloud avec remoteSecure","href":"/fr/get-started/migrate/oss-to-cloud/clickhouse-to-cloud"},{"sidebarTitle":"Utiliser BACKUP et RESTORE","title":"Migrer d’un ClickHouse autogéré vers ClickHouse Cloud à l’aide des commandes BACKUP et RESTORE","href":"/fr/get-started/migrate/oss-to-cloud/oss-to-cloud-backup-restore"}]},{"group":"Other methods","pages":[{"sidebarTitle":"Avec clickhouse-local","title":"Migrer vers ClickHouse avec clickhouse-local","href":"/fr/get-started/migrate/other-methods/clickhouse-local-etl"},{"sidebarTitle":"Utiliser un outil ETL tiers","title":"Utiliser un outil ETL tiers","href":"/fr/get-started/migrate/other-methods/etl-tool-to-clickhouse"},{"title":"Transférer des données depuis un stockage objet dans le cloud vers ClickHouse Cloud","href":"/fr/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]}]},{"item":"Concepts","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-concepts.svg","pages":[{"title":"Concepts","sidebarTitle":"Vue d’ensemble","mode":"wide","href":"/fr/concepts"},{"group":"Principes fondamentaux","expanded":true,"pages":[{"title":"Concepts de base","mode":"wide","href":"/fr/concepts/core-concepts/index"},{"sidebarTitle":"Glossaire","title":"Glossaire","mode":"wide","href":"/fr/concepts/core-concepts/glossary"},{"title":"Parts de table","href":"/fr/concepts/core-concepts/parts"},{"title":"Partitions de table","href":"/fr/concepts/core-concepts/partitions"},{"title":"Fusions de parts","href":"/fr/concepts/core-concepts/merges"},{"title":"Index primaires","href":"/fr/concepts/core-concepts/primary-indexes"},{"sidebarTitle":"Parallélisme des requêtes","title":"Comment ClickHouse exécute une requête en parallèle","href":"/fr/concepts/core-concepts/query-parallelism"},{"title":"Aperçu de l’architecture","href":"/fr/concepts/core-concepts/academic-overview"}]},{"group":"Concepts de ClickHouse","expanded":true,"pages":[{"title":"Concepts ClickHouse","sidebarTitle":"Vue d’ensemble","mode":"wide","href":"/fr/concepts/features/index"},{"group":"Vues matérialisées","pages":[{"title":"Vues matérialisées","sidebarTitle":"Vue d’ensemble","href":"/fr/concepts/features/materialized-views/index"},{"title":"Vue matérialisée incrémentale","href":"/fr/concepts/features/materialized-views/incremental-materialized-view"},{"title":"Vue matérialisée actualisable","href":"/fr/concepts/features/materialized-views/refreshable-materialized-view"},{"title":"Vues matérialisées en cascade","href":"/fr/concepts/features/materialized-views/cascading-materialized-views"}]},{"group":"Dictionnaires","pages":[{"title":"Dictionnaire","href":"/fr/concepts/features/dictionaries/index"},{"title":"Bonnes pratiques pour les dictionnaires","sidebarTitle":"Bonnes pratiques","href":"/fr/concepts/features/dictionaries/best-practices"}]},{"group":"Projections","pages":[{"title":"Projections","href":"/fr/concepts/features/projections/projections"},{"sidebarTitle":"Vues matérialisées vs projections","title":"Vues matérialisées versus projections","href":"/fr/concepts/features/projections/materialized-views-versus-projections"}]},{"group":"Performances","pages":[{"sidebarTitle":"Aperçu des performances et des optimisations","title":"Performances et optimisations","mode":"wide","href":"/fr/concepts/features/performance/index"},{"sidebarTitle":"Optimisation PREWHERE","title":"Comment fonctionne l’optimisation PREWHERE ?","href":"/fr/concepts/features/performance/prewhere"},{"sidebarTitle":"Profilage des allocations","title":"Profilage des allocations","href":"/fr/concepts/features/performance/allocation-profiling"},{"sidebarTitle":"Profilage des allocations pour les versions antérieures à 25.9","title":"Profilage des allocations pour les versions antérieures à 25.9","href":"/fr/concepts/features/performance/allocation-profiling-old"},{"group":"Caches","pages":[{"sidebarTitle":"Caches","title":"Types de cache","href":"/fr/concepts/features/performance/caches/caches"},{"sidebarTitle":"Cache des requêtes","title":"Cache des requêtes","href":"/fr/concepts/features/performance/caches/query-cache"},{"sidebarTitle":"Cache des conditions de requête","title":"Cache des conditions de requête","href":"/fr/concepts/features/performance/caches/query-condition-cache"},{"sidebarTitle":"Cache de pages en espace utilisateur","title":"Cache de pages en espace utilisateur","href":"/fr/concepts/features/performance/caches/userspace-page-cache"}]},{"group":"Index de saut","pages":[{"sidebarTitle":"Index de saut de données","title":"Comprendre les index de saut de données dans ClickHouse","href":"/fr/concepts/features/performance/skip-indexes/skipping-indexes"},{"sidebarTitle":"Index de saut de données - exemples","title":"Exemples d’index de saut de données","href":"/fr/concepts/features/performance/skip-indexes/skipping-indexes-examples"}]},{"sidebarTitle":"Matérialisation paresseuse","title":"Matérialisation paresseuse","href":"/fr/concepts/features/performance/lazy-materialization"},{"group":"Résolution des problèmes","pages":[{"sidebarTitle":"Débogage des problèmes de mémoire","title":"Débogage des problèmes de mémoire","href":"/fr/concepts/features/performance/troubleshoot/debugging-memory-issues"},{"title":"OOM canary","href":"/fr/concepts/features/performance/troubleshoot/oom-canary"},{"sidebarTitle":"Tester le matériel","title":"Comment tester votre matériel avec ClickHouse","href":"/fr/concepts/features/performance/troubleshoot/performance-test"},{"sidebarTitle":"Profilage des requêtes","title":"Sampling profiler de requêtes","href":"/fr/concepts/features/performance/troubleshoot/sampling-query-profiler"}]}]},{"group":"Opérations","pages":[{"sidebarTitle":"Requêtes en arrière-plan","title":"Requêtes en arrière-plan","href":"/fr/concepts/features/operations/background-queries"},{"group":"Insertion","pages":[{"title":"Insertion de données dans ClickHouse","sidebarTitle":"Insertion de données dans ClickHouse","href":"/fr/concepts/features/operations/insert/inserting-data"},{"sidebarTitle":"Insertions asynchrones","title":"Insertions asynchrones (async_insert)","href":"/fr/concepts/features/operations/insert/asyncinserts"},{"sidebarTitle":"INSERT ... SELECT asynchrone","title":"INSERT ... SELECT asynchrone","href":"/fr/concepts/features/operations/insert/async-insert-select"},{"sidebarTitle":"Insertions groupées","title":"Insertions groupées","href":"/fr/concepts/features/operations/insert/bulkinserts"},{"sidebarTitle":"Stratégies de déduplication","title":"Stratégies de déduplication","href":"/fr/concepts/features/operations/insert/deduplication"},{"title":"Déduplication des insertions lors des tentatives","href":"/fr/concepts/features/operations/insert/deduplicating-inserts-on-retries"},{"title":"Prise en charge des transactions (ACID)","href":"/fr/concepts/features/operations/insert/transactions"}]},{"group":"Sélection","pages":[{"title":"Utiliser les jointures dans ClickHouse","description":"Comment joindre des tables dans ClickHouse","href":"/fr/concepts/features/operations/select/joining-tables"}]},{"group":"Mise à jour","pages":[{"title":"Mise à jour des données","sidebarTitle":"Vue d’ensemble","href":"/fr/concepts/features/operations/update/index"},{"title":"Mises à jour dans ClickHouse","description":"Guide des méthodes de mise à jour disponibles et de la façon de choisir la méthode adaptée à votre charge de travail.","sidebarTitle":"Travailler avec les mises à jour","href":"/fr/concepts/features/operations/update/overview"},{"title":"Travailler avec le moteur ReplacingMergeTree","sidebarTitle":"Travailler avec le moteur ReplacingMergeTree","href":"/fr/concepts/features/operations/update/replacing-merge-tree"}]},{"group":"Suppression","pages":[{"title":"Suppression des données","href":"/fr/concepts/features/operations/delete/index"},{"title":"Aperçu de la suppression","href":"/fr/concepts/features/operations/delete/overview"},{"sidebarTitle":"Supprimer une partition","title":"Suppression de partitions","href":"/fr/concepts/features/operations/delete/drop-partition"},{"title":"Suppression légère","href":"/fr/concepts/features/operations/delete/lightweight-delete"},{"sidebarTitle":"Truncate table","title":"Truncate Table","href":"/fr/concepts/features/operations/delete/truncate"},{"sidebarTitle":"TTL (Time to Live)","title":"Gérer les données avec le TTL (time-to-live)","href":"/fr/concepts/features/operations/delete/ttl"}]}]},{"group":"Configuration","pages":[{"group":"Paramètres","pages":[{"title":"Aperçu des paramètres","href":"/fr/concepts/features/configuration/settings/overview"},{"sidebarTitle":"Paramètres de session au niveau de la requête","title":"Paramètres de session au niveau de la requête","href":"/fr/concepts/features/configuration/settings/settings-query-level"},{"sidebarTitle":"Paramètres utilisateur","title":"Paramètres des utilisateurs et des rôles","href":"/fr/concepts/features/configuration/settings/settings-users"},{"sidebarTitle":"Profils de paramètres","title":"Profils de paramètres","href":"/fr/concepts/features/configuration/settings/settings-profiles"},{"sidebarTitle":"Contraintes sur les paramètres","title":"Contraintes sur les paramètres","href":"/fr/concepts/features/configuration/settings/constraints-on-settings"},{"sidebarTitle":"Restrictions sur la complexité des requêtes","title":"Restrictions sur la complexité des requêtes","href":"/fr/concepts/features/configuration/settings/query-complexity"},{"sidebarTitle":"Permissions pour les requêtes","title":"Permissions pour les requêtes","href":"/fr/concepts/features/configuration/settings/permissions-for-queries"},{"title":"Memory overcommit","href":"/fr/concepts/features/configuration/settings/memory-overcommit"},{"sidebarTitle":"Surcharge du serveur","title":"Surcharge du serveur","href":"/fr/concepts/features/configuration/settings/server-overload"},{"sidebarTitle":"Limites de connexion TCP","title":"Limites de connexion TCP","href":"/fr/concepts/features/configuration/settings/tcp-connection-limits"},{"sidebarTitle":"Langages de requête alternatifs","title":"Langages de requête alternatifs","href":"/fr/concepts/features/configuration/settings/alternative-query-languages"}]},{"group":"Configuration du serveur","pages":[{"sidebarTitle":"Fichiers de configuration","title":"Fichiers de configuration","href":"/fr/concepts/features/configuration/server-config/configuration-files"},{"sidebarTitle":"Disques externes pour stocker des données","title":"Disques externes pour stocker des données","href":"/fr/concepts/features/configuration/server-config/storing-data"},{"sidebarTitle":"Collections nommées","title":"Collections nommées","href":"/fr/concepts/features/configuration/server-config/named-collections"},{"sidebarTitle":"Ordonnancement des workloads","title":"Ordonnancement des workloads","href":"/fr/concepts/features/configuration/server-config/workload-scheduling"},{"sidebarTitle":"Quotas","title":"Quotas","href":"/fr/concepts/features/configuration/server-config/quotas"},{"sidebarTitle":"protocole composable","title":"protocole composable","href":"/fr/concepts/features/configuration/server-config/composable-protocols"},{"sidebarTitle":"Scripts de démarrage","title":"Scripts de démarrage","href":"/fr/concepts/features/configuration/server-config/startup-scripts"},{"sidebarTitle":"Port d’introspection","title":"Port d’introspection","href":"/fr/concepts/features/configuration/server-config/introspection-port"}]}]},{"group":"Sécurité et authentification","pages":[{"title":"Sécurité et authentification","mode":"wide","href":"/fr/concepts/features/security/index"},{"sidebarTitle":"Utilisateurs et rôles","title":"Contrôle d’accès et gestion des comptes","href":"/fr/concepts/features/security/access-rights"},{"sidebarTitle":"Ports réseau","title":"Ports réseau","href":"/fr/concepts/features/security/network-ports"},{"group":"TLS","pages":[{"title":"Configuration TLS","href":"/fr/concepts/features/security/tls/index"},{"sidebarTitle":"Configurer TLS","title":"Configurer TLS","href":"/fr/concepts/features/security/tls/configuring-tls"},{"sidebarTitle":"Configuration du provisionnement automatique de TLS via ACME","title":"Configuration du provisionnement automatique de TLS via ACME","href":"/fr/concepts/features/security/tls/configuring-tls-acme-client"}]},{"group":"Mécanismes d’authentification externes","pages":[{"sidebarTitle":"Authentificateurs externes et annuaires d’utilisateurs","title":"Authentificateurs externes et annuaires d’utilisateurs","href":"/fr/concepts/features/security/external-authenticators/index"},{"group":"SSL","pages":[{"title":"Authentification par certificat SSL X.509","href":"/fr/concepts/features/security/external-authenticators/ssl-x509"},{"sidebarTitle":"Authentification par certificat utilisateur via SSL","title":"Configuration de l'authentification à l'aide d'un certificat utilisateur SSL","href":"/fr/concepts/features/security/ssl-user-auth"}]},{"group":"LDAP","pages":[{"title":"LDAP","href":"/fr/concepts/features/security/external-authenticators/ldap"},{"sidebarTitle":"Configuration d’LDAP","title":"Configuration de ClickHouse pour utiliser LDAP pour l’authentification et le mappage des rôles","href":"/fr/concepts/features/security/configuring-ldap"}]},{"title":"HTTP","href":"/fr/concepts/features/security/external-authenticators/http"},{"title":"Kerberos","href":"/fr/concepts/features/security/external-authenticators/kerberos"},{"sidebarTitle":"JWT","title":"Authentification JWT","href":"/fr/concepts/features/security/external-authenticators/jwt"}]}]},{"group":"Sauvegarde et restauration","pages":[{"sidebarTitle":"Vue d’ensemble","title":"Sauvegarde et restauration dans ClickHouse","href":"/fr/concepts/features/backup-restore/overview"},{"sidebarTitle":"Paramètres de restauration","title":"Paramètres de restauration","href":"/fr/concepts/features/backup-restore/restore-settings"},{"sidebarTitle":"Disque local / disque S3","title":"BACKUP / RESTORE vers un disque","href":"/fr/concepts/features/backup-restore/local-disk"},{"sidebarTitle":"point de terminaison S3","title":"SAUVEGARDE / RESTAURATION vers ou depuis un point de terminaison S3","href":"/fr/concepts/features/backup-restore/s3-endpoint"},{"sidebarTitle":"AzureBlobStorage","title":"BACKUP/RESTORE to or from Azure Blob Storage","href":"/fr/concepts/features/backup-restore/azure-blob-storage"},{"sidebarTitle":"Sauvegarde par snapshot","title":"Sauvegarde et restauration par snapshot","href":"/fr/concepts/features/backup-restore/snapshot"},{"sidebarTitle":"Méthodes alternatives","title":"Méthodes alternatives de sauvegarde ou de restauration","href":"/fr/concepts/features/backup-restore/alternative-methods"}]},{"group":"Interfaces","pages":[{"title":"Clients natifs et interfaces","mode":"wide","href":"/fr/concepts/features/interfaces/native-clients-interfaces-index"},{"sidebarTitle":"clickhousectl","title":"clickhousectl","href":"/fr/concepts/features/interfaces/cli"},{"sidebarTitle":"Client ClickHouse","title":"Client ClickHouse","href":"/fr/concepts/features/interfaces/client"},{"sidebarTitle":"Model Context Protocol (MCP)","title":"Model Context Protocol (MCP)","href":"/fr/concepts/features/interfaces/mcp"},{"group":"Drivers et interfaces","pages":[{"sidebarTitle":"Vue d'ensemble","title":"Pilotes et interfaces","href":"/fr/concepts/features/interfaces/overview"},{"sidebarTitle":"Interface HTTP","title":"Interface HTTP","href":"/fr/concepts/features/interfaces/http"},{"sidebarTitle":"Formats de tramage","title":"Formats de tramage","href":"/fr/concepts/features/interfaces/framing-formats"},{"sidebarTitle":"Interface native (TCP)","title":"Interface native (TCP)","href":"/fr/concepts/features/interfaces/tcp"},{"sidebarTitle":"Pilote ADBC","title":"Pilote ADBC","href":"/fr/concepts/features/interfaces/adbc"},{"sidebarTitle":"Interface MySQL","title":"Interface MySQL","href":"/fr/concepts/features/interfaces/mysql"},{"group":"Driver ODBC","pages":[{"sidebarTitle":"Vue d’ensemble","title":"Pilote ODBC","href":"/fr/concepts/features/interfaces/odbc/index"}]},{"sidebarTitle":"Interface PostgreSQL","title":"Interface PostgreSQL","href":"/fr/concepts/features/interfaces/postgresql"},{"sidebarTitle":"API Prometheus et PromQL","title":"API HTTP Prometheus et PromQL","href":"/fr/concepts/features/interfaces/prometheus"},{"sidebarTitle":"Endpoint de metrics Prometheus","title":"Endpoint de metrics Prometheus","href":"/fr/concepts/features/interfaces/prometheus-metrics"},{"sidebarTitle":"Interface SSH","title":"Interface SSH avec PTY","href":"/fr/concepts/features/interfaces/ssh"},{"sidebarTitle":"interface gRPC","title":"interface gRPC","href":"/fr/concepts/features/interfaces/grpc"},{"sidebarTitle":"Interface Arrow Flight","title":"Interface Arrow Flight","href":"/fr/concepts/features/interfaces/arrowflight"}]},{"sidebarTitle":"Inférence de schéma","title":"Inférence automatique du schéma à partir des données d’entrée","href":"/fr/concepts/features/interfaces/schema-inference"},{"sidebarTitle":"Recherche dans la documentation","title":"Recherche dans la documentation","href":"/fr/concepts/features/interfaces/documentation-search"},{"sidebarTitle":"Interface SQL Web","title":"Interface SQL Web (Play)","href":"/fr/concepts/features/interfaces/web-sql"},{"sidebarTitle":"SQL Console","title":"SQL Console","href":"/fr/concepts/features/interfaces/sql-console"},{"sidebarTitle":"Codage couleur de l’interface Web","title":"Codage couleur de l’interface Web","href":"/fr/concepts/features/interfaces/web-ui-color-coding"},{"sidebarTitle":"Colonnes épinglées de la Web UI","title":"Colonnes épinglées de la Web UI","href":"/fr/concepts/features/interfaces/web-ui-pinned-columns"},{"sidebarTitle":"Mode notebook de l’interface Web","title":"Mode notebook de l’interface Web","href":"/fr/concepts/features/interfaces/web-ui-notebook"},{"sidebarTitle":"Mise en forme des résultats de l’interface Web","title":"Tri, filtrage et pagination dans l’interface Web","href":"/fr/concepts/features/interfaces/web-ui-result-shaping"},{"sidebarTitle":"Terminal web","title":"Terminal web","href":"/fr/concepts/features/interfaces/web-terminal"},{"group":"Clients tiers","pages":[{"title":"Interfaces tierces","href":"/fr/concepts/features/interfaces/third-party/index"}]}]},{"group":"Outils et utilitaires","pages":[{"sidebarTitle":"Liste des outils et utilitaires","title":"Liste des outils et utilitaires","mode":"wide","href":"/fr/concepts/features/tools-and-utilities/index"},{"title":"clickhouse_backupview","href":"/fr/concepts/features/tools-and-utilities/backupview"},{"sidebarTitle":"clickhouse-benchmark","title":"clickhouse-benchmark","href":"/fr/concepts/features/tools-and-utilities/clickhouse-benchmark"},{"title":"clickhouse-compressor","href":"/fr/concepts/features/tools-and-utilities/clickhouse-compressor"},{"sidebarTitle":"clickhouse-disks","title":"clickhouse-disks","href":"/fr/concepts/features/tools-and-utilities/clickhouse-disks"},{"title":"clickhouse-format","href":"/fr/concepts/features/tools-and-utilities/clickhouse-format"},{"sidebarTitle":"clickhouse-keeper-client","title":"utilitaire clickhouse-keeper-client","href":"/fr/concepts/features/tools-and-utilities/clickhouse-keeper-client"},{"sidebarTitle":"API HTTP Keeper","title":"API HTTP et tableau de bord de Keeper","href":"/fr/concepts/features/tools-and-utilities/clickhouse-keeper-http-api"},{"sidebarTitle":"clickhouse-local","title":"clickhouse-local","href":"/fr/concepts/features/tools-and-utilities/clickhouse-local"},{"title":"clickhouse-obfuscator","href":"/fr/concepts/features/tools-and-utilities/clickhouse-obfuscator"},{"title":"clickhouse-odbc-bridge","href":"/fr/concepts/features/tools-and-utilities/odbc-bridge"},{"title":"clickhouse-static-files-disk-uploader","href":"/fr/concepts/features/tools-and-utilities/static-files-disk-uploader"}]}]},{"group":"Bonnes pratiques","expanded":true,"pages":[{"title":"Bonnes pratiques avec ClickHouse","mode":"wide","href":"/fr/concepts/best-practices/index"},{"sidebarTitle":"Choisir une clé primaire","title":"Choisir une clé primaire","href":"/fr/concepts/best-practices/choosing-a-primary-key"},{"sidebarTitle":"Choix des types de données","title":"Choix des types de données","href":"/fr/concepts/best-practices/select-data-type"},{"sidebarTitle":"Utiliser les vues matérialisées","title":"Utiliser les vues matérialisées","href":"/fr/concepts/best-practices/use-materialized-views"},{"sidebarTitle":"Réduire et optimiser les JOIN","title":"Réduire et optimiser les JOIN","href":"/fr/concepts/best-practices/minimize-optimize-joins"},{"sidebarTitle":"Choisir une clé de partitionnement","title":"Choisir une clé de partitionnement","href":"/fr/concepts/best-practices/partitioning-keys"},{"sidebarTitle":"Choisir une stratégie d'insertion","title":"Choisir une stratégie d'insertion","href":"/fr/concepts/best-practices/selecting-an-insert-strategy"},{"sidebarTitle":"Index de saut de données","title":"Utiliser les index de saut de données lorsque cela est pertinent","href":"/fr/concepts/best-practices/using-data-skipping-indices"},{"sidebarTitle":"Éviter les mutations","title":"Éviter les mutations","href":"/fr/concepts/best-practices/avoid-mutations"},{"sidebarTitle":"Éviter OPTIMIZE FINAL","title":"Éviter `OPTIMIZE FINAL`","href":"/fr/concepts/best-practices/avoid-optimize-final"},{"sidebarTitle":"Évitez les colonnes Nullable","title":"Évitez les colonnes Nullable","href":"/fr/concepts/best-practices/avoidnullablecolumns"},{"sidebarTitle":"Utiliser JSON","title":"Utiliser JSON à bon escient","href":"/fr/concepts/best-practices/json-type"}]}]},{"item":"Guides","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-guides.svg","pages":[{"title":"Guides","href":"/fr/guides/clickhouse"}]},{"item":"Référence","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-reference.svg","pages":[{"title":"Référence","href":"/fr/reference/home"}]}]},{"tab":"Solutions","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":"/fr/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":"/fr/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":"Open source","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":"/fr/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":"/fr/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":"/fr/chdb"}]},{"item":"Opérateur Kubernetes","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-kubernetes-operator.svg","pages":[{"title":"Opérateur Kubernetes","href":"/fr/products/kubernetes-operator/overview"}]}],"pages":[{"title":"Solutions","href":"/fr/products/cloud/getting-started/cloud-get-started"}]},{"tab":"Intégrations","menu":[{"item":"Écosystème","pages":[{"title":"Écosystème","href":"/fr/integrations/home"}]},{"item":"ClickPipes","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickpipes.svg","pages":[{"title":"ClickPipes","href":"/fr/integrations/clickpipes/home"}]},{"item":"Clients par langage","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-language-clients.svg","pages":[{"title":"Clients par langage","href":"/fr/integrations/language-clients"}]},{"item":"Connecteurs","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-connectors.svg","pages":[{"title":"Connecteurs","href":"/fr/integrations/connectors/data-sources"}]}],"pages":[{"title":"Intégrations","href":"/fr/integrations/home"}]},{"tab":"Ressources","menu":[{"item":"Centre d’assistance","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-support-center.svg","pages":[{"title":"Centre d’assistance","href":"/fr/resources/support-center/home"}]},{"item":"Développement et contributions","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-contribute.svg","pages":[{"title":"Développement et contributions","href":"/fr/resources/develop-contribute/introduction/developer-instruction"}]},{"item":"Journaux des modifications","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":"/fr/resources/changelogs/cloud"}]},{"dropdown":"Open source","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-server.svg","pages":[{"title":"Open source","href":"/fr/resources/changelogs/oss/2026"}]}]},{"item":"À propos","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-about.svg","pages":[{"title":"À propos","href":"/fr/resources/about"}]}],"pages":[{"title":"Ressources","href":"/fr/resources/support-center/home"}]}]},{"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","pages":[{"title":"ru","href":"/ru/concepts/features/operations/update"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/concepts/features/operations/update"}]}]},"basePath":"","title":"Mise à jour des données - ClickHouse Documentation","buildId":"dpl_Acry4NrQAgjcikyFgVE2eJ7XQCAv","deploymentId":"dpl_Acry4NrQAgjcikyFgVE2eJ7XQCAv","dynamics":[],"chunks":[]}
