ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.
ClickHouse®는 온라인 분석 처리(OLAP)를 위한 고성능 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 Cloud 서비스 형태로 제공됩니다.
분석이란 무엇입니까?
분석은 OLAP(Online Analytical Processing)이라고도 하며, 방대한 데이터셋에 대해 복잡한 계산(예: 집계, 문자열 처리, 산술 연산)을 수행하는 SQL 쿼리를 의미합니다.쿼리당 몇 개의 행만 읽고 쓰기 때문에 밀리초 단위로 완료되는 트랜잭션 쿼리(또는 OLTP, Online Transaction Processing)와 달리, 분석 쿼리는 일반적으로 수십억에서 수조 개의 행을 처리합니다.많은 사용 사례에서 분석 쿼리는 “실시간”이어야 합니다. 즉, 1초 이내에 결과를 반환해야 합니다.
행 지향 저장과 컬럼 지향 저장 비교
이와 같은 수준의 성능은 데이터의 올바른 “지향성”이 있어야만 달성할 수 있습니다.데이터베이스는 데이터를 행 지향 또는 컬럼 지향 방식으로 저장합니다.행 지향 데이터베이스에서는 테이블의 연속된 행이 차례대로 순차 저장됩니다. 이 방식에서는 각 행의 컬럼 값이 함께 저장되므로 행을 빠르게 조회할 수 있습니다.ClickHouse는 컬럼 지향 데이터베이스입니다. 이러한 시스템에서는 테이블이 컬럼들의 집합으로 저장되며, 즉 각 컬럼의 값이 차례대로 순차 저장됩니다. 이 방식에서는 단일 행을 복원하기가 더 어려워지지만(이제 행 값 사이에 간격이 생기기 때문입니다), filter나 집계와 같은 컬럼 연산은 행 지향 데이터베이스보다 훨씬 빨라집니다.이 차이는 실제 익명화된 웹 분석 데이터 1억 행에 대해 실행한 다음 예시 쿼리로 가장 잘 설명할 수 있습니다:
SELECT MobilePhoneModel, count() AS cFROM metrica.hitsWHERE RegionID = 229 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND MobilePhone != 0 AND MobilePhoneModel NOT IN ('', 'iPad')GROUP BY MobilePhoneModelORDER BY c DESCLIMIT 8;
위 그림의 통계 섹션에서 볼 수 있듯이, 이 쿼리는 1억 행을 92밀리초 만에 처리했으며, 처리량은 초당 약 10억 행 이상, 또는 초당 7 GB에 약간 못 미치는 데이터 전송량에 해당합니다.행 지향 DBMS행 지향 데이터베이스에서는 위 쿼리가 기존 컬럼 중 일부만 처리하더라도, 시스템은 여전히 다른 컬럼의 데이터도 디스크에서 메모리로 로드해야 합니다. 이는 데이터가 디스크에 블록이라고 하는 청크 단위로 저장되기 때문입니다(보통 4 KB 또는 8 KB 같은 고정 크기). 블록은 디스크에서 메모리로 읽어 오는 데이터의 가장 작은 단위입니다. 애플리케이션이나 데이터베이스가 데이터를 요청하면 운영 체제의 디스크 I/O 하위 시스템이 디스크에서 필요한 블록을 읽습니다. 블록의 일부만 필요하더라도 전체 블록이 메모리로 읽혀집니다(이는 디스크 및 파일 시스템 설계에 따른 것입니다):
컬럼 지향 DBMS각 컬럼의 값이 디스크에 순차적으로 저장되므로, 위 쿼리를 실행할 때 불필요한 데이터는 로드되지 않습니다.
디스크에서 메모리로의 block 단위 저장 및 전송이 분석 쿼리의 데이터 접근 패턴과 일치하므로, 쿼리에 필요한 컬럼만 디스크에서 읽어 사용되지 않는 데이터에 대한 불필요한 I/O를 피할 수 있습니다. 이는 전체 행(관련 없는 컬럼 포함)을 읽는 행 기반 저장 방식과 비교하면 훨씬 더 빠릅니다:
데이터 복제 및 무결성
ClickHouse는 여러 노드에 데이터를 중복 저장할 수 있도록 비동기 멀티 마스터 복제 방식을 사용합니다. 사용 가능한 아무 레플리카에 데이터를 쓰면, 나머지 모든 레플리카는 백그라운드에서 해당 데이터의 사본을 가져옵니다. 시스템은 서로 다른 레플리카에 동일한 데이터가 유지되도록 합니다. 대부분의 장애는 자동으로 복구되며, 복잡한 경우에는 반자동으로 복구됩니다.
역할 기반 접근 제어
ClickHouse는 SQL 쿼리를 사용해 사용자 계정을 관리하며, ANSI SQL 표준과 널리 사용되는 관계형 데이터베이스 관리 시스템과 유사한 역할 기반 접근 제어 구성을 지원합니다.
ClickHouse는 정확도와 성능을 절충할 수 있는 방법을 제공합니다. 예를 들어 일부 집계 함수는 고유값 개수, 중앙값, 분위수를 근사적으로 계산합니다. 또한 데이터의 일부 샘플에 대해 쿼리를 실행해 근사 결과를 빠르게 계산할 수 있습니다. 마지막으로 모든 키에 대해 집계를 수행하는 대신, 제한된 수의 키에 대해서만 집계를 수행할 수 있습니다. 키 분포가 얼마나 치우쳐 있는지에 따라, 이 방식은 정확 계산보다 훨씬 적은 리소스를 사용하면서도 상당히 정확한 결과를 제공할 수 있습니다.
적응형 조인 알고리즘
ClickHouse는 조인 알고리즘을 상황에 맞게 선택합니다. 먼저 빠른 해시 조인을 사용하고, 큰 테이블이 2개 이상이면 머지 조인으로 전환합니다.
뛰어난 쿼리 성능
ClickHouse는 매우 빠른 쿼리 성능을 제공하는 것으로 잘 알려져 있습니다.
ClickHouse가 왜 이렇게 빠른지 알아보려면 Why is ClickHouse fast? 가이드를 참조하십시오.
{"docsConfig":{"theme":"maple","$schema":"https://mintlify.com/docs.json","name":"ClickHouse Documentation","colors":{"primary":"#1c1c1c","light":"#333431","dark":"#fdff75"},"logo":{"light":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/light.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=b8a838f982def2b530a95016300bc7ec","dark":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/dark.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=563dcf3fc5bb3694597dec207c9b4ecf"},"favicon":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/favicon.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=9a2d9de19e9259c4b5260fa5bfa26851","appearance":{"default":"dark"},"background":{"color":{"light":"#FFFFFF","dark":"#151515"}},"navbar":{},"fonts":{"family":"Inter"},"styling":{"eyebrows":"breadcrumbs","latex":true},"integrations":{"clarity":{"projectId":"xgummrwgj9"},"gtm":{"tagId":"GTM-WTNTDT7W"}},"contextual":{"options":["copy","view","download-pdf",{"title":"Set up the ClickHouse documentation MCP server","description":"Setup instructions for the ClickHouse documentation MCP server","icon":"/images/icons/icon-mcp.svg","href":"https://clickhouse.com/docs/resources/support-center/knowledge-base/setup-installation/set-up-clickhouse-documentation-mcp-server"}],"display":"toc"},"interaction":{"drilldown":false},"metadata":{"timestamp":true},"variables":{"airgap_server_tag":"26.6.1.2455","airgap_keeper_tag":"26.2.1.918","airgap_operator_tag":"1.23255.1","airgap_operator_private_chart_tag":"1.23255.1","airgap_cr_helm_tag":"1.14.3","airgap_api_tag":"1.175.4","airgap_api_helm_tag":"1.175.4","airgap_preflight_chart_tag":"1.38.7","airgap_support_bundle_tag":"1.12.0"},"navigation":{"languages":[{"language":"en","href":""},{"language":"ar","href":"ar"},{"language":"es","href":"es"},{"language":"fr","href":"fr"},{"language":"ja","href":"ja"},{"language":"ko","href":"ko"},{"language":"pt-BR","href":"pt-BR"},{"language":"ru","href":"ru"},{"language":"zh","href":"zh"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"private-7c7dfe99","hasAudioNarration":false,"actualSubdomain":"private-7c7dfe99","customDomains":["clickhouse.com"],"gitSource":{"_id":"6ad7fa91692c7c940ff17a19","type":"github","owner":"clickhouse","repo":"clickhouse","deployBranch":"master","contentDirectory":"docs","isPrivate":false,"mountPath":"","label":""},"feedback":{"thumbs":true,"edits":true,"issues":true,"contextualFeedback":{"allowEmail":false},"agentFeedback":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED","enabled":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6aff4af2e02d768905ce0845","clientVersion":"0.0.4227","searchFilterCounts":[{"language":"en","tag":"Databases","count":1811},{"language":"ja","tag":"データベース","count":1792},{"language":"pt-BR","tag":"Bancos de dados","count":1792},{"language":"zh","tag":"数据库","count":1792},{"language":"ar","tag":"قواعد البيانات","count":1791},{"language":"es","tag":"Bases de datos","count":1791},{"language":"fr","tag":"Bases de données","count":1791},{"language":"ko","tag":"데이터베이스","count":1791},{"language":"ru","tag":"Базы данных","count":1791},{"language":"en","tag":"Reference","count":1582},{"language":"ar","tag":"المرجع","count":1565},{"language":"es","tag":"Referencia","count":1565},{"language":"fr","tag":"Référence","count":1565},{"language":"ja","tag":"リファレンス","count":1565},{"language":"ko","tag":"참고","count":1565},{"language":"pt-BR","tag":"Referência","count":1565},{"language":"ru","tag":"Справочник","count":1565},{"language":"zh","tag":"参考文档","count":1565},{"language":"en","tag":"Products","count":674},{"language":"es","tag":"Configuración","count":531},{"language":"ja","tag":"設定","count":531},{"language":"ar","tag":"المنتجات","count":513},{"language":"es","tag":"Productos","count":513},{"language":"fr","tag":"Produits","count":513},{"language":"ja","tag":"製品","count":513},{"language":"ko","tag":"제품","count":513},{"language":"pt-BR","tag":"Produtos","count":513},{"language":"ru","tag":"Продукты","count":513},{"language":"zh","tag":"产品","count":513},{"language":"en","tag":"Settings","count":512},{"language":"ar","tag":"الإعدادات","count":505},{"language":"fr","tag":"Paramètres","count":505},{"language":"ko","tag":"설정","count":505},{"language":"pt-BR","tag":"Configurações","count":505},{"language":"ru","tag":"Настройки","count":505},{"language":"zh","tag":"设置","count":505},{"language":"en","tag":"ClickHouse Observability","count":487},{"language":"en","tag":"Functions","count":330},{"language":"ar","tag":"الدوال","count":328},{"language":"es","tag":"Funciones","count":328},{"language":"fr","tag":"Fonctions","count":328},{"language":"ja","tag":"関数","count":328},{"language":"ko","tag":"함수","count":328},{"language":"pt-BR","tag":"Funções","count":328},{"language":"ru","tag":"Функции","count":328},{"language":"zh","tag":"函数","count":328},{"language":"en","tag":"Integrations","count":323},{"language":"ko","tag":"통합","count":296},{"language":"zh","tag":"集成","count":296},{"language":"ar","tag":"التكاملات","count":293},{"language":"es","tag":"Integraciones","count":293},{"language":"fr","tag":"Intégrations","count":293},{"language":"pt-BR","tag":"Integrações","count":293},{"language":"ru","tag":"Интеграции","count":293},{"language":"pt-BR","tag":"Recursos","count":291},{"language":"ja","tag":"インテグレーション","count":268},{"language":"en","tag":"Guides","count":265},{"language":"en","tag":"ClickHouse Cloud","count":264},{"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":"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":"es","tag":"Guías","count":219},{"language":"fr","tag":"Guides","count":219},{"language":"ja","tag":"ガイド","count":219},{"language":"ko","tag":"가이드","count":219},{"language":"pt-BR","tag":"Guias","count":219},{"language":"ru","tag":"Руководства","count":219},{"language":"zh","tag":"指南","count":219},{"language":"ar","tag":"الموارد","count":213},{"language":"es","tag":"Recursos","count":213},{"language":"fr","tag":"Ressources","count":213},{"language":"ja","tag":"リソース","count":213},{"language":"ko","tag":"자료","count":213},{"language":"ru","tag":"Ресурсы","count":213},{"language":"zh","tag":"资源","count":213},{"language":"default","tag":"Products","count":125},{"language":"default","tag":"ClickHouse Cloud","count":125},{"language":"default","tag":"Cloud API","count":79},{"language":"default","tag":"API reference","count":79},{"language":"default","tag":"ClickHouse Private","count":46},{"language":"default","tag":"Service","count":34},{"language":"default","tag":"Organization","count":31},{"language":"default","tag":"ClickStack","count":31},{"language":"default","tag":"How-To Guides","count":20},{"language":"default","tag":"Reference","count":10}],"searchSettings":{"maxResults":1}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"github-push-net-diff","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"_site/styles.css","href":"/docs/_mintlify/custom/private-7c7dfe99/9ce922f719fc2597/_site/styles.css"},{"filePath":"snippets/components/Badges/badges_styles.css","content":".betaBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.betaBadge::before{content:\"β\";flex:0 0 auto;margin-right:8px;font-size:1rem;font-weight:600;line-height:1}a.betaBadge{color:#1D4ED8!important;text-decoration:none!important}.dark .betaBadge{background-color:#1E3A6B;color:#93C5FD}.dark a.betaBadge{color:#93C5FD!important;text-decoration:none!important}.ClickHouseSupportedBadge{background-color:#faff69;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#161517;display:inline-flex;margin-right:5px;font-size:0.875rem}.ClickHouseSupportedIcon{margin-right:8px}.ClickHouseSupportedIcon svg path{fill:#282828}.ClickHouseSupportedBadge a{color:black}.dark .ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.dark .ClickHouseSupportedBadge a{color:#161517}.dark .ClickHouseSupportedIcon svg path{fill:#161517}.cloudNotSupportedBadge{background-color:#F6E5FF;color:#660099;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.cloudNotSupportedIcon{margin-right:8px}a.cloudNotSupportedBadge{color:#660099!important;text-decoration:none!important}.cloudNotSupportedIcon svg path{stroke:#660099}.dark .cloudNotSupportedBadge{background-color:#33004D;color:#EECCFF}.dark a.cloudNotSupportedBadge{color:#EECCFF!important;text-decoration:none!important}.dark .cloudNotSupportedIcon svg path{stroke:#EECCFF}.cloudBadge{background-color:#DAE6FC;color:#061D48;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .cloudBadge{background-color:#061D48;color:#DAE6FC}.cloudIcon{margin-right:8px}.cloudIcon svg path{stroke:#061D48}.dark .cloudIcon svg path{stroke:#DAE6FC}.CommunityMaintainedBadge{background-color:#69afff;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.CommunityMaintainedIcon{margin-right:8px}.CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.CommunityMaintainedBadge a{color:#69afff}.CommunityMaintainedBadge svg path{color:#69afff}.dark .CommunityMaintainedBadge{background-color:#69afff;color:#ffffff}.dark .CommunityMaintainedBadge a{color:#ffffff}.dark .CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.deprecatedBadge{background-color:#DFDFDF;color:#53575F;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.deprecatedIcon{margin-right:8px}.deprecatedBadge a{color:inherit}.dark .deprecatedBadge{background-color:#414141;color:#E6E7E9}.dark .deprecatedBadge a{color:inherit}.deprecatedIcon svg path{stroke:#53575F}.dark .deprecatedIcon svg path{stroke:#E6E7E9}.enterprisePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.enterprisePlanFeatureContainer p{margin:0;padding:0}.enterprisePlanFeatureBadge{background-color:#008A0B;border-style:solid;border:1px;border-color:#437EEF;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .enterprisePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .enterprisePlanFeatureBadge{background-color:#99FFA1;color:#1F1F1C}.experimentalBadge{background-color:#F3E8FF;border-radius:16px;color:#6D28D9;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.experimentalIcon{margin-right:8px}a.experimentalBadge{color:#6D28D9!important;text-decoration:none!important}.dark .experimentalBadge{background-color:#3B1D6B;color:#D8B4FE}.dark a.experimentalBadge{color:#D8B4FE!important;text-decoration:none!important}.experimentalIcon svg path{stroke:#6D28D9}.dark .experimentalIcon svg path{stroke:#D8B4FE}.PartnerBadge{background-color:#990073;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.PartnerBadgeIcon{margin-right:8px}.PartnerBadgeIcon svg path{fill:#fbc9ef;stroke:#990073}.PartnerBadge a{color:#990073}.PartnerBadge svg path{color:#990073}.dark .PartnerBadge{background-color:#990073;color:#fbeff8}.dark .PartnerBadge a{color:#fbeff8}.dark .PartnerBadgeIcon svg path{fill:#990073;stroke:#fbeff8}.privatePreviewBadge{background-color:#FEF3C7;color:#B45309;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .privatePreviewBadge{background-color:#4B3410;color:#FCD34D}.privatePreviewIcon{margin-right:8px}.privatePreviewIcon svg path{stroke:#B45309}.dark .privatePreviewIcon svg path{stroke:#FCD34D}.publicPreviewBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .publicPreviewBadge{background-color:#1E3A6B;color:#93C5FD}.scalePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.scalePlanFeatureContainer p{margin:0;padding:0}.scalePlanFeatureBadge{background-color:#1D64EC;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .scalePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .scalePlanFeatureBadge{background-color:#1D64EC;color:#FFFFFF}"},{"filePath":"snippets/components/ClickStackAnimation/ClickStackAnimation.css","content":".clickstack-animation-wrapper{width:100%;max-width:max-content;transition:opacity 0.3s ease}.clickstack-animation-inner{transform-origin:top left}.clickstack-grid{display:grid;width:537px;height:537px;grid-template-columns:repeat(3, 1fr);grid-template-rows:repeat(3, 1fr)}.clickstack-grid-item{position:relative;display:flex;align-items:center;justify-content:center}.clickstack-grid-column{display:flex;flex-direction:column;align-items:center}.clickstack-icon-box{display:flex;width:4rem;height:4rem;align-items:center;justify-content:center;border-radius:0.375rem;padding:1rem;flex-shrink:0;border:1px solid rgba(113, 113, 122, 0.8);background-color:#171717}.clickstack-svg-absolute{position:absolute}.clickstack-svg-left-center{left:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-right-center{right:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-bottom-left{bottom:50%;left:50%;transform:translateY(-2rem)}.clickstack-svg-bottom-right{bottom:50%;right:50%;transform:translateY(-2rem)}.clickstack-logo-container{position:relative}.clickstack-logo-glow{position:absolute;inset:0;z-index:0;animation:fadeInOut 3s ease-in-out infinite;background-color:rgba(250, 255, 105, 0.6);filter:blur(40px)}.clickstack-logo-box{position:absolute;inset:0;z-index:10;display:flex;border-radius:0.5rem;border:2px solid #faff69;background-color:#262626;background-image:linear-gradient(to bottom right, rgba(250, 255, 105, 0.2), rgba(250, 255, 105, 0.4))}.clickstack-logo-svg{margin:auto}@keyframes fadeInOut{0%,100%{opacity:0.3}50%{opacity:0.8}}:is(.light) .clickstack-logo-glow{display:none}:is(.light) .clickstack-logo-box{border-color:#faff69;background-color:#000000;background-image:none}.clickstack-line-bg{stroke:#414141}.clickstack-line-animated{stroke:#faff69}:is(.light) .clickstack-line-bg{stroke:#d4d4d8}:is(.light) .clickstack-line-animated{stroke:#a1a1aa}@media (max-width: 767px){.clickstack-animation-wrapper{max-width:400px}.clickstack-grid{width:400px;height:400px}}"}]}
{"page":{"pagePath":"ko/get-started/about/intro","slug":"/ko/get-started/about/intro","pageMetadata":{"slug":"/intro","sidebarTitle":"ClickHouse란 무엇입니까?","description":"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.","title":"ClickHouse란 무엇입니까?","keywords":["ClickHouse","컬럼형 데이터베이스","OLAP 데이터베이스","분석용 데이터베이스","고성능 데이터베이스"],"doc_type":"guide","href":"/ko/get-started/about/intro"},"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: \"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.\"\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`,code:`code`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,..._provideComponents(),...props.components},{CodeBlock,Frame,Heading,OptimizedImage}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`ClickHouse®는 온라인 분석 처리(OLAP)를 위한 고성능 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. `,_jsx(_components.a,{href:`https://github.com/ClickHouse/ClickHouse`,children:`오픈소스 소프트웨어`}),`와 `,_jsx(_components.a,{href:`https://clickhouse.com/cloud`,children:`Cloud 서비스`}),` 형태로 제공됩니다.`]}),`\n`,_jsx(`div`,{id:`what-are-analytics`,children:_jsx(Heading,{level:`2`,id:`분석이란-무엇입니까`,children:`분석이란 무엇입니까?`})}),`\n`,_jsx(_components.p,{children:`분석은 OLAP(Online Analytical Processing)이라고도 하며, 방대한 데이터셋에 대해 복잡한 계산(예: 집계, 문자열 처리, 산술 연산)을 수행하는 SQL 쿼리를 의미합니다.`}),`\n`,_jsx(_components.p,{children:`쿼리당 몇 개의 행만 읽고 쓰기 때문에 밀리초 단위로 완료되는 트랜잭션 쿼리(또는 OLTP, Online Transaction Processing)와 달리, 분석 쿼리는 일반적으로 수십억에서 수조 개의 행을 처리합니다.`}),`\n`,_jsxs(_components.p,{children:[`많은 사용 사례에서 `,_jsx(_components.a,{href:`https://clickhouse.com/engineering-resources/what-is-real-time-analytics`,children:`분석 쿼리는 “실시간”이어야 합니다`}),`. 즉, 1초 이내에 결과를 반환해야 합니다.`]}),`\n`,_jsx(`div`,{id:`row-oriented-vs-column-oriented-storage`,children:_jsx(Heading,{level:`2`,id:`행-지향-저장과-컬럼-지향-저장-비교`,children:`행 지향 저장과 컬럼 지향 저장 비교`})}),`\n`,_jsx(_components.p,{children:`이와 같은 수준의 성능은 데이터의 올바른 “지향성”이 있어야만 달성할 수 있습니다.`}),`\n`,_jsxs(_components.p,{children:[`데이터베이스는 데이터를 `,_jsx(_components.a,{href:`https://clickhouse.com/engineering-resources/what-is-columnar-database`,children:`행 지향 또는 컬럼 지향`}),` 방식으로 저장합니다.`]}),`\n`,_jsx(_components.p,{children:`행 지향 데이터베이스에서는 테이블의 연속된 행이 차례대로 순차 저장됩니다. 이 방식에서는 각 행의 컬럼 값이 함께 저장되므로 행을 빠르게 조회할 수 있습니다.`}),`\n`,_jsx(_components.p,{children:`ClickHouse는 컬럼 지향 데이터베이스입니다. 이러한 시스템에서는 테이블이 컬럼들의 집합으로 저장되며, 즉 각 컬럼의 값이 차례대로 순차 저장됩니다. 이 방식에서는 단일 행을 복원하기가 더 어려워지지만(이제 행 값 사이에 간격이 생기기 때문입니다), filter나 집계와 같은 컬럼 연산은 행 지향 데이터베이스보다 훨씬 빨라집니다.`}),`\n`,_jsxs(_components.p,{children:[`이 차이는 `,_jsx(_components.a,{href:`/ko/get-started/sample-datasets/anon-web-analytics-metrica`,children:`실제 익명화된 웹 분석 데이터`}),` 1억 행에 대해 실행한 다음 예시 쿼리로 가장 잘 설명할 수 있습니다:`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`11`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`11`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` MobilePhoneModel, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`count`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`() `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` c`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` metrica`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`hits`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`WHERE`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` RegionID `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 229`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AND`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` EventDate `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`>=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2013-07-01'`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AND`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` EventDate `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`\u003c=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '2013-07-31'`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AND`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` MobilePhone `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`!=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 0`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AND`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` MobilePhoneModel `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`NOT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` IN`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`''`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'iPad'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`)`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GROUP BY`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` MobilePhoneModel`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ORDER BY`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` c `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`DESC`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`LIMIT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 8`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.a,{href:`https://sql.clickhouse.com?query=U0VMRUNUIE1vYmlsZVBob25lTW9kZWwsIENPVU5UKCkgQVMgYyAKRlJPTSBtZXRyaWNhLmhpdHMgCldIRVJFIAogICAgICBSZWdpb25JRCA9IDIyOSAKICBBTkQgRXZlbnREYXRlID49ICcyMDEzLTA3LTAxJyAKICBBTkQgRXZlbnREYXRlIDw9ICcyMDEzLTA3LTMxJyAKICBBTkQgTW9iaWxlUGhvbmUgIT0gMCAKICBBTkQgTW9iaWxlUGhvbmVNb2RlbCBub3QgaW4gWycnLCAnaVBhZCddIApHUk9VUCBCWSBNb2JpbGVQaG9uZU1vZGVsCk9SREVSIEJZIGMgREVTQyAKTElNSVQgODs\u0026chart=eyJ0eXBlIjoicGllIiwiY29uZmlnIjp7InhheGlzIjoiTW9iaWxlUGhvbmVNb2RlbCIsInlheGlzIjoiYyJ9fQ\u0026run_query=true`,children:`ClickHouse SQL Playground에서 이 쿼리를 실행`}),`하여 기존 `,_jsx(_components.a,{href:`https://sql.clickhouse.com/?query=U0VMRUNUIG5hbWUKRlJPTSBzeXN0ZW0uY29sdW1ucwpXSEVSRSBkYXRhYmFzZSA9ICdtZXRyaWNhJyBBTkQgdGFibGUgPSAnaGl0cyc7\u0026tab=results\u0026run_query=true`,children:`100개가 넘는 컬럼 중 일부만`}),` 선택하고 필터링한 다음, 결과를 밀리초 단위로 받아볼 수 있습니다:`]}),`\n`,_jsx(`div`,{className:`ch-image-lg`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented-example-query.webp?fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=5af13cd07e9318a1a4736d1c011c4576`,alt:`컬럼 지향 데이터베이스의 예시 쿼리`,\"data-og-width\":`2496`,width:`2496`,\"data-og-height\":`1080`,height:`1080`,\"data-path\":`images/column-oriented-example-query.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented-example-query.webp?w=280\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=30f999d366d1a6f6e015eca1b6029be1 280w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented-example-query.webp?w=560\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=62f3dc7849184fb4efcaf31cf8e4a830 560w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented-example-query.webp?w=840\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=072506b16648fcf7f95ae300098c9c71 840w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented-example-query.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=97fcb98a54c2b9414f0660109c797d8d 1100w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented-example-query.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=3821d4e3b591aae76d2fd6c9b6b38686 1650w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented-example-query.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=c9a81805d19216efe747dec44ca5ca7b 2500w`})})}),`\n`,_jsx(_components.p,{children:`위 그림의 통계 섹션에서 볼 수 있듯이, 이 쿼리는 1억 행을 92밀리초 만에 처리했으며, 처리량은 초당 약 10억 행 이상, 또는 초당 7 GB에 약간 못 미치는 데이터 전송량에 해당합니다.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`행 지향 DBMS`})}),`\n`,_jsxs(_components.p,{children:[`행 지향 데이터베이스에서는 위 쿼리가 기존 컬럼 중 일부만 처리하더라도, 시스템은 여전히 다른 컬럼의 데이터도 디스크에서 메모리로 로드해야 합니다. 이는 데이터가 디스크에 `,_jsx(_components.a,{href:`https://en.wikipedia.org/wiki/Block_(data_storage)`,children:`블록`}),`이라고 하는 청크 단위로 저장되기 때문입니다(보통 4 KB 또는 8 KB 같은 고정 크기). 블록은 디스크에서 메모리로 읽어 오는 데이터의 가장 작은 단위입니다. 애플리케이션이나 데이터베이스가 데이터를 요청하면 운영 체제의 디스크 I/O 하위 시스템이 디스크에서 필요한 블록을 읽습니다. 블록의 일부만 필요하더라도 전체 블록이 메모리로 읽혀집니다(이는 디스크 및 파일 시스템 설계에 따른 것입니다):`]}),`\n`,_jsx(`div`,{className:`ch-image-lg`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/private-7c7dfe99/XMwBPdXQ4eun4JUL/images/row-oriented.webp?fit=max\u0026auto=format\u0026n=XMwBPdXQ4eun4JUL\u0026q=85\u0026s=3b04b3f29b15196078a0f5ff1781ff3e`,alt:`행 지향 데이터베이스 구조`,\"data-og-width\":`630`,width:`630`,\"data-og-height\":`258`,height:`258`,\"data-path\":`images/row-oriented.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/private-7c7dfe99/XMwBPdXQ4eun4JUL/images/row-oriented.webp?w=280\u0026fit=max\u0026auto=format\u0026n=XMwBPdXQ4eun4JUL\u0026q=85\u0026s=4ae99d499bc36784ba3275ae57118b6f 280w, https://mintcdn.com/private-7c7dfe99/XMwBPdXQ4eun4JUL/images/row-oriented.webp?w=560\u0026fit=max\u0026auto=format\u0026n=XMwBPdXQ4eun4JUL\u0026q=85\u0026s=bdc5364f1278b712a7040019fbf94759 560w, https://mintcdn.com/private-7c7dfe99/XMwBPdXQ4eun4JUL/images/row-oriented.webp?w=840\u0026fit=max\u0026auto=format\u0026n=XMwBPdXQ4eun4JUL\u0026q=85\u0026s=d8fe4b56445d55cbae1b67d6b1cdcad1 840w, https://mintcdn.com/private-7c7dfe99/XMwBPdXQ4eun4JUL/images/row-oriented.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=XMwBPdXQ4eun4JUL\u0026q=85\u0026s=333537d5d3be30b1997f2882d4d4869e 1100w, https://mintcdn.com/private-7c7dfe99/XMwBPdXQ4eun4JUL/images/row-oriented.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=XMwBPdXQ4eun4JUL\u0026q=85\u0026s=4db19a86ad862653360a256f294c2a44 1650w, https://mintcdn.com/private-7c7dfe99/XMwBPdXQ4eun4JUL/images/row-oriented.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=XMwBPdXQ4eun4JUL\u0026q=85\u0026s=71b6e29dc3e4c4926b9d4e1ba4e570b3 2500w`})})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`컬럼 지향 DBMS`})}),`\n`,_jsxs(_components.p,{children:[`각 컬럼의 값이 디스크에 순차적으로 저장되므로, 위 쿼리를 실행할 때 불필요한 데이터는 로드되지 않습니다.\n디스크에서 메모리로의 block 단위 저장 및 전송이 분석 쿼리의 데이터 접근 패턴과 일치하므로, 쿼리에 필요한 컬럼만 디스크에서 읽어 사용되지 않는 데이터에 대한 불필요한 I/O를 피할 수 있습니다. 이는 전체 행(관련 없는 컬럼 포함)을 읽는 행 기반 저장 방식과 비교하면 `,_jsx(_components.a,{href:`https://benchmark.clickhouse.com/`,children:`훨씬 더 빠릅니다`}),`:`]}),`\n`,_jsx(`div`,{className:`ch-image-lg`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented.webp?fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=6797576187aa979db549823f0db74f1e`,alt:`컬럼 지향 데이터베이스 구조`,\"data-og-width\":`630`,width:`630`,\"data-og-height\":`258`,height:`258`,\"data-path\":`images/column-oriented.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented.webp?w=280\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=522b8ae7d41d056bea0ffb08d29d60f8 280w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented.webp?w=560\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=78ee735f86b82f2cf9b072aa1f09b8a5 560w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented.webp?w=840\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=13de8ef4119933ae29cee4436475296f 840w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=4de5ae05ff878a4984209a4108e982c2 1100w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=962eda8cb1f54e30e38fcc9885db9956 1650w, https://mintcdn.com/private-7c7dfe99/zhhfCE__w-UVvpQP/images/column-oriented.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=zhhfCE__w-UVvpQP\u0026q=85\u0026s=cc73cada62649dab9e9839f0a6a3854a 2500w`})})}),`\n`,_jsx(`div`,{id:`data-replication-and-integrity`,children:_jsx(Heading,{level:`2`,id:`데이터-복제-및-무결성`,children:`데이터 복제 및 무결성`})}),`\n`,_jsx(_components.p,{children:`ClickHouse는 여러 노드에 데이터를 중복 저장할 수 있도록 비동기 멀티 마스터 복제 방식을 사용합니다. 사용 가능한 아무 레플리카에 데이터를 쓰면, 나머지 모든 레플리카는 백그라운드에서 해당 데이터의 사본을 가져옵니다. 시스템은 서로 다른 레플리카에 동일한 데이터가 유지되도록 합니다. 대부분의 장애는 자동으로 복구되며, 복잡한 경우에는 반자동으로 복구됩니다.`}),`\n`,_jsx(`div`,{id:`role-based-access-control`,children:_jsx(Heading,{level:`2`,id:`역할-기반-접근-제어`,children:`역할 기반 접근 제어`})}),`\n`,_jsx(_components.p,{children:`ClickHouse는 SQL 쿼리를 사용해 사용자 계정을 관리하며, ANSI SQL 표준과 널리 사용되는 관계형 데이터베이스 관리 시스템과 유사한 역할 기반 접근 제어 구성을 지원합니다.`}),`\n`,_jsx(`div`,{id:`sql-support`,children:_jsx(Heading,{level:`2`,id:`sql-지원`,children:`SQL 지원`})}),`\n`,_jsxs(_components.p,{children:[`ClickHouse는 많은 경우 ANSI SQL 표준과 동일한 `,_jsx(_components.a,{href:`/ko/reference/home`,children:`SQL 기반의 선언형 쿼리 언어`}),`를 지원합니다. 지원되는 쿼리 절에는 `,_jsx(_components.a,{href:`/ko/reference/statements/select/group-by`,children:`GROUP BY`}),`, `,_jsx(_components.a,{href:`/ko/reference/statements/select/order-by`,children:`ORDER BY`}),`, `,_jsx(_components.a,{href:`/ko/reference/statements/select/from`,children:`FROM`}),`의 서브쿼리, `,_jsx(_components.a,{href:`/ko/reference/statements/select/join`,children:`JOIN`}),` 절, `,_jsx(_components.a,{href:`/ko/reference/statements/in`,children:`IN`}),` 연산자, `,_jsx(_components.a,{href:`/ko/reference/functions/window-functions/index`,children:`윈도우 함수`}),`, 그리고 스칼라 서브쿼리가 포함됩니다.`]}),`\n`,_jsx(`div`,{id:`approximate-calculation`,children:_jsx(Heading,{level:`2`,id:`근사-계산`,children:`근사 계산`})}),`\n`,_jsx(_components.p,{children:`ClickHouse는 정확도와 성능을 절충할 수 있는 방법을 제공합니다. 예를 들어 일부 집계 함수는 고유값 개수, 중앙값, 분위수를 근사적으로 계산합니다. 또한 데이터의 일부 샘플에 대해 쿼리를 실행해 근사 결과를 빠르게 계산할 수 있습니다. 마지막으로 모든 키에 대해 집계를 수행하는 대신, 제한된 수의 키에 대해서만 집계를 수행할 수 있습니다. 키 분포가 얼마나 치우쳐 있는지에 따라, 이 방식은 정확 계산보다 훨씬 적은 리소스를 사용하면서도 상당히 정확한 결과를 제공할 수 있습니다.`}),`\n`,_jsx(`div`,{id:`adaptive-join-algorithms`,children:_jsx(Heading,{level:`2`,id:`적응형-조인-알고리즘`,children:`적응형 조인 알고리즘`})}),`\n`,_jsx(_components.p,{children:`ClickHouse는 조인 알고리즘을 상황에 맞게 선택합니다. 먼저 빠른 해시 조인을 사용하고, 큰 테이블이 2개 이상이면 머지 조인으로 전환합니다.`}),`\n`,_jsx(`div`,{id:`superior-query-performance`,children:_jsx(Heading,{level:`2`,id:`뛰어난-쿼리-성능`,children:`뛰어난 쿼리 성능`})}),`\n`,_jsxs(_components.p,{children:[`ClickHouse는 매우 빠른 쿼리 성능을 제공하는 것으로 잘 알려져 있습니다.\nClickHouse가 왜 이렇게 빠른지 알아보려면 `,_jsx(_components.a,{href:`/ko/get-started/about/why-clickhouse-is-so-fast`,children:`Why is ClickHouse fast?`}),` 가이드를 참조하십시오.`]})]})}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":"/intro","sidebarTitle":"ClickHouse란 무엇입니까?","description":"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.","title":"ClickHouse란 무엇입니까?","keywords":["ClickHouse","컬럼형 데이터베이스","OLAP 데이터베이스","분석용 데이터베이스","고성능 데이터베이스"],"doc_type":"guide","href":"/ko/get-started/about/intro"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"분석이란 무엇입니까?","slug":"분석이란-무엇입니까","depth":2,"children":[]},{"title":"행 지향 저장과 컬럼 지향 저장 비교","slug":"행-지향-저장과-컬럼-지향-저장-비교","depth":2,"children":[]},{"title":"데이터 복제 및 무결성","slug":"데이터-복제-및-무결성","depth":2,"children":[]},{"title":"역할 기반 접근 제어","slug":"역할-기반-접근-제어","depth":2,"children":[]},{"title":"SQL 지원","slug":"sql-지원","depth":2,"children":[]},{"title":"근사 계산","slug":"근사-계산","depth":2,"children":[]},{"title":"적응형 조인 알고리즘","slug":"적응형-조인-알고리즘","depth":2,"children":[]},{"title":"뛰어난 쿼리 성능","slug":"뛰어난-쿼리-성능","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/private-7c7dfe99/f11c6dde2c89bd05/_site/customizations/ask-ai-button.js","/docs/_mintlify/custom/private-7c7dfe99/39eb0ad87fa3adc8/_site/customizations/clickhouse-sql-highlight.js","/docs/_mintlify/custom/private-7c7dfe99/f2f887f569696d41/_site/customizations/clickhouse-sql-lexer-wasm.js","/docs/_mintlify/custom/private-7c7dfe99/dce387fc81a6edfe/_site/customizations/custom-footer.js","/docs/_mintlify/custom/private-7c7dfe99/240e3ba1823c3bae/_site/customizations/galaxy.js","/docs/_mintlify/custom/private-7c7dfe99/c00e6cbded147615/_site/customizations/inkeep-init.js","/docs/_mintlify/custom/private-7c7dfe99/ad7415752a665282/_site/customizations/kapa-init.js","/docs/_mintlify/custom/private-7c7dfe99/4b6201cbf0ed537b/_site/customizations/nav-icon-preload.js","/docs/_mintlify/custom/private-7c7dfe99/10c01e58e00a0bb5/_site/customizations/navbar-cta.js","/docs/_mintlify/custom/private-7c7dfe99/f75dab9369f45602/_site/customizations/raise-issue-link.js","/docs/_mintlify/custom/private-7c7dfe99/a97e716bfafb62fd/_site/customizations/scroll-reset.js","/docs/_mintlify/custom/private-7c7dfe99/bb66ab6ab59dfc53/_site/customizations/settings-legacy-redirect.js","/docs/_mintlify/custom/private-7c7dfe99/bd3cb49fae80807e/_site/customizations/settings-legacy-routes/format-settings.js","/docs/_mintlify/custom/private-7c7dfe99/715db8995ae06543/_site/customizations/settings-legacy-routes/mergetree-settings.js","/docs/_mintlify/custom/private-7c7dfe99/768b733920354bca/_site/customizations/settings-legacy-routes/server-settings.js","/docs/_mintlify/custom/private-7c7dfe99/5fd0936388a00cd0/_site/customizations/settings-legacy-routes/session-settings.js","/docs/_mintlify/custom/private-7c7dfe99/23432dedeeb54e07/_site/customizations/tab-nav.js","/docs/_mintlify/custom/private-7c7dfe99/5c7ce50607c95a70/_site/customizations/webterminal.js","/docs/_mintlify/custom/private-7c7dfe99/5e0b81ad15d8ede0/_site/customizations/cloud-sidebar-ad.js","/docs/_mintlify/custom/private-7c7dfe99/f017ff835af2f729/_site/customizations/section-ticker.js","/docs/_mintlify/custom/private-7c7dfe99/53fc41cb46bfef11/_site/customizations/clickstack-availability.js"],"subdomain":"private-7c7dfe99","siteName":"ClickHouse Documentation","title":"ClickHouse란 무엇입니까? - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/get-started/about/intro","matchLevel":1},"ar":{"href":"/ar/get-started/about/intro","matchLevel":1},"es":{"href":"/es/get-started/about/intro","matchLevel":1},"fr":{"href":"/fr/get-started/about/intro","matchLevel":1},"ja":{"href":"/ja/get-started/about/intro","matchLevel":1},"ko":{"href":"/ko/get-started/about/intro","matchLevel":0},"pt-BR":{"href":"/pt-BR/get-started/about/intro","matchLevel":1},"ru":{"href":"/ru/get-started/about/intro","matchLevel":1},"zh":{"href":"/zh/get-started/about/intro","matchLevel":1}}},"originalFileLocation":"ko/get-started/about/intro.mdx","locale":"ko"},"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=\"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.\">\u003cmeta data-mint-head name=\"application-name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"ClickHouse란 무엇입니까? - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://clickhouse.com/docs/ko/get-started/about/intro\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=Introduction\u0026amp;title=ClickHouse%EB%9E%80+%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F\u0026amp;description=ClickHouse%C2%AE%EB%8A%94+%EC%98%A8%EB%9D%BC%EC%9D%B8+%EB%B6%84%EC%84%9D+%EC%B2%98%EB%A6%AC%28OLAP%29%EB%A5%BC+%EC%9C%84%ED%95%9C+%EC%BB%AC%EB%9F%BC+%EC%A7%80%ED%96%A5+SQL+%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4+%EA%B4%80%EB%A6%AC+%EC%8B%9C%EC%8A%A4%ED%85%9C%28DBMS%29%EC%9E%85%EB%8B%88%EB%8B%A4.+%EC%98%A4%ED%94%88%EC%86%8C%EC%8A%A4+%EC%86%8C%ED%94%84%ED%8A%B8%EC%9B%A8%EC%96%B4%EC%99%80+%ED%81%B4%EB%9D%BC%EC%9A%B0%EB%93%9C+%ED%98%95%ED%83%9C%EB%A1%9C+%EB%AA%A8%EB%91%90+%EC%A0%9C%EA%B3%B5%EB%90%A9%EB%8B%88%EB%8B%A4.\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=2739ad4a342abea779e7774d942fa3c206bc9ccd4b126d50dd714f7255c81cb8\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"ClickHouse란 무엇입니까? - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=Introduction\u0026amp;title=ClickHouse%EB%9E%80+%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F\u0026amp;description=ClickHouse%C2%AE%EB%8A%94+%EC%98%A8%EB%9D%BC%EC%9D%B8+%EB%B6%84%EC%84%9D+%EC%B2%98%EB%A6%AC%28OLAP%29%EB%A5%BC+%EC%9C%84%ED%95%9C+%EC%BB%AC%EB%9F%BC+%EC%A7%80%ED%96%A5+SQL+%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4+%EA%B4%80%EB%A6%AC+%EC%8B%9C%EC%8A%A4%ED%85%9C%28DBMS%29%EC%9E%85%EB%8B%88%EB%8B%A4.+%EC%98%A4%ED%94%88%EC%86%8C%EC%8A%A4+%EC%86%8C%ED%94%84%ED%8A%B8%EC%9B%A8%EC%96%B4%EC%99%80+%ED%81%B4%EB%9D%BC%EC%9A%B0%EB%93%9C+%ED%98%95%ED%83%9C%EB%A1%9C+%EB%AA%A8%EB%91%90+%EC%A0%9C%EA%B3%B5%EB%90%A9%EB%8B%88%EB%8B%A4.\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=2739ad4a342abea779e7774d942fa3c206bc9ccd4b126d50dd714f7255c81cb8\">\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/ko/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/ko/get-started/about/intro.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/get-started/about/intro\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/get-started/about/intro\">\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/ko/get-started/about/intro#webpage\",\"url\":\"https://clickhouse.com/docs/ko/get-started/about/intro\",\"name\":\"ClickHouse란 무엇입니까?\",\"description\":\"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/ko/get-started/about/intro#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/ko/get-started/about/intro#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Get started\",\"item\":\"https://clickhouse.com/docs/ko/get-started\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ClickHouse란 무엇입니까?\",\"item\":\"https://clickhouse.com/docs/ko/get-started/about/intro\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/ko/get-started/about/intro#article\",\"headline\":\"ClickHouse란 무엇입니까?\",\"name\":\"ClickHouse란 무엇입니까?\",\"description\":\"ClickHouse®는 온라인 분석 처리(OLAP)를 위한 컬럼 지향 SQL 데이터베이스 관리 시스템(DBMS)입니다. 오픈소스 소프트웨어와 클라우드 형태로 모두 제공됩니다.\",\"url\":\"https://clickhouse.com/docs/ko/get-started/about/intro\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/ko/get-started/about/intro#webpage\"},\"keywords\":\"ClickHouse, 컬럼형 데이터베이스, OLAP 데이터베이스, 분석용 데이터베이스, 고성능 데이터베이스\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"},\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"}}]}\u003c/script>","agentPointerHref":"/docs/ko/get-started/about/intro.md","siteName":"ClickHouse Documentation","nav":{"global":null,"languages":[{"language":"en","pages":[{"title":"en","href":"/get-started/about/intro"}]},{"language":"ar","pages":[{"title":"ar","href":"/ar/get-started/about/intro"}]},{"language":"es","pages":[{"title":"es","href":"/es/get-started/about/intro"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/get-started/about/intro"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/get-started/about/intro"}]},{"language":"ko","tabs":[{"tab":"홈","pages":[{"title":"홈","href":"/ko"}]},{"tab":"데이터베이스","menu":[{"item":"ClickHouse","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse.svg","href":"#"},{"item":"Get started","pages":[{"group":"Get started","icon":"/images/menu-icon-lightning.svg","pages":[{"title":"ClickHouse 시작하기","sidebarTitle":"개요","href":"/ko/get-started"},{"group":"빠른 시작","expanded":false,"pages":[{"sidebarTitle":"빠른 시작 둘러보기","title":"빠른 시작 둘러보기","mode":"custom","href":"/ko/get-started/quickstarts/home"},{"group":"모든 사용 사례","expanded":false,"pages":[{"sidebarTitle":"Cloud 빠른 시작","title":"ClickHouse Cloud 빠른 시작","href":"/ko/get-started/setup/cloud"},{"sidebarTitle":"Cloud 연결 정보 확인","title":"Cloud 연결 정보 확인","href":"/ko/get-started/quickstarts/obtain-your-cloud-connection-details"},{"sidebarTitle":"clickhouse-client로 ClickHouse Cloud에 데이터 삽입","title":"clickhouse-client로 ClickHouse Cloud에 데이터 삽입","href":"/ko/get-started/quickstarts/insert-data-using-clickhouse-client"},{"sidebarTitle":"ClickHouse에서 테이블 생성","title":"ClickHouse에서 테이블 생성","href":"/ko/get-started/quickstarts/creating-tables"},{"sidebarTitle":"ClickHouse 데이터 선택","title":"ClickHouse 데이터 선택","href":"/ko/get-started/quickstarts/writing-queries"},{"sidebarTitle":"첫 번째 MergeTree 테이블 만들기","title":"첫 번째 MergeTree 테이블 만들기","href":"/ko/get-started/quickstarts/create-your-first-mergetree-table"}]},{"group":"실시간 분석","expanded":false,"pages":[{"sidebarTitle":"첫 materialized view 만들기","title":"첫 materialized view 만들기","href":"/ko/get-started/quickstarts/create-your-first-materialized-view"},{"sidebarTitle":"첫 번째 프로젝션 만들기","title":"첫 번째 프로젝션 만들기","href":"/ko/get-started/quickstarts/create-your-first-projection"}]},{"group":"데이터 웨어하우징","expanded":false,"pages":[{"sidebarTitle":"ClickHouse Cloud에서 Iceberg 카탈로그를 연결하는 방법","title":"ClickHouse Cloud에서 Iceberg 카탈로그를 연결하는 방법","href":"/ko/get-started/quickstarts/connect-your-iceberg-catalog"},{"sidebarTitle":"ClickHouse 데이터 업데이트 및 삭제","title":"ClickHouse 데이터 업데이트 및 삭제","href":"/ko/get-started/quickstarts/mutations"}]},{"group":"관측성","expanded":false,"pages":[{"sidebarTitle":"ClickHouse에서 맵 타입 사용하기","title":"ClickHouse에서 맵 타입 사용하기","description":"OTel 리소스 속성을 예시로, ClickHouse에서 동적 키-값 데이터를 저장, 쿼리, 집계하는 데 맵 타입을 사용하는 방법을 알아봅니다.","href":"/ko/get-started/quickstarts/working-with-the-map-type"}]}]},{"group":"Introduction","expanded":true,"pages":[{"sidebarTitle":"ClickHouse란 무엇입니까?","title":"ClickHouse란 무엇입니까?","href":"/ko/get-started/about/intro"},{"sidebarTitle":"ClickHouse는 왜 이렇게 빠를까요?","description":"빠르도록 설계되었기 때문입니다. 쿼리 실행 성능은 개발 과정 전반에서 항상 최우선 순위였지만, ClickHouse가 실제 프로덕션 시스템으로 자리 잡을 수 있도록 사용 편의성, 확장성, 보안과 같은 다른 중요한 특성도 함께 고려되었습니다.","title":"ClickHouse는 왜 이렇게 빠를까요?","href":"/ko/get-started/about/why-clickhouse-is-so-fast"},{"sidebarTitle":"ClickHouse가 특별한 이유","title":"ClickHouse의 고유한 특징","href":"/ko/get-started/about/distinctive-features"}]},{"group":"Use cases","expanded":true,"pages":[{"title":"사용 사례","sidebarTitle":"개요","href":"/ko/get-started/use-cases/overview"},{"title":"실시간 분석","sidebarTitle":"실시간 분석","href":"/ko/get-started/use-cases/real-time-analytics"},{"title":"관측성","sidebarTitle":"관측성","href":"/ko/get-started/use-cases/observability"},{"title":"데이터 웨어하우징","sidebarTitle":"데이터 웨어하우징","href":"/ko/get-started/use-cases/data-warehousing"},{"title":"에이전트형 분석","sidebarTitle":"에이전트형 분석","href":"/ko/get-started/use-cases/agentic-analytics"}]},{"sidebarTitle":"배포 모드","title":"배포 모드","href":"/ko/get-started/about/deployment-modes"}]},{"group":"Setup","icon":"/images/menu-icon-gear.svg","expanded":true,"pages":[{"sidebarTitle":"설치","title":"설치 안내","href":"/ko/get-started/setup/install"},{"sidebarTitle":"Cloud 빠른 시작","title":"ClickHouse Cloud 빠른 시작","href":"/ko/get-started/setup/cloud"},{"group":"Self-managed","expanded":true,"pages":[{"title":"자가 관리형 설치","sidebarTitle":"개요","href":"/ko/get-started/setup/self-managed/overview"},{"group":"Local development","pages":[{"sidebarTitle":"빠른 설치","title":"빠른 설치","href":"/ko/get-started/setup/self-managed/quick-install"},{"sidebarTitle":"clickhousectl (CLI)","title":"ClickHouse CLI로 설치","href":"/ko/get-started/setup/self-managed/clickhousectl"},{"sidebarTitle":"Docker","title":"Docker를 사용해 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/docker"},{"sidebarTitle":"소스 및 CI 빌드","title":"소스 및 CI 빌드","href":"/ko/get-started/setup/self-managed/advanced"}]},{"group":"Production server","pages":[{"sidebarTitle":"Debian/Ubuntu","title":"Debian/Ubuntu에 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/debian-ubuntu"},{"sidebarTitle":"Redhat/CentOS","title":"rpm 기반 Linux 배포판에 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/redhat"},{"sidebarTitle":"NixOS","title":"NixOS에서 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/nixos"},{"sidebarTitle":"기타 Linux","title":"tgz 아카이브를 사용해 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/other-linux"}]}]}]},{"group":"Sample datasets","icon":"/images/menu-icon-database.svg","expanded":true,"pages":[{"sidebarTitle":"개요","title":"튜토리얼 및 예제 데이터셋","href":"/ko/get-started/sample-datasets/index"},{"sidebarTitle":"ClickHouse Playground","title":"ClickHouse Playground","href":"/ko/get-started/sample-datasets/playground"},{"group":"Benchmarks","pages":[{"sidebarTitle":"AMPLab 빅 데이터 벤치마크","title":"AMPLab Big Data Benchmark","href":"/ko/get-started/sample-datasets/amplab-benchmark"},{"sidebarTitle":"Brown University 벤치마크","title":"Brown University 벤치마크","href":"/ko/get-started/sample-datasets/brown-benchmark"},{"sidebarTitle":"Criteo 1TB 클릭 로그","title":"Criteo의 1TB 클릭 로그","href":"/ko/get-started/sample-datasets/criteo"},{"title":"Join Order Benchmark (JOB)","sidebarTitle":"JOB","href":"/ko/get-started/sample-datasets/job"},{"sidebarTitle":"Star Schema Benchmark","title":"Star Schema Benchmark (SSB, 2009)","href":"/ko/get-started/sample-datasets/star-schema"},{"title":"TPC-DS (2012)","sidebarTitle":"TPC-DS","href":"/ko/get-started/sample-datasets/tpcds"},{"title":"TPC-H (1999)","sidebarTitle":"TPC-H","href":"/ko/get-started/sample-datasets/tpch"}]},{"group":"Vector search \u0026 embeddings","pages":[{"sidebarTitle":"dbpedia 데이터셋","title":"dbpedia 데이터셋","href":"/ko/get-started/sample-datasets/dbpedia"},{"sidebarTitle":"Hacker News 벡터 검색 데이터셋","title":"Hacker News 벡터 검색 데이터셋","href":"/ko/get-started/sample-datasets/hacker-news-vector-search"},{"sidebarTitle":"Laion-400M 데이터셋","title":"Laion-400M 데이터셋","href":"/ko/get-started/sample-datasets/laion"},{"sidebarTitle":"LAION 5B 데이터셋","title":"LAION 5B 데이터셋","href":"/ko/get-started/sample-datasets/laion5b"}]},{"group":"Web \u0026 social analytics","pages":[{"sidebarTitle":"Amazon 고객 리뷰","title":"Amazon 고객 리뷰","href":"/ko/get-started/sample-datasets/amazon-reviews"},{"sidebarTitle":"익명화된 웹 분석","title":"익명화된 웹 분석","href":"/ko/get-started/sample-datasets/anon-web-analytics-metrica"},{"sidebarTitle":"GitHub 리포지토리","title":"GitHub 데이터로 ClickHouse에서 쿼리 작성하기","href":"/ko/get-started/sample-datasets/github"},{"sidebarTitle":"GitHub 이벤트","title":"GitHub 이벤트 데이터셋","href":"/ko/get-started/sample-datasets/github-events"},{"sidebarTitle":"Hacker News","title":"Hacker News 데이터셋","href":"/ko/get-started/sample-datasets/hacker-news"},{"sidebarTitle":"Stack Overflow","title":"ClickHouse로 Stack Overflow 데이터 분석","href":"/ko/get-started/sample-datasets/stackoverflow"},{"sidebarTitle":"YouTube 싫어요","title":"YouTube 싫어요 데이터셋","href":"/ko/get-started/sample-datasets/youtube-dislikes"}]},{"group":"Geo \u0026 location","pages":[{"sidebarTitle":"기지국","title":"기지국 데이터셋을 활용한 지리 공간 분석","href":"/ko/get-started/sample-datasets/cell-towers"},{"sidebarTitle":"Foursquare OS Places","title":"Foursquare OS Places 데이터셋","href":"/ko/get-started/sample-datasets/foursquare-os-places"},{"sidebarTitle":"뉴욕 택시 데이터","title":"뉴욕 택시 데이터셋을 활용한 지리공간 분석","href":"/ko/get-started/sample-datasets/nyc-taxi"}]},{"group":"Time series \u0026 sensors","pages":[{"sidebarTitle":"환경 센서 데이터","title":"환경 센서 데이터","href":"/ko/get-started/sample-datasets/environmental-sensors"},{"sidebarTitle":"NOAA Global Historical Climatology Network ","title":"NOAA Global Historical Climatology Network","href":"/ko/get-started/sample-datasets/noaa"},{"sidebarTitle":"대만 과거 기상 데이터셋","title":"대만 과거 기상 데이터셋","href":"/ko/get-started/sample-datasets/tw-weather"},{"sidebarTitle":"WikiStat","title":"WikiStat","href":"/ko/get-started/sample-datasets/wikistat"}]},{"group":"Public records \u0026 open data","pages":[{"sidebarTitle":"COVID-19 오픈 데이터","title":"COVID-19 오픈 데이터","href":"/ko/get-started/sample-datasets/covid19"},{"sidebarTitle":"New York Public Library \"What's on the Menu?\" 데이터셋","title":"New York Public Library \"What's on the Menu?\" 데이터셋","href":"/ko/get-started/sample-datasets/menus"},{"sidebarTitle":"NYPD 신고 데이터","title":"NYPD 신고 데이터","href":"/ko/get-started/sample-datasets/nypd-complaint-data"},{"sidebarTitle":"OnTime 항공편 데이터","title":"OnTime","href":"/ko/get-started/sample-datasets/ontime"},{"sidebarTitle":"영국 부동산 가격","title":"영국 부동산 가격 데이터 분석 쿼리","href":"/ko/get-started/sample-datasets/uk-price-paid"}]}]},{"group":"Migrate","icon":"/images/caret-double-right.svg","expanded":true,"pages":[{"sidebarTitle":"개요","title":"ClickHouse로 데이터 마이그레이션","href":"/ko/get-started/migrate/overview"},{"group":"PostgreSQL","pages":[{"title":"PostgreSQL과 ClickHouse 비교","sidebarTitle":"개요","href":"/ko/get-started/migrate/postgres/overview"},{"group":"Migration guide","pages":[{"title":"데이터 마이그레이션","sidebarTitle":"1부","href":"/ko/get-started/migrate/postgres/migration-guide/migration-guide-part1"},{"title":"PostgreSQL 쿼리 재작성하기","sidebarTitle":"2부","href":"/ko/get-started/migrate/postgres/migration-guide/migration-guide-part2"},{"title":"데이터 모델링 기법","sidebarTitle":"제3부","href":"/ko/get-started/migrate/postgres/migration-guide/migration-guide-part3"}]},{"title":"부록","href":"/ko/get-started/migrate/postgres/appendix"}]},{"group":"BigQuery","pages":[{"title":"ClickHouse Cloud와 BigQuery 비교","sidebarTitle":"개요","href":"/ko/get-started/migrate/bigquery/overview"},{"title":"BigQuery에서 ClickHouse Cloud로 마이그레이션","sidebarTitle":"마이그레이션 가이드","href":"/ko/get-started/migrate/bigquery/migrating-to-clickhouse-cloud"},{"sidebarTitle":"데이터 로드","title":"BigQuery에서 ClickHouse로 데이터 로드","href":"/ko/get-started/migrate/bigquery/loading-data"}]},{"group":"Snowflake","pages":[{"sidebarTitle":"개요","title":"Snowflake에서 ClickHouse로의 마이그레이션","href":"/ko/get-started/migrate/snowflake/overview"},{"sidebarTitle":"마이그레이션 가이드","title":"Snowflake에서 ClickHouse로 마이그레이션","href":"/ko/get-started/migrate/snowflake/migration-guide"},{"sidebarTitle":"SQL 번역 참고","title":"Snowflake에서 ClickHouse로 마이그레이션","href":"/ko/get-started/migrate/snowflake/sql-translation-reference"}]},{"group":"Elasticsearch","pages":[{"sidebarTitle":"개요","title":"Elasticsearch에서 ClickHouse로 마이그레이션","href":"/ko/get-started/migrate/elastic/overview"}]},{"group":"Redshift","pages":[{"sidebarTitle":"개요","title":"ClickHouse Cloud와 Amazon Redshift 비교","href":"/ko/get-started/migrate/redshift/overview"},{"sidebarTitle":"마이그레이션 가이드","title":"Amazon Redshift에서 ClickHouse로 이전하기 가이드","href":"/ko/get-started/migrate/redshift/migration-guide"},{"sidebarTitle":"SQL 변환 참고","title":"Amazon Redshift SQL 변환 가이드","href":"/ko/get-started/migrate/redshift/sql-translation-reference"}]},{"group":"OSS to Cloud","pages":[{"sidebarTitle":"remoteSecure 사용하기","title":"remoteSecure를 사용하여 자가 관리형 ClickHouse와 ClickHouse Cloud 간에 마이그레이션하기","href":"/ko/get-started/migrate/oss-to-cloud/clickhouse-to-cloud"},{"sidebarTitle":"BACKUP 및 RESTORE 사용","title":"Backup 명령을 사용한 자가 관리형 ClickHouse에서 ClickHouse Cloud로의 마이그레이션","href":"/ko/get-started/migrate/oss-to-cloud/oss-to-cloud-backup-restore"}]},{"group":"Other methods","pages":[{"sidebarTitle":"clickhouse-local 사용","title":"clickhouse-local을 사용해 ClickHouse로 마이그레이션하기","href":"/ko/get-started/migrate/other-methods/clickhouse-local-etl"},{"sidebarTitle":"타사 ETL 도구 사용","title":"타사 ETL 도구 사용","href":"/ko/get-started/migrate/other-methods/etl-tool-to-clickhouse"},{"title":"클라우드 객체 스토리지에서 ClickHouse Cloud로 데이터 이동","href":"/ko/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]}]},{"item":"가이드","pages":[{"title":"가이드","href":"/ko/guides/clickhouse"}]},{"item":"개념","pages":[{"title":"개념","href":"/ko/concepts"}]},{"item":"참고","pages":[{"title":"참고","href":"/ko/reference/home"}]},{"item":"ClickHouse Managed Postgres","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-postgres.svg","pages":[{"title":"ClickHouse Managed Postgres","href":"/ko/products/managed-postgres/overview"}]}]},{"tab":"제품","menu":[{"item":"배포","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickHouse Cloud","pages":[{"title":"ClickHouse Cloud","href":"/ko/products/cloud/getting-started/cloud-get-started"}]},{"item":"BYOC","pages":[{"title":"BYOC","href":"/ko/products/cloud/guides/infrastructure/deployment-options/byoc/overview"}]},{"item":"애플리케이션","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","pages":[{"title":"ClickStack","href":"/ko/clickstack"}]},{"item":"Agents","pages":[{"title":"Agents","href":"/ko/agents"}]},{"item":"AI 엔지니어링","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/logo-langfuse.svg","href":"https://langfuse.com/docs"},{"item":"보안","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/integrations/logos/runreveal.webp","href":"https://docs.runreveal.com/"},{"item":"오픈 소스","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","pages":[{"title":"ClickStack","href":"/ko/clickstack"}]},{"item":"chDB","pages":[{"title":"chDB","href":"/ko/chdb"}]},{"item":"Kubernetes Operator","pages":[{"title":"Kubernetes Operator","href":"/ko/products/kubernetes-operator/overview"}]},{"item":"LibreChat","href":"https://www.librechat.ai/docs"}],"pages":[{"title":"제품","href":"/ko/products/cloud/getting-started/cloud-get-started"}]},{"tab":"통합","menu":[{"item":"생태계","pages":[{"title":"생태계","href":"/ko/integrations/home"}]},{"item":"ClickPipes","pages":[{"title":"ClickPipes","href":"/ko/integrations/clickpipes/home"}]},{"item":"언어 클라이언트","pages":[{"title":"언어 클라이언트","href":"/ko/integrations/language-clients"}]},{"item":"커넥터","pages":[{"title":"커넥터","href":"/ko/integrations/connectors/data-sources"}]}],"pages":[{"title":"통합","href":"/ko/integrations/home"}]},{"tab":"자료","menu":[{"item":"지원 센터","pages":[{"title":"지원 센터","href":"/ko/resources/support-center/home"}]},{"item":"개발 및 기여","pages":[{"title":"개발 및 기여","href":"/ko/resources/develop-contribute/introduction/developer-instruction"}]},{"item":"변경 내역","dropdowns":[{"dropdown":"Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"Cloud","href":"/ko/resources/changelogs/cloud"}]},{"dropdown":"오픈 소스","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-server.svg","pages":[{"title":"오픈 소스","href":"/ko/resources/changelogs/oss/2026"}]}]},{"item":"소개","pages":[{"title":"소개","href":"/ko/resources/about"}]}],"pages":[{"title":"자료","href":"/ko/resources/support-center/home"}]}]},{"language":"pt-BR","pages":[{"title":"pt-BR","href":"/pt-BR/get-started/about/intro"}]},{"language":"ru","pages":[{"title":"ru","href":"/ru/get-started/about/intro"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/get-started/about/intro"}]}]},"basePath":"","title":"ClickHouse란 무엇입니까? - ClickHouse Documentation","deploymentId":"dpl_2MqcLy8smQrrovUehgcZEsoo1tJX","buildId":"dpl_2MqcLy8smQrrovUehgcZEsoo1tJX","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-BSnmehho.js","DynamicMarkdown-CU5QIokU.js","zoom-image-lightbox-TD6wszNR.js","lightbox-handle-r17bVUz3.js"]}