ClickHouse Documentation Overview
Type to start searching
      • Overview
      • Distinctive Features of ClickHouse
      • ClickHouse Features that Can Be Considered Disadvantages
      • Performance
      • History
      • Adopters
      • Installation
      • Tutorial
        • OnTime
        • New York Taxi Data
        • AMPLab Big Data Benchmark
        • WikiStat
        • Terabyte Click Logs from Criteo
        • Star Schema Benchmark
        • Yandex.Metrica Data
      • Introduction
      • Command-Line Client
      • Native Interface (TCP)
      • HTTP Interface
      • MySQL Interface
      • Input and Output Formats
      • JDBC Driver
      • ODBC Driver
      • C++ Client Library
        • Client Libraries
        • Integrations
        • Visual Interfaces
        • Proxies
        • Introduction
          • MergeTree
          • Data Replication
          • Custom Partitioning Key
          • ReplacingMergeTree
          • SummingMergeTree
          • AggregatingMergeTree
          • CollapsingMergeTree
          • VersionedCollapsingMergeTree
          • GraphiteMergeTree
          • Introduction
          • StripeLog
          • Log
          • TinyLog
          • Kafka
          • MySQL
          • JDBC
          • ODBC
          • HDFS
          • Distributed
          • External data
          • Dictionary
          • Merge
          • File
          • Null
          • Set
          • Join
          • URL
          • View
          • MaterializedView
          • Memory
          • Buffer
        • Introduction
        • MySQL
        • Lazy
      • Syntax
        • SELECT
        • INSERT INTO
        • CREATE
        • ALTER
        • SYSTEM
        • SHOW
        • Other
        • Introduction
        • Arithmetic
        • Comparison
        • Logical
        • Type Conversion
        • Working with Dates and Times
        • Working with strings
        • For Searching Strings
        • For Replacing in Strings
        • Conditional
        • Mathematical
        • Rounding
        • Working with Arrays
        • Splitting and Merging Strings and Arrays
        • Bit
        • Bitmap
        • Hash
        • Generating Pseudo-Random Numbers
        • Encoding
        • Working with UUID
        • Working with URLs
        • Working with IP Addresses
        • Working with JSON.
        • Higher-Order
        • Working with External Dictionaries
        • Working with Yandex.Metrica Dictionaries
        • Implementing the IN Operator
        • arrayJoin
        • Working with geographical coordinates
        • Working with Nullable arguments
        • Machine Learning Functions
        • Introspection
        • Other
        • Introduction
        • Reference
        • Aggregate function combinators
        • Parametric aggregate functions
        • Introduction
        • file
        • merge
        • numbers
        • remote
        • url
        • mysql
        • jdbc
        • odbc
        • hdfs
        • input
        • Introduction
          • General Description
          • Configuring an External Dictionary
          • Storing Dictionaries in Memory
          • Dictionary Updates
          • Sources of External Dictionaries
          • Dictionary Key and Fields
          • Hierarchical dictionaries
        • Internal Dictionaries
      • Operators
        • Introduction
        • UInt8, UInt16, UInt32, UInt64, Int8, Int16, Int32, Int64
        • Float32, Float64
        • Decimal
        • Boolean
        • String
        • FixedString(N)
        • UUID
        • Date
        • DateTime
        • Enum
        • Array(T)
        • AggregateFunction(name, types_of_arguments...)
        • Tuple(T1, T2, ...)
        • Nullable
          • Nested(Name1 Type1, Name2 Type2, ...)
          • Expression
          • Set
          • Nothing
          • Interval
          • Overview
          • IPv4
          • IPv6
      • Overview
      • Applying CatBoost Models
      • Introduction
      • Requirements
      • Monitoring
      • Troubleshooting
      • ClickHouse Update
      • Access Rights
      • Data Backup
      • Configuration Files
      • Quotas
      • System Tables
        • Query Profiling
      • Testing Hardware
        • Introduction
        • Server Settings
        • Introduction
        • Permissions for Queries
        • Restrictions on Query Complexity
        • Settings
        • Settings Profiles
        • Constraints on Settings
        • User Settings
        • Overview
        • clickhouse-copier
        • clickhouse-local
        • clickhouse-benchmark
      • Usage Recommendations
      • The Beginner ClickHouse Developer Instruction
      • Overview of ClickHouse Architecture
      • Browse ClickHouse Source Code
      • How to Build ClickHouse on Linux
      • How to Build ClickHouse on Mac OS X
      • How to Build ClickHouse on Linux for Mac OS X
      • How to Build ClickHouse on Linux for AARCH64 (ARM64)
      • How to Write C++ Code
      • How to Run ClickHouse Tests
      • Third-Party Libraries Used
      • Roadmap
      • Changelog
      • Security Changelog
      • General Questions
    • Release:  ▾
    • Single page version
    • PDF version
    • ClickHouse source code
    

    ClickHouse Guides¶

    Detailed step-by-step instructions that will help you solve various tasks using ClickHouse.

    • Applying a CatBoost Model in ClickHouse
    Previous IPv6
    Next Applying CatBoost Models
    ©2016–2020 Yandex LLC
    Built from 4b46a05