> ## Documentation Index > Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Centre d’assistance > Consultez et recherchez dans la base de connaissances ClickHouse export const kbIndex = { categories: ["Cloud", "Configuration & settings", "Data import & export", "Data management", "General & FAQs", "Integrations & client libraries", "Materialized views & projections", "Monitoring & debugging", "Performance & optimization", "Queries & SQL", "Security & access control", "Setup & installation", "Tables & schema", "Troubleshooting & errors"], tags: ["Best Practices", "Community", "Concepts", "Core Data Concepts", "Data Export", "Data Formats", "Data Ingestion", "Data Modelling", "Data Sources", "Deployments and Scaling", "Errors and Exceptions", "Functions", "Language Clients", "Managing Cloud", "Managing Data", "Native Clients and Interfaces", "Performance and Optimizations", "Runbooks", "Security and Authentication", "Server Admin", "Settings", "System Tables", "Tools and Utilities", "Troubleshooting", "Use Cases"], articles: [{ id: "integrations/python-clickhouse-connect-example", title: "A Python client working example for connecting to ClickHouse Cloud service", description: "Learn how to connect to ClickHouse Cloud Service using Python with a step-by-step example using the clickhouse-connect driver.", href: "/fr/resources/support-center/knowledge-base/integrations/python-clickhouse-connect-example", category: "Integrations & client libraries", tags: ["Language Clients"] }, { id: "configuration-settings/about-quotas-and-query-complexity", title: "About quotas and query complexity", description: "Quotas and Query Complexity are powerful ways to limit and restrict what users can do in ClickHouse. This KB article shows examples on how to apply these two different approaches.", href: "/fr/resources/support-center/knowledge-base/configuration-settings/about-quotas-and-query-complexity", category: "Configuration & settings", tags: ["Managing Cloud"] }, { id: "data-import-export/achieving-atomic-inserts", title: "Achieving atomic inserts and multi-table consistency in ClickHouse Cloud", description: "How to load data atomically and keep multiple tables consistent in ClickHouse Cloud without multi-statement transactions, using staging tables and partition-level operations.", href: "/fr/resources/support-center/knowledge-base/data-import-export/achieving-atomic-inserts", category: "Data import & export", tags: ["Data Ingestion", "Best Practices"] }, { id: "tables-schema/add-column", title: "Adding a column to a table", description: "In this guide, we'll learn how to add a column to an existing table.", href: "/fr/resources/support-center/knowledge-base/tables-schema/add-column", category: "Tables & schema", tags: ["Data Modelling"] }, { id: "configuration-settings/alter-user-settings-exception", title: "Alter user settings exception", description: "Handing the an exception thrown when altering user settings", href: "/fr/resources/support-center/knowledge-base/configuration-settings/alter-user-settings-exception", category: "Configuration & settings", tags: ["Settings", "Errors and Exceptions"] }, { id: "materialized-views/are-materialized-views-inserted-asynchronously", title: "Are Materialized Views inserted synchronously?", description: "This KB article explores whether Materialized Views are inserted synchronously", href: "/fr/resources/support-center/knowledge-base/materialized-views/are-materialized-views-inserted-asynchronously", category: "Materialized views & projections", tags: ["Data Modelling"] }, { id: "tables-schema/schema-migration-tools", title: "Automatic schema migration tools for ClickHouse", description: "Learn about automatic schema migration tools for ClickHouse and how to manage changing database schemas over time.", href: "/fr/resources/support-center/knowledge-base/tables-schema/schema-migration-tools", category: "Tables & schema", tags: ["Tools and Utilities"] }, { id: "cloud-services/aws-privatelink-setup-for-msk-clickpipes", title: "AWS PrivateLink setup to expose MSK for ClickPipes", description: "Setup steps to expose a private MSK via MSK multi-VPC connectivity to ClickPipes.", href: "/fr/resources/support-center/knowledge-base/cloud-services/aws-privatelink-setup-for-msk-clickpipes", category: "Cloud", tags: ["Security and Authentication", "Managing Cloud"] }, { id: "cloud-services/aws-privatelink-setup-for-clickpipes", title: "AWS PrivateLink setup to expose private RDS for ClickPipes", description: "Setup steps to expose a private RDS via AWS PrivateLink to ClickPipes.", href: "/fr/resources/support-center/knowledge-base/cloud-services/aws-privatelink-setup-for-clickpipes", category: "Cloud", tags: ["Security and Authentication", "Managing Cloud"] }, { id: "cloud-services/aws-privatelink-vpc-endpoint-service-for-msk-cluster", title: "Service d'endpoint VPC AWS PrivateLink pour cluster MSK", description: "Étapes de configuration pour exposer un cluster MSK à ClickPipes via les services d'endpoint VPC AWS PrivateLink.", href: "/fr/resources/support-center/knowledge-base/cloud-services/aws-privatelink-vpc-endpoint-service-for-msk-cluster", category: "Cloud", tags: ["Security and Authentication", "Managing Cloud"] }, { id: "data-management/backing-up-a-specific-partition", title: "Backing up a specific partition", description: "How can I backup a specific partition in ClickHouse?", href: "/fr/resources/support-center/knowledge-base/data-management/backing-up-a-specific-partition", category: "Data management", tags: ["Managing Data"] }, { id: "general-faqs/key-value", title: "Can I use ClickHouse as a key-value storage?", description: "Answers the frequently asked question of whether or not ClickHouse can be used as a key-value storage?", href: "/fr/resources/support-center/knowledge-base/general-faqs/key-value", category: "General & FAQs", tags: [] }, { id: "general-faqs/time-series", title: "Can I use ClickHouse as a time-series database?", description: "Page describing how to use ClickHouse as a time-series database", href: "/fr/resources/support-center/knowledge-base/general-faqs/time-series", category: "General & FAQs", tags: [] }, { id: "queries-sql/pivot", title: "Can you PIVOT in ClickHouse?", description: "ClickHouse doesn't have a PIVOT clause, but we can get close to this functionality using aggregate function combinators. Let's see how to do this using the UK housing prices dataset.", href: "/fr/resources/support-center/knowledge-base/queries-sql/pivot", category: "Queries & SQL", tags: ["Data Modelling", "Core Data Concepts"] }, { id: "general-faqs/vector-search", title: "Can you use ClickHouse for vector search?", description: "Learn how to use ClickHouse for vector search, including storing embeddings and searching with distance functions like cosine similarity.", href: "/fr/resources/support-center/knowledge-base/general-faqs/vector-search", category: "General & FAQs", tags: ["Use Cases", "Concepts"] }, { id: "monitoring-debugging/send-logs-level", title: "Capturing server logs of queries at the client", description: "Learn how to capture server logs at the client level, even with different log settings, using the `send_logs_level` client setting.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/send-logs-level", category: "Monitoring & debugging", tags: ["Server Admin"] }, { id: "configuration-settings/change-the-prompt-in-clickhouse-client", title: "Change the prompt in clickhouse-client", description: "This article explains how to change the prompt in your Clickhouse client and clickhouse-local terminal window from :) to a prefix followed by :)", href: "/fr/resources/support-center/knowledge-base/configuration-settings/change-the-prompt-in-clickhouse-client", category: "Configuration & settings", tags: ["Settings", "Native Clients and Interfaces"] }, { id: "security/common-rbac-queries", title: "Requêtes RBAC courantes", description: "Requêtes pour aider à accorder des permissions spécifiques aux utilisateurs.", href: "/fr/resources/support-center/knowledge-base/security/common-rbac-queries", category: "Security & access control", tags: ["Security and Authentication", "Managing Cloud"] }, { id: "queries-sql/comparing-metrics-between-queries", title: "Comparer des métriques entre des requêtes en décibels", description: "Une requête pour comparer des métriques entre deux requêtes dans ClickHouse.", href: "/fr/resources/support-center/knowledge-base/queries-sql/comparing-metrics-between-queries", category: "Queries & SQL", tags: ["Performance and Optimizations"] }, { id: "configuration-settings/configure-cap-ipc-lock-and-cap-sys-nice-in-docker", title: "Configurer les capacités CAP_IPC_LOCK et CAP_SYS_NICE dans Docker", description: "Apprenez à résoudre les avertissements de capacité Docker pour `CAP_IPC_LOCK` et `CAP_SYS_NICE` lors de l'exécution de ClickHouse dans un conteneur.", href: "/fr/resources/support-center/knowledge-base/configuration-settings/configure-cap-ipc-lock-and-cap-sys-nice-in-docker", category: "Configuration & settings", tags: ["Errors and Exceptions"] }, { id: "troubleshooting/configure-cap-ipc-lock-and-cap-sys-nice-in-docker", title: "Configurer les capacités CAP_IPC_LOCK et CAP_SYS_NICE dans Docker", description: "Apprenez à résoudre les avertissements de capacité Docker pour `CAP_IPC_LOCK` et `CAP_SYS_NICE` lors de l'exécution de ClickHouse dans un conteneur.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/configure-cap-ipc-lock-and-cap-sys-nice-in-docker", category: "Troubleshooting & errors", tags: ["Errors and Exceptions"] }, { id: "cloud-services/confluent-cloud-private-connectivity-for-clickpipes", title: "Connectivité privée Confluent Cloud pour ClickPipes", description: "Comment connecter ClickPipes à un cluster Kafka Confluent Cloud existant via AWS PrivateLink ou GCP Private Service Connect.", href: "/fr/resources/support-center/knowledge-base/cloud-services/confluent-cloud-private-connectivity-for-clickpipes", category: "Cloud", tags: ["Security and Authentication", "Managing Cloud"] }, { id: "cloud-services/custom-dns-alias-for-instance", title: "Créer un alias DNS personnalisé en configurant un proxy inverse", description: "Apprenez à configurer un alias DNS personnalisé pour votre instance à l'aide d'un proxy inverse", href: "/fr/resources/support-center/knowledge-base/cloud-services/custom-dns-alias-for-instance", category: "Cloud", tags: ["Server Admin", "Security and Authentication"] }, { id: "troubleshooting/part-intersects-previous-part", title: "DB::Exception : La partie XXXXX intersecte la partie précédente YYYYY. Il s'agit d'un bug ou du résultat d'une intervention manuelle dans les données ZooKeeper.", description: "Cet article explique comment résoudre l'erreur DB::Exception liée aux parties qui se croisent dans ClickHouse, souvent causée par une condition de concurrence ou une intervention manuelle dans les données ZooKeeper.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/part-intersects-previous-part", category: "Troubleshooting & errors", tags: ["Errors and Exceptions", "System Tables"] }, { id: "setup-installation/difference-between-official-builds-and-3rd-party", title: "Différences entre les versions officielles et tierces de ClickHouse", description: "Comprenez les principales différences entre les versions officielles de ClickHouse et les versions tierces, notamment en ce qui concerne les mises à jour, la compatibilité et les considérations de sécurité.", href: "/fr/resources/support-center/knowledge-base/setup-installation/difference-between-official-builds-and-3rd-party", category: "Setup & installation", tags: ["Concepts"] }, { id: "general-faqs/cost-based", title: "ClickHouse dispose-t-il d'un optimiseur basé sur les coûts ?", description: "ClickHouse dispose de certains mécanismes d'optimisation basés sur les coûts", href: "/fr/resources/support-center/knowledge-base/general-faqs/cost-based", category: "General & FAQs", tags: [] }, { id: "general-faqs/datalake", title: "ClickHouse prend-il en charge les lacs de données ?", description: "ClickHouse prend en charge les lacs de données, notamment Iceberg, Delta Lake, Apache Hudi, Apache Paimon, Hive", href: "/fr/resources/support-center/knowledge-base/general-faqs/datalake", category: "General & FAQs", tags: [] }, { id: "general-faqs/distributed-join", title: "ClickHouse prend-il en charge les JOIN distribués ?", description: "ClickHouse prend en charge les JOIN distribués", href: "/fr/resources/support-center/knowledge-base/general-faqs/distributed-join", category: "General & FAQs", tags: [] }, { id: "general-faqs/federated", title: "ClickHouse prend-il en charge les requêtes fédérées ?", description: "ClickHouse prend en charge un large éventail de requêtes fédérées et hybrides", href: "/fr/resources/support-center/knowledge-base/general-faqs/federated", category: "General & FAQs", tags: [] }, { id: "general-faqs/concurrency", title: "ClickHouse prend-il en charge les requêtes fréquentes et simultanées ?", description: "ClickHouse prend en charge un QPS élevé et une haute simultanéité", href: "/fr/resources/support-center/knowledge-base/general-faqs/concurrency", category: "General & FAQs", tags: [] }, { id: "cloud-services/multi-region-replication", title: "ClickHouse prend-il en charge la réplication multi-région ?", description: "Cette page répond à la question de savoir si ClickHouse prend en charge la réplication multi-région", href: "/fr/resources/support-center/knowledge-base/cloud-services/multi-region-replication", category: "Cloud", tags: [] }, { id: "general-faqs/updates", title: "ClickHouse prend-il en charge les mises à jour en temps réel ?", description: "ClickHouse prend en charge les mises à jour légères en temps réel", href: "/fr/resources/support-center/knowledge-base/general-faqs/updates", category: "General & FAQs", tags: [] }, { id: "security/row-column-policy", title: "ClickHouse prend-il en charge la sécurité au niveau des lignes et des colonnes ?", description: "Découvrez les restrictions d'accès au niveau des lignes et des colonnes dans ClickHouse et ClickHouse Cloud, et comment mettre en œuvre le contrôle d'accès basé sur les rôles (RBAC) avec des politiques.", href: "/fr/resources/support-center/knowledge-base/security/row-column-policy", category: "Security & access control", tags: ["Security and Authentication"] }, { id: "cloud-services/execute-system-queries-in-cloud", title: "Exécuter des instructions SYSTEM sur tous les nœuds dans ClickHouse Cloud", description: "Apprenez à utiliser `ON CLUSTER` et `clusterAllReplicas` pour exécuter des instructions et des requêtes SYSTEM sur tous les nœuds d'un service ClickHouse Cloud.", href: "/fr/resources/support-center/knowledge-base/cloud-services/execute-system-queries-in-cloud", category: "Cloud", tags: ["Deployments and Scaling"] }, { id: "troubleshooting/count-parts-by-type", title: "Trouver les nombres et les tailles des parties larges ou compactes", description: "Cet article de la base de connaissances vous montre comment trouver le nombre de parties par type de partie - large ou compacte.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/count-parts-by-type", category: "Troubleshooting & errors", tags: ["Troubleshooting"] }, { id: "troubleshooting/fix-developer-verification-error-in-macos", title: "Corriger l'erreur de vérification du développeur dans macOS", description: "Apprenez à résoudre l'erreur de vérification du développeur MacOS lors de l'exécution de commandes ClickHouse, en utilisant les Paramètres système ou le terminal.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/fix-developer-verification-error-in-macos", category: "Troubleshooting & errors", tags: ["Errors and Exceptions"] }, { id: "data-import-export/s3-export-data-year-month-folders", title: "Comment effectuer des écritures partitionnées par année et par mois sur S3 ?", description: "Apprenez à écrire des données partitionnées par année et par mois dans un bucket S3 dans ClickHouse, en utilisant une structure de chemin personnalisée pour organiser les données.", href: "/fr/resources/support-center/knowledge-base/data-import-export/s3-export-data-year-month-folders", category: "Data import & export", tags: ["Data Export", "Native Clients and Interfaces"] }, { id: "data-import-export/kafka-clickhouse-json", title: "Comment utiliser le nouveau type de données JSON avec Kafka ?", description: "Learn how to load JSON messages from Apache Kafka directly into a single JSON column in ClickHouse using the Kafka table engine and JSON data type.", href: "/fr/resources/support-center/knowledge-base/data-import-export/kafka-clickhouse-json", category: "Data import & export", tags: ["Data Formats", "Data Ingestion"] }, { id: "cloud-services/change-billing-email", title: "Comment modifier mon contact de facturation dans ClickHouse Cloud ?", description: "Let's learn how to change your billing address in ClickHouse Cloud.", href: "/fr/resources/support-center/knowledge-base/cloud-services/change-billing-email", category: "Cloud", tags: ["Managing Cloud"] }, { id: "general-faqs/how-do-i-contribute-code-to-clickhouse", title: "How do I contribute code to ClickHouse?", description: "ClickHouse is an open-source project developed on GitHub. As customary, contribution instructions are published in CONTRIBUTING file in the root of the source code repository.", href: "/fr/resources/support-center/knowledge-base/general-faqs/how-do-i-contribute-code-to-clickhouse", category: "General & FAQs", tags: ["Community"] }, { id: "data-import-export/parquet-to-csv-json", title: "How do I convert files from Parquet to CSV or JSON?", description: "Learn how to use ClickHouse's `clickhouse-local` tool to easily convert Parquet files to CSV or JSON formats.", href: "/fr/resources/support-center/knowledge-base/data-import-export/parquet-to-csv-json", category: "Data import & export", tags: ["Data Sources", "Data Formats"] }, { id: "data-import-export/mysql-to-parquet-csv-json", title: "How do I export MySQL data to Parquet, CSV, or JSON using ClickHouse", description: "Learn how to use the `clickhouse-local` tool to export MySQL data into formats like Parquet, CSV, or JSON quickly and efficiently.", href: "/fr/resources/support-center/knowledge-base/data-import-export/mysql-to-parquet-csv-json", category: "Data import & export", tags: ["Data Formats", "Data Export"] }, { id: "data-import-export/postgresql-to-parquet-csv-json", title: "How do I export PostgreSQL data to Parquet, CSV or JSON?", description: "Learn how to export PostgreSQL data to Parquet, CSV, or JSON formats using `clickhouse-local` with various examples.", href: "/fr/resources/support-center/knowledge-base/data-import-export/postgresql-to-parquet-csv-json", category: "Data import & export", tags: ["Data Export", "Data Formats"] }, { id: "setup-installation/install-clickhouse-windows10", title: "How do I install ClickHouse on Windows 10?", description: "Learn how to install and test ClickHouse on Windows 10 using WSL 2. Includes setup, troubleshooting, and running a test environment.", href: "/fr/resources/support-center/knowledge-base/setup-installation/install-clickhouse-windows10", category: "Setup & installation", tags: ["Tools and Utilities"] }, { id: "security/remove-default-user", title: "How do I remove the default user?", description: "Learn how to remove the default user when running ClickHouse Server.", href: "/fr/resources/support-center/knowledge-base/security/remove-default-user", category: "Security & access control", tags: ["Server Admin"] }, { id: "cloud-services/ingest-failures-23-9-release", title: "How do I resolve ingest failures after ClickHouse 23.9 release?", description: "Learn how to resolve ingest failures caused by stricter grant checking introduced in ClickHouse 23.9 for tables using `async_inserts`. Update grants to fix errors.", href: "/fr/resources/support-center/knowledge-base/cloud-services/ingest-failures-23-9-release", category: "Cloud", tags: ["Errors and Exceptions"] }, { id: "performance-optimization/insert-select-settings-tuning", title: "How do I solve TOO MANY PARTS error during an INSERT...SELECT?", description: "Resolve the TOO_MANY_PARTS error in ClickHouse during an `INSERT...SELECT` by tuning expert-level settings for larger blocks and increasing partition thresholds.", href: "/fr/resources/support-center/knowledge-base/performance-optimization/insert-select-settings-tuning", category: "Performance & optimization", tags: ["Settings", "Errors and Exceptions"] }, { id: "integrations/node-js-example", title: "How do I use NodeJS with @clickhouse/client", description: "Learn how to use @clickhouse/client in a Node.js application to interact with ClickHouse and perform queries.", href: "/fr/resources/support-center/knowledge-base/integrations/node-js-example", category: "Integrations & client libraries", tags: ["Language Clients"] }, { id: "monitoring-debugging/view-number-of-active-mutations", title: "How do I view the number of active or queued mutations?", description: "Monitor the number of active or queued mutations in ClickHouse, especially when performing `ALTER` or `UPDATE` operations. Use the `system.mutations` table for tracking mutations.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/view-number-of-active-mutations", category: "Monitoring & debugging", tags: ["System Tables"] }, { id: "data-management/read-consistency", title: "How to achieve data read consistency in ClickHouse?", description: "Learn how to ensure data consistency when reading from ClickHouse, whether you're connected to the same node or a random node.", href: "/fr/resources/support-center/knowledge-base/data-management/read-consistency", category: "Data management", tags: ["Performance and Optimizations"] }, { id: "setup-installation/llvm-clang-up-to-date", title: "How to build LLVM and clang on Linux", description: "Commands to build LLVM and clang on Linux.", href: "/fr/resources/support-center/knowledge-base/setup-installation/llvm-clang-up-to-date", category: "Setup & installation", tags: ["Community", "Tools and Utilities"] }, { id: "data-management/calculate-ratio-of-zero-sparse-serialization", title: "How to calculate the ratio of empty/zero values in every column in a table", description: "Learn how to calculate the ratio of empty or zero values in every column of a ClickHouse table to optimize sparse column serialization.", href: "/fr/resources/support-center/knowledge-base/data-management/calculate-ratio-of-zero-sparse-serialization", category: "Data management", tags: ["Performance and Optimizations"] }, { id: "security/check-users-roles", title: "How to Check Users Assigned to Roles and Vice Versa", description: "Learn how to query ClickHouse's `system.role_grants` to find users assigned to roles and roles assigned to specific users.", href: "/fr/resources/support-center/knowledge-base/security/check-users-roles", category: "Security & access control", tags: ["Server Admin", "System Tables", "Managing Cloud"] }, { id: "monitoring-debugging/which-processes-are-currently-running", title: "How to check what code is currently running on a server?", description: "ClickHouse provides introspection tools like `system.stack_trace` for inspecting what code is currently running on each server thread, helping with debugging and performance monitoring.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/which-processes-are-currently-running", category: "Monitoring & debugging", tags: ["Server Admin"] }, { id: "cloud-services/how-to-check-my-clickhouse-cloud-sevice-state", title: "Comment vérifier l'état de votre service ClickHouse Cloud", description: "Learn how to use the ClickHouse Cloud API to check if your service is stopped, idle, or running without waking it up.", href: "/fr/resources/support-center/knowledge-base/cloud-services/how-to-check-my-clickhouse-cloud-sevice-state", category: "Cloud", tags: ["Managing Cloud"] }, { id: "monitoring-debugging/collect-and-draw-traces", title: "Comment collecter et dessiner une trace de requête", description: "Ce guide vous explique comment collecter et visualiser des traces de requêtes avec ClickHouse autogéré, en utilisant soit des méthodes intégrées, soit Grafana. Cela s'avère particulièrement utile lorsque vous travaillez avec des requêtes complexes et que vous avez besoin de comprendre les mécanismes d'exécution internes au-delà de ce que fournit EXPLAIN.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/collect-and-draw-traces", category: "Monitoring & debugging", tags: ["Tools and Utilities"] }, { id: "configuration-settings/configure-a-user-setting", title: "Comment configurer les paramètres pour un utilisateur dans ClickHouse", description: "Apprenez à définir des paramètres dans ClickHouse pour des requêtes individuelles, des sessions client ou des utilisateurs spécifiques à l'aide des commandes `SET` et `ALTER USER`.", href: "/fr/resources/support-center/knowledge-base/configuration-settings/configure-a-user-setting", category: "Configuration & settings", tags: ["Settings"] }, { id: "materialized-views/projection-example", title: "Comment vérifier si une projection est utilisée par la requête ?", description: "Apprenez à vérifier si une projection est utilisée dans les requêtes ClickHouse en testant avec des données d'exemple et en utilisant EXPLAIN pour confirmer l'utilisation de la projection.", href: "/fr/resources/support-center/knowledge-base/materialized-views/projection-example", category: "Materialized views & projections", tags: ["Data Modelling"] }, { id: "cloud-services/how-to-connect-to-ch-cloud-using-ssh-keys", title: "Comment se connecter à ClickHouse à l'aide de clés SSH", description: "Comment se connecter à ClickHouse et ClickHouse Cloud à l'aide de clés SSH", href: "/fr/resources/support-center/knowledge-base/cloud-services/how-to-connect-to-ch-cloud-using-ssh-keys", category: "Cloud", tags: ["Managing Cloud", "Security and Authentication"] }, { id: "data-management/dictionary-using-strings", title: "Comment créer un dictionnaire ClickHouse avec des clés et des valeurs de type chaîne", description: "Apprenez à créer un dictionnaire ClickHouse en utilisant des clés et des valeurs de type chaîne provenant d'une table MergeTree comme source, avec des exemples de configuration et d'utilisation.", href: "/fr/resources/support-center/knowledge-base/data-management/dictionary-using-strings", category: "Data management", tags: ["Data Modelling"] }, { id: "tables-schema/how-to-create-table-to-query-multiple-remote-clusters", title: "Comment créer une table capable d'interroger plusieurs clusters distants", description: "Comment créer une table capable d'interroger plusieurs clusters distants", href: "/fr/resources/support-center/knowledge-base/tables-schema/how-to-create-table-to-query-multiple-remote-clusters", category: "Tables & schema", tags: ["Deployments and Scaling"] }, { id: "setup-installation/enabling-ssl-with-lets-encrypt", title: "Comment activer SSL avec Let's Encrypt sur un seul serveur ClickHouse", description: "Apprenez à configurer SSL pour un seul serveur ClickHouse à l'aide de Let's Encrypt, notamment l'émission de certificats, la configuration et la validation.", href: "/fr/resources/support-center/knowledge-base/setup-installation/enabling-ssl-with-lets-encrypt", category: "Setup & installation", tags: ["Security and Authentication"] }, { id: "data-import-export/file-export", title: "Comment exporter des données de ClickHouse vers un fichier", description: "Découvrez différentes méthodes pour exporter des données depuis ClickHouse, notamment `INTO OUTFILE`, le moteur de table File et la redirection en ligne de commande.", href: "/fr/resources/support-center/knowledge-base/data-import-export/file-export", category: "Data import & export", tags: ["Data Export"] }, { id: "queries-sql/how-to-filter-a-clickhouse-table-by-an-array-column", title: "Comment filtrer une table ClickHouse par une colonne de type tableau ?", description: "Article de la base de connaissances sur la façon de filtrer une table ClickHouse par une colonne de type tableau.", href: "/fr/resources/support-center/knowledge-base/queries-sql/how-to-filter-a-clickhouse-table-by-an-array-column", category: "Queries & SQL", tags: ["Data Modelling", "Functions"] }, { id: "monitoring-debugging/generate-har-file", title: "Comment générer un fichier HAR pour le support", description: "Un fichier HAR (HTTP Archive) capture l'activité réseau dans votre navigateur. Il peut aider notre équipe de support à diagnostiquer les chargements de page lents, les requêtes échouées ou d'autres problèmes réseau.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/generate-har-file", category: "Monitoring & debugging", tags: ["Tools and Utilities"] }, { id: "materialized-views/how-to-display-queries-using-mv", title: "Comment identifier les requêtes utilisant des vues matérialisées dans ClickHouse", description: "Apprenez à interroger les journaux ClickHouse pour identifier toutes les requêtes impliquant des vues matérialisées dans une plage de temps spécifiée.", href: "/fr/resources/support-center/knowledge-base/materialized-views/how-to-display-queries-using-mv", category: "Materialized views & projections", tags: ["System Tables"] }, { id: "performance-optimization/find-expensive-queries", title: "Comment identifier les requêtes les plus coûteuses dans ClickHouse", description: "Apprenez à utiliser la table `query_log` dans ClickHouse pour identifier les requêtes les plus gourmandes en mémoire et en CPU sur les nœuds distribués.", href: "/fr/resources/support-center/knowledge-base/performance-optimization/find-expensive-queries", category: "Performance & optimization", tags: ["Performance and Optimizations"] }, { id: "configuration-settings/ignoring-incorrect-settings", title: "Comment ignorer les paramètres incorrects dans ClickHouse", description: "Apprenez à utiliser l'option `skip_check_for_incorrect_settings` pour permettre à ClickHouse de démarrer même lorsque des paramètres au niveau utilisateur sont spécifiés de manière incorrecte.", href: "/fr/resources/support-center/knowledge-base/configuration-settings/ignoring-incorrect-settings", category: "Configuration & settings", tags: ["Settings"] }, { id: "data-import-export/json-import", title: "Comment importer du JSON dans ClickHouse ?", description: "Cette page vous explique comment importer du JSON dans ClickHouse", href: "/fr/resources/support-center/knowledge-base/data-import-export/json-import", category: "Data import & export", tags: [] }, { id: "setup-installation/how-to-increase-thread-pool-size", title: "Comment augmenter le nombre de threads dans ClickHouse", description: "Apprenez à configurer le pool de threads global dans ClickHouse en ajustant des paramètres tels que `max_thread_pool_size`, `thread_pool_queue_size` et `max_thread_pool_free_size`.", href: "/fr/resources/support-center/knowledge-base/setup-installation/how-to-increase-thread-pool-size", category: "Setup & installation", tags: ["Performance and Optimizations"] }, { id: "data-import-export/kafka-to-clickhouse-setup", title: "Comment ingérer des données de Kafka dans ClickHouse", description: "Apprenez à ingérer des données d'un topic Kafka dans ClickHouse à l'aide du moteur de table Kafka, des vues matérialisées et des tables MergeTree.", href: "/fr/resources/support-center/knowledge-base/data-import-export/kafka-to-clickhouse-setup", category: "Data import & export", tags: ["Data Ingestion"] }, { id: "data-import-export/ingest-parquet-files-in-s3", title: "Comment ingérer des fichiers Parquet depuis un bucket S3", description: "Apprenez les bases de l'utilisation du moteur de table S3 dans ClickHouse pour ingérer et interroger des fichiers Parquet depuis un bucket S3, notamment la configuration, les autorisations d'accès et des exemples d'importation de données.", href: "/fr/resources/support-center/knowledge-base/data-import-export/ingest-parquet-files-in-s3", category: "Data import & export", tags: ["Data Ingestion"] }, { id: "queries-sql/how-to-insert-all-rows-from-another-table", title: "Comment insérer toutes les lignes d'une table dans une autre ?", description: "Article de la base de connaissances sur la façon d'insérer toutes les lignes d'une table dans une autre.", href: "/fr/resources/support-center/knowledge-base/queries-sql/how-to-insert-all-rows-from-another-table", category: "Queries & SQL", tags: ["Data Ingestion"] }, { id: "performance-optimization/check-query-processing-time-only", title: "Comment mesurer le temps de traitement des requêtes sans retourner de lignes", description: "Apprenez à utiliser l'option `FORMAT Null` dans ClickHouse pour mesurer le temps de traitement des requêtes sans retourner aucune ligne au client.", href: "/fr/resources/support-center/knowledge-base/performance-optimization/check-query-processing-time-only", category: "Performance & optimization", tags: ["Performance and Optimizations"] }, { id: "cloud-services/opt-out-core-dump-collection", title: "Comment se désabonner de la collecte des rapports de plantage", description: "Cet article vous explique comment vous désabonner de la collecte des rapports de plantage sur ClickHouse Cloud", href: "/fr/resources/support-center/knowledge-base/cloud-services/opt-out-core-dump-collection", category: "Cloud", tags: ["Managing Cloud"] }, { id: "monitoring-debugging/outputSendLogsLevelTracesToFile", title: "Comment envoyer les traces de niveau de journaux vers un fichier à l'aide du clickhouse-client", description: "Comment envoyer les traces de niveau de journaux vers un fichier à l'aide du clickhouse-client", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/outputSendLogsLevelTracesToFile", category: "Monitoring & debugging", tags: ["Data Export"] }, { id: "tables-schema/recreate-table-across-terminals", title: "Comment recréer rapidement une petite table sur différents terminaux", description: "Apprenez à recréer rapidement une petite table et ses données sur différents terminaux en utilisant le copier/coller pour les environnements de développement.", href: "/fr/resources/support-center/knowledge-base/tables-schema/recreate-table-across-terminals", category: "Tables & schema", tags: ["Tools and Utilities"] }, { id: "troubleshooting/recovering-from-corrupt-keeper-snapshot", title: "Comment récupérer après un snapshot Keeper corrompu", description: "Article décrivant comment récupérer après un snapshot Keeper corrompu : comment le problème se manifeste, ce qu'est un snapshot, où le trouver et les stratégies de récupération possibles.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/recovering-from-corrupt-keeper-snapshot", category: "Troubleshooting & errors", tags: ["Troubleshooting"] }, { id: "troubleshooting/restore-replica-after-storage-failure", title: "Comment restaurer un réplica après une défaillance de stockage", description: "Cet article explique comment récupérer des données lors de l'utilisation de tables répliquées dans des bases de données atomiques dans ClickHouse lorsque les disques/le stockage d'un des réplicas sont perdus ou corrompus.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/restore-replica-after-storage-failure", category: "Troubleshooting & errors", tags: ["Deployments and Scaling"] }, { id: "integrations/how-to-set-up-ch-on-docker-odbc-connect-mssql", title: "Comment configurer ClickHouse sur Docker avec ODBC pour se connecter à une base de données Microsoft SQL Server (MSSQL)", description: "Comment configurer ClickHouse sur Docker avec ODBC pour se connecter à une base de données Microsoft SQL Server (MSSQL)", href: "/fr/resources/support-center/knowledge-base/integrations/how-to-set-up-ch-on-docker-odbc-connect-mssql", category: "Integrations & client libraries", tags: ["Native Clients and Interfaces"] }, { id: "queries-sql/using-array-join-to-extract-and-query-attributes", title: "Comment utiliser array join pour extraire et interroger des attributs variables à l'aide de clés et de valeurs de map", description: "Exemple simple illustrant comment utiliser array join pour extraire et interroger des attributs variables à l'aide de clés et de valeurs de map", href: "/fr/resources/support-center/knowledge-base/queries-sql/using-array-join-to-extract-and-query-attributes", category: "Queries & SQL", tags: ["Functions"] }, { id: "materialized-views/how-to-use-parametrised-views", title: "Comment utiliser les vues paramétrées dans ClickHouse", description: "Apprenez à créer et interroger des vues paramétrées dans ClickHouse pour le découpage dynamique des données basé sur des paramètres au moment de la requête.", href: "/fr/resources/support-center/knowledge-base/materialized-views/how-to-use-parametrised-views", category: "Materialized views & projections", tags: ["Use Cases"] }, { id: "tables-schema/exchangeStatementToSwitchTables", title: "Comment utiliser la commande exchange pour permuter des tables", description: "Comment utiliser la commande exchange pour permuter des tables", href: "/fr/resources/support-center/knowledge-base/tables-schema/exchangeStatementToSwitchTables", category: "Tables & schema", tags: ["Managing Data"] }, { id: "queries-sql/compare-resultsets", title: "Comment valider si deux requêtes retournent les mêmes ensembles de résultats", description: "Apprenez à valider que deux requêtes ClickHouse produisent des ensembles de résultats identiques à l'aide de fonctions de hachage et de techniques de comparaison.", href: "/fr/resources/support-center/knowledge-base/queries-sql/compare-resultsets", category: "Queries & SQL", tags: ["Functions"] }, { id: "monitoring-debugging/check-query-cache-in-use", title: "Comment vérifier l'utilisation du cache de requêtes dans ClickHouse", description: "Apprenez à vérifier si le cache de requêtes est utilisé dans ClickHouse à l'aide des journaux de trace `clickhouse-client` ou des commandes SQL.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/check-query-cache-in-use", category: "Monitoring & debugging", tags: ["Performance and Optimizations"] }, { id: "cloud-services/unable-to-access-cloud-service", title: "Je n'arrive pas à accéder à un service ClickHouse Cloud", description: "Résolution des problèmes d'accès aux services ClickHouse Cloud, y compris la configuration de la liste d'accès IP", href: "/fr/resources/support-center/knowledge-base/cloud-services/unable-to-access-cloud-service", category: "Cloud", tags: ["Errors and Exceptions", "Managing Cloud"] }, { id: "performance-optimization/finding-expensive-queries-by-memory-usage", title: "Identification des requêtes coûteuses par utilisation de la mémoire dans ClickHouse", description: "Apprenez à utiliser la table `system.query_log` pour trouver les requêtes les plus gourmandes en mémoire dans ClickHouse, avec des exemples pour les configurations en cluster et autonomes.", href: "/fr/resources/support-center/knowledge-base/performance-optimization/finding-expensive-queries-by-memory-usage", category: "Performance & optimization", tags: ["Performance and Optimizations"] }, { id: "data-import-export/importing-and-working-with-json-array-objects", title: "Importation et interrogation d'objets de tableau JSON dans ClickHouse", description: "Apprenez à importer des objets de tableau JSON dans ClickHouse et à effectuer des requêtes avancées à l'aide de fonctions JSON et d'opérations sur les tableaux.", href: "/fr/resources/support-center/knowledge-base/data-import-export/importing-and-working-with-json-array-objects", category: "Data import & export", tags: ["Data Formats"] }, { id: "data-import-export/importing-geojason-with-nested-object-array", title: "Importation de GeoJSON avec un tableau d'objets profondément imbriqué", description: "Apprenez à importer des fichiers GeoJSON avec des tableaux d'objets profondément imbriqués dans ClickHouse et à interroger les données de fonctionnalités imbriquées.", href: "/fr/resources/support-center/knowledge-base/data-import-export/importing-geojason-with-nested-object-array", category: "Data import & export", tags: ["Data Formats"] }, { id: "performance-optimization/improve-map-performance", title: "Amélioration des performances de recherche dans les Map dans ClickHouse", description: "Apprenez à optimiser les recherches dans les colonnes Map dans ClickHouse pour de meilleures performances de requête en matérialisant des clés spécifiques en tant que colonnes autonomes.", href: "/fr/resources/support-center/knowledge-base/performance-optimization/improve-map-performance", category: "Performance & optimization", tags: ["Performance and Optimizations"] }, { id: "tables-schema/delete-old-data", title: "Est-il possible de supprimer d'anciens enregistrements d'une table ClickHouse ?", description: "Cette page répond à la question de savoir s'il est possible de supprimer d'anciens enregistrements d'une table ClickHouse", href: "/fr/resources/support-center/knowledge-base/tables-schema/delete-old-data", category: "Tables & schema", tags: [] }, { id: "general-faqs/separate-storage", title: "Est-il possible de déployer ClickHouse avec un stockage et un calcul séparés ?", description: "Cette page fournit une réponse à la question de savoir s'il est possible de déployer ClickHouse avec un stockage et un calcul séparés", href: "/fr/resources/support-center/knowledge-base/general-faqs/separate-storage", category: "General & FAQs", tags: [] }, { id: "data-import-export/json-extract-example", title: "Exemple d'extraction JSON", description: "Un court exemple sur la façon d'extraire des types de base à partir de JSON", href: "/fr/resources/support-center/knowledge-base/data-import-export/json-extract-example", category: "Data import & export", tags: ["Data Formats"] }, { id: "queries-sql/calculate-pi-using-sql", title: "Calculons pi en utilisant SQL", description: "It's Pi Day! Let's calculate pi using ClickHouse SQL", href: "/fr/resources/support-center/knowledge-base/queries-sql/calculate-pi-using-sql", category: "Queries & SQL", tags: ["Use Cases"] }, { id: "cloud-services/clickhouse-cloud-api-usage", title: "Managing ClickHouse Cloud Service with API and cURL", description: "Learn how to start, stop, and resume a ClickHouse Cloud service using API endpoints and cURL commands.", href: "/fr/resources/support-center/knowledge-base/cloud-services/clickhouse-cloud-api-usage", category: "Cloud", tags: ["Managing Cloud", "Tools and Utilities"] }, { id: "monitoring-debugging/mapping-of-system-metrics-to-prometheus-metrics", title: "Mapping of metrics used in system.dashboards to Prometheus metrics in `system.custom_metrics`", description: "Mapping of metrics used in system.dashboards to Prometheus metrics in system.custom_metrics", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/mapping-of-system-metrics-to-prometheus-metrics", category: "Monitoring & debugging", tags: ["System Tables"] }, { id: "security/windows-active-directory-to-ch-roles", title: "Mapping Windows Active Directory security groups to ClickHouse roles", description: "Example of mapping Windows Active Directory security groups to ClickHouse roles", href: "/fr/resources/support-center/knowledge-base/security/windows-active-directory-to-ch-roles", category: "Security & access control", tags: ["Tools and Utilities"] }, { id: "performance-optimization/memory-limit-exceeded-for-query", title: "Memory limit exceeded for query", description: "Troubleshooting memory limit exceeded errors for a query", href: "/fr/resources/support-center/knowledge-base/performance-optimization/memory-limit-exceeded-for-query", category: "Performance & optimization", tags: ["Errors and Exceptions"] }, { id: "integrations/ODBC-authentication-failed-error-using-PowerBI-CH-connector", title: "ODBC authentication failed error when using the Power BI ClickHouse connector", description: "ODBC authentication failed error when using the Power BI ClickHouse connector", href: "/fr/resources/support-center/knowledge-base/integrations/ODBC-authentication-failed-error-using-PowerBI-CH-connector", category: "Integrations & client libraries", tags: ["Native Clients and Interfaces", "Errors and Exceptions"] }, { id: "monitoring-debugging/profiling-clickhouse-with-llvm-xray", title: "Profiling ClickHouse with LLVM's XRay", description: "Learn how to profile ClickHouse using LLVM's XRay instrumentation profiler, visualize traces, and analyze performance.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/profiling-clickhouse-with-llvm-xray", category: "Monitoring & debugging", tags: ["Performance and Optimizations", "Tools and Utilities"] }, { id: "integrations/python-http-requests", title: "Python quick example using HTTP requests module", description: "An example using Python and requests module to write and read to ClickHouse", href: "/fr/resources/support-center/knowledge-base/integrations/python-http-requests", category: "Integrations & client libraries", tags: ["Native Clients and Interfaces"] }, { id: "configuration-settings/maximum-number-of-tables-and-databases", title: "Recommended Maximum Databases, Tables, Partitions, and Parts in ClickHouse", description: "Learn the recommended maximum limits for databases, tables, partitions, and parts in a ClickHouse cluster to ensure optimal performance.", href: "/fr/resources/support-center/knowledge-base/configuration-settings/maximum-number-of-tables-and-databases", category: "Configuration & settings", tags: ["Performance and Optimizations", "Deployments and Scaling"] }, { id: "data-import-export/cannot-append-data-to-parquet-format", title: 'Resolving "Cannot Append Data in Parquet Format" error in ClickHouse', description: 'Are you getting the error "Cannot append data in format Parquet to file" error in ClickHouse? Let\'s take a look at how to resolve it.', href: "/fr/resources/support-center/knowledge-base/data-import-export/cannot-append-data-to-parquet-format", category: "Data import & export", tags: ["Errors and Exceptions", "Data Formats"] }, { id: "troubleshooting/exception-too-many-parts", title: 'Resolving "Too Many Parts" error in ClickHouse', description: 'Learn how to address the "Too many parts" error in ClickHouse by optimizing insert rates, configuring MergeTree settings, and managing partitions effectively.', href: "/fr/resources/support-center/knowledge-base/troubleshooting/exception-too-many-parts", category: "Troubleshooting & errors", tags: ["Errors and Exceptions"] }, { id: "troubleshooting/certificate-verify-failed-error", title: "Resolving SSL Certificate Verify Error in ClickHouse", description: "Learn how to resolve the SSL Exception CERTIFICATE_VERIFY_FAILED error.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/certificate-verify-failed-error", category: "Troubleshooting & errors", tags: ["Security and Authentication", "Errors and Exceptions"] }, { id: "troubleshooting/connection-timeout-remote-remoteSecure", title: "Resolving Timeout Errors with `remote` and `remoteSecure` Table Functions", description: "Learn how to fix timeout errors when using `remote` or `remoteSecure` table functions in ClickHouse by adjusting the connection timeout settings.", href: "/fr/resources/support-center/knowledge-base/troubleshooting/connection-timeout-remote-remoteSecure", category: "Troubleshooting & errors", tags: ["Errors and Exceptions"] }, { id: "tables-schema/runbook-json", title: "Runbook : schéma JSON", description: "Choisissez la bonne approche de schéma pour les données JSON dans ClickHouse — colonnes typées, hybride, JSON natif ou stockage en String", href: "/fr/resources/support-center/knowledge-base/tables-schema/runbook-json", category: "Tables & schema", tags: ["Runbooks", "Data Modelling"] }, { id: "tables-schema/search-across-node-for-tables-with-a-wildcard", title: "Searching across nodes for tables with a wildcard", description: "Learn how to search across nodes for tables with a wildcard.", href: "/fr/resources/support-center/knowledge-base/tables-schema/search-across-node-for-tables-with-a-wildcard", category: "Tables & schema", tags: ["Deployments and Scaling"] }, { id: "performance-optimization/query-max-execution-time", title: "Setting a limit on query execution time", description: "How to enforce limit on max query execution time", href: "/fr/resources/support-center/knowledge-base/performance-optimization/query-max-execution-time", category: "Performance & optimization", tags: ["Managing Cloud", "Settings"] }, { id: "data-import-export/json-simple-example", title: "Simple example flow for extracting JSON data using a landing table with a Materialized View", description: "Simple example flow for extracting JSON data using a landing table with a Materialized View", href: "/fr/resources/support-center/knowledge-base/data-import-export/json-simple-example", category: "Data import & export", tags: ["Data Formats"] }, { id: "performance-optimization/async-vs-optimize-read-in-order", title: "Synchronous data reading", description: "The new setting `allow_asynchronous_read_from_io_pool_for_merge_tree` allows the number of reading threads (streams) to be higher than the number of threads in the rest of the query execution pipeline.", href: "/fr/resources/support-center/knowledge-base/performance-optimization/async-vs-optimize-read-in-order", category: "Performance & optimization", tags: ["Settings", "Performance and Optimizations"] }, { id: "integrations/terraform-example", title: "Terraform example on how to use Cloud API", description: "This covers an example of how you can use terraform to create/delete clusters using the API", href: "/fr/resources/support-center/knowledge-base/integrations/terraform-example", category: "Integrations & client libraries", tags: ["Native Clients and Interfaces"] }, { id: "performance-optimization/tips-tricks-optimizing-basic-data-types-in-clickhouse", title: "Tips and tricks on optimizing basic data types in ClickHouse", description: "Tips and tricks on optimizing basic data types in ClickHouse", href: "/fr/resources/support-center/knowledge-base/performance-optimization/tips-tricks-optimizing-basic-data-types-in-clickhouse", category: "Performance & optimization", tags: ["Performance and Optimizations"] }, { id: "data-management/understanding-part-types-and-storage-formats", title: "Comprendre les types de parts et les formats de stockage", description: "Découvrez les différents types de parts (Wide vs Compact) et les formats de stockage (Full vs Packed) dans ClickHouse, et leur impact sur les performances.", href: "/fr/resources/support-center/knowledge-base/data-management/understanding-part-types-and-storage-formats", category: "Data management", tags: ["Core Data Concepts"] }, { id: "queries-sql/useful-queries-for-troubleshooting", title: "Useful queries for troubleshooting", description: "A collection of handy queries for troubleshooting ClickHouse, including monitoring table sizes, long-running queries, and errors.", href: "/fr/resources/support-center/knowledge-base/queries-sql/useful-queries-for-troubleshooting", category: "Queries & SQL", tags: ["Settings"] }, { id: "general-faqs/use-clickhouse-for-log-analytics", title: "Using ClickHouse for log analytics", description: "ClickHouse is popular for logs and metrics analysis because of the real-time analytics capabilities provided. Ready to find out more?", href: "/fr/resources/support-center/knowledge-base/general-faqs/use-clickhouse-for-log-analytics", category: "General & FAQs", tags: ["Use Cases"] }, { id: "queries-sql/filtered-aggregates", title: "Using filtered aggregates in ClickHouse", description: "Learn how to use filtered aggregates in ClickHouse with `-If` and `-Distinct` aggregate combinators to simplify query syntax and enhance analytics.", href: "/fr/resources/support-center/knowledge-base/queries-sql/filtered-aggregates", category: "Queries & SQL", tags: ["Functions"] }, { id: "general-faqs/dependencies", title: "What are the 3rd-party dependencies for running ClickHouse?", description: "ClickHouse is self-contained and has no runtime dependencies", href: "/fr/resources/support-center/knowledge-base/general-faqs/dependencies", category: "General & FAQs", tags: [] }, { id: "general-faqs/dbms-naming", title: 'What does "ClickHouse" mean?', description: 'Learn about What does "ClickHouse" mean?', href: "/fr/resources/support-center/knowledge-base/general-faqs/dbms-naming", category: "General & FAQs", tags: [] }, { id: "general-faqs/ne-tormozit", title: "What does “не тормозит” mean?", description: 'This page explains what "Не тормозит" means', href: "/fr/resources/support-center/knowledge-base/general-faqs/ne-tormozit", category: "General & FAQs", tags: [] }, { id: "integrations/oracle-odbc", title: "What if I have a problem with encodings when using Oracle via ODBC?", description: "This page provides guidance on what to do if you have a problem with encodings when using Oracle via ODBC", href: "/fr/resources/support-center/knowledge-base/integrations/oracle-odbc", category: "Integrations & client libraries", tags: [] }, { id: "general-faqs/columnar-database", title: "What is a columnar database?", description: "A columnar database stores the data of each column independently. This allows reading data from disk only for those columns that are used in any given query.", href: "/fr/resources/support-center/knowledge-base/general-faqs/columnar-database", category: "General & FAQs", tags: ["Core Data Concepts"] }, { id: "general-faqs/olap", title: "What is OLAP?", description: "An explainer on what Online Analytical Processing is", href: "/fr/resources/support-center/knowledge-base/general-faqs/olap", category: "General & FAQs", tags: [] }, { id: "performance-optimization/optimize-final-vs-final", title: "What is the difference between OPTIMIZE FINAL and FINAL?", description: "Discusses the differences between OPTIMIZE FINAL and FINAL, and when to use and avoid them.", href: "/fr/resources/support-center/knowledge-base/performance-optimization/optimize-final-vs-final", category: "Performance & optimization", tags: ["Core Data Concepts"] }, { id: "general-faqs/sql", title: "What SQL syntax does ClickHouse support?", description: "ClickHouse supports 100% of SQL syntax", href: "/fr/resources/support-center/knowledge-base/general-faqs/sql", category: "General & FAQs", tags: [] }, { id: "data-management/when-is-ttl-applied", title: "When are TTL rules applied, and do we have control over it?", description: "TTL rules in ClickHouse are eventually applied, and you can control when they are executed using the `merge_with_ttl_timeout` setting. Learn how to force TTL application and manage background threads for TTL execution.", href: "/fr/resources/support-center/knowledge-base/data-management/when-is-ttl-applied", category: "Data management", tags: ["Core Data Concepts"] }, { id: "setup-installation/production", title: "Which ClickHouse version to use in production?", description: "This page provides guidance on which ClickHouse version to use in production", href: "/fr/resources/support-center/knowledge-base/setup-installation/production", category: "Setup & installation", tags: [] }, { id: "general-faqs/who-is-using-clickhouse", title: "Who is using ClickHouse?", description: "Describes who is using ClickHouse", href: "/fr/resources/support-center/knowledge-base/general-faqs/who-is-using-clickhouse", category: "General & FAQs", tags: [] }, { id: "data-management/dictionaries-consistent-state", title: "Why can't I see my data in a dictionary in ClickHouse Cloud?", description: "There is an issue where data in dictionaries may not be visible immediately after creation.", href: "/fr/resources/support-center/knowledge-base/data-management/dictionaries-consistent-state", category: "Data management", tags: ["Managing Cloud", "Data Modelling"] }, { id: "general-faqs/why-recommend-clickhouse-keeper-over-zookeeper", title: "Why is ClickHouse Keeper recommended over ZooKeeper?", description: "ClickHouse Keeper improves upon ZooKeeper with features like reduced disk space usage, faster recovery, and less memory consumption, offering better performance for ClickHouse clusters.", href: "/fr/resources/support-center/knowledge-base/general-faqs/why-recommend-clickhouse-keeper-over-zookeeper", category: "General & FAQs", tags: ["Core Data Concepts"] }, { id: "monitoring-debugging/why-default-logging-verbose", title: "Why is ClickHouse logging so verbose by default?", description: "Learn why the ClickHouse developers chose to set a verbose logging level by default.", href: "/fr/resources/support-center/knowledge-base/monitoring-debugging/why-default-logging-verbose", category: "Monitoring & debugging", tags: ["Settings"] }, { id: "performance-optimization/why-is-my-primary-key-not-used", title: "Why is my primary key not used? How can I check?", description: "Covers a common reason why a primary key is not used in ordering and how we can confirm", href: "/fr/resources/support-center/knowledge-base/performance-optimization/why-is-my-primary-key-not-used", category: "Performance & optimization", tags: ["Performance and Optimizations"] }, { id: "general-faqs/mapreduce", title: "Why not use something like MapReduce?", description: "This page explains why you would use ClickHouse over MapReduce", href: "/fr/resources/support-center/knowledge-base/general-faqs/mapreduce", category: "General & FAQs", tags: [] }] }; export const KBExplorer = ({index, featured = []}) => { const featuredIds = featured.map(f => f.id); const assetBase = typeof window !== "undefined" && window.location.pathname.startsWith("/docs") ? "/docs" : ""; const withBase = p => p && p.startsWith("/") ? assetBase + p : p; const data = index || ({ categories: [], tags: [], articles: [] }); const readStoredList = (key, fallback) => { if (typeof window === "undefined") return fallback; try { const raw = localStorage.getItem(key); if (!raw) return fallback; const parsed = JSON.parse(raw); return Array.isArray(parsed) ? parsed : fallback; } catch { return fallback; } }; const [searchTerm, setSearchTerm] = useState(() => { if (typeof window !== "undefined") { return localStorage.getItem("kb-search") || ""; } return ""; }); const [selectedCategories, setSelectedCategories] = useState(() => readStoredList("kb-categories", ["All"])); const [currentPage, setCurrentPage] = useState(1); const itemsPerPage = 6; const [categoriesDropdownOpen, setCategoriesDropdownOpen] = useState(true); const [showFilters, setShowFilters] = useState(() => { if (typeof window !== "undefined") { return localStorage.getItem("kb-show-filters") !== "false"; } return true; }); const [isDesktop, setIsDesktop] = useState(true); useEffect(() => { if (typeof window === "undefined" || !window.matchMedia) return; const mq = window.matchMedia("(min-width: 1024px)"); const update = () => setIsDesktop(mq.matches); update(); mq.addEventListener("change", update); return () => mq.removeEventListener("change", update); }, []); useEffect(() => { if (typeof window !== "undefined") localStorage.setItem("kb-search", searchTerm); }, [searchTerm]); useEffect(() => { if (typeof window !== "undefined") localStorage.setItem("kb-categories", JSON.stringify(selectedCategories)); }, [selectedCategories]); useEffect(() => { if (typeof window !== "undefined") localStorage.setItem("kb-show-filters", String(showFilters)); }, [showFilters]); useEffect(() => { setCurrentPage(1); }, [searchTerm, selectedCategories]); const makeToggle = setter => value => { setter(prev => { if (value === "All") return ["All"]; const withoutAll = prev.filter(v => v !== "All"); const result = withoutAll.includes(value) ? withoutAll.filter(v => v !== value) : [...withoutAll, value]; return result.length === 0 ? ["All"] : result; }); }; const toggleCategory = makeToggle(setSelectedCategories); const categoryOptions = ["All", ...data.categories]; const resetFilters = () => { setSearchTerm(""); setSelectedCategories(["All"]); }; const hasActiveFilters = searchTerm !== "" || !selectedCategories.includes("All"); const filteredArticles = useMemo(() => { const term = searchTerm.toLowerCase(); return data.articles.filter(article => { if (featuredIds.includes(article.id)) return false; const matchesSearch = term === "" || article.title.toLowerCase().includes(term) || (article.description || "").toLowerCase().includes(term) || (article.tags || []).some(t => t.toLowerCase().includes(term)); const matchesCategory = selectedCategories.includes("All") || selectedCategories.includes(article.category); return matchesSearch && matchesCategory; }); }, [data.articles, searchTerm, selectedCategories, featuredIds]); const handleCardClick = (e, href) => { if (e.defaultPrevented) return; if (e.metaKey || e.ctrlKey || e.shiftKey || e.altKey || e.button !== 0) return; e.preventDefault(); window.location.assign(withBase(href)); }; const featuredArticles = featured.map(f => { const article = data.articles.find(a => a.id === f.id); return { id: f.id, href: article && article.href || `/fr/resources/support-center/knowledge-base/${f.id}`, title: article && article.title || "" }; }).filter(f => f.title); const Expandable = ({label, options, selectedOptions, onToggle, isOpen, setIsOpen}) => { const activeCount = selectedOptions.filter(o => o !== "All").length; const displayLabel = activeCount > 0 ? `${label} (${activeCount})` : label; return
{isOpen &&
{options.map(option => )}
}
; }; return <>
{} {featuredArticles.length > 0 &&

Articles à la une

{featuredArticles.map(article => handleCardClick(e, article.href)} className="group block rounded-xl overflow-hidden border border-gray-200 dark:border-white/10 transition-all hover:border-black dark:hover:border-[#FAFF69] hover:shadow-md"> {}
{article.title}
Populaire
)}
} {}
{}
{}
{}

Explorer les articles

{filteredArticles.length > 0 ? <> {} {(() => { const totalPages = Math.ceil(filteredArticles.length / itemsPerPage); if (totalPages <= 1) return null; const hasPrev = currentPage > 1; const hasNext = currentPage < totalPages; return
Page {currentPage} / {totalPages}
; })()} :

Aucun article ne correspond à vos critères.

Essayez d'ajuster vos filtres ou votre terme de recherche.

}
; }; export const featuredArticles = [{ id: 'cloud-services/aws-privatelink-setup-for-clickpipes' }, { id: 'tables-schema/schema-migration-tools' }, { id: 'data-management/read-consistency' }];
Image décorative d’arrière-plan. Image décorative d’arrière-plan.