ClickHouse Documentation Overview
Type to start searching
      • Overview
      • Distinctive Features of ClickHouse
      • ClickHouse Features that Can Be Considered Disadvantages
      • Performance
      • The Yandex.Metrica Task
      • Deploying and Running
        • 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
      • Input and Output Formats
      • JDBC Driver
      • ODBC Driver
        • Client Libraries
        • Integrations
        • Visual Interfaces
        • Proxies
      • 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
      • Introduction
        • MergeTree
        • Data Replication
        • Custom Partitioning Key
        • ReplacingMergeTree
        • SummingMergeTree
        • AggregatingMergeTree
        • CollapsingMergeTree
        • VersionedCollapsingMergeTree
        • GraphiteMergeTree
        • Introduction
        • StripeLog
        • Log
        • TinyLog
        • Kafka
        • MySQL
        • Distributed
        • External data
        • Dictionary
        • Merge
        • File
        • Null
        • Set
        • Join
        • URL
        • View
        • MaterializedView
        • Memory
        • Buffer
      • SELECT
      • INSERT INTO
      • CREATE
      • ALTER
      • Other Kinds of Queries
        • 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 functions
        • 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
        • Other
        • Introduction
        • Reference
        • Aggregate function combinators
        • Parametric aggregate functions
        • Introduction
        • file
        • merge
        • numbers
        • remote
        • url
        • jdbc
        • Introduction
          • General Description
          • Configuring an External Dictionary
          • Storing Dictionaries in Memory
          • Dictionary Updates
          • Sources of External Dictionaries
          • Dictionary Key and Fields
        • Internal Dictionaries
      • Operators
      • General Syntax
      • Introduction
      • Requirements
      • Monitoring
      • Troubleshooting
      • Usage Recommendations
      • ClickHouse Update
      • Access Rights
      • Data Backup
      • Configuration Files
      • Quotas
      • System Tables
        • Introduction
        • Server Settings
        • Introduction
        • Permissions for Queries
        • Restrictions on Query Complexity
        • Settings
        • Settings Profiles
        • Overview
        • clickhouse-copier
        • clickhouse-local
      • General Questions
      • Overview of ClickHouse Architecture
      • How to Build ClickHouse on Linux
      • How to Build ClickHouse on Mac OS X
      • How to Write C++ code
      • How to Run ClickHouse Tests
      • Third-Party Libraries Used
      • Roadmap
      • Changelog
      • Security Changelog
    • Single page version
    • PDF version
    • ClickHouse source code
    

    ClickHouse Utility¶

    • clickhouse-local — Allows running SQL queries on data without stopping the ClickHouse server, similar to how awk does this.
    • clickhouse-copier — Copies (and reshards) data from one cluster to another cluster.

    Original article

    Previous Settings Profiles
    Next clickhouse-copier
    ©2016–2019 Yandex LLC