ClickHouse Documentation
hidden
Type to start searching
ClickHouse Documentation
Introduction
Introduction
Overview
Distinctive Features of ClickHouse
ClickHouse Features that Can Be Considered Disadvantages
Performance
The Yandex.Metrica Task
Getting Started
Getting Started
Deploying and Running
Example Datasets
Example Datasets
OnTime
New York Taxi Data
AMPLab Big Data Benchmark
WikiStat
Terabyte Click Logs from Criteo
Star Schema Benchmark
Yandex.Metrica Data
Interfaces
Interfaces
Introduction
Command-Line Client
Native Interface (TCP)
HTTP Interface
Input and Output Formats
JDBC Driver
ODBC Driver
Third-Party
Third-Party
Client Libraries
Integrations
Visual Interfaces
Proxies
Data Types
Data Types
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 Data Structures
Nested Data Structures
Nested(Name1 Type1, Name2 Type2, ...)
Special Data Types
Special Data Types
Expression
Set
Nothing
Table Engines
Table Engines
Introduction
MergeTree Family
MergeTree Family
MergeTree
Data Replication
Custom Partitioning Key
ReplacingMergeTree
SummingMergeTree
AggregatingMergeTree
CollapsingMergeTree
VersionedCollapsingMergeTree
GraphiteMergeTree
Log Family
Log Family
Introduction
StripeLog
Log
TinyLog
Integrations
Integrations
Kafka
MySQL
Special
Special
Distributed
External data
Dictionary
Merge
File
Null
Set
Join
URL
View
MaterializedView
Memory
Buffer
SQL Reference
SQL Reference
SELECT
INSERT INTO
CREATE
ALTER
Other Kinds of Queries
Functions
Functions
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
Aggregate Functions
Aggregate Functions
Introduction
Reference
Aggregate function combinators
Parametric aggregate functions
Table Functions
Table Functions
Introduction
file
merge
numbers
remote
url
jdbc
Dictionaries
Dictionaries
Introduction
External Dictionaries
External Dictionaries
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
Operations
Operations
Introduction
Requirements
Monitoring
Troubleshooting
Usage Recommendations
ClickHouse Update
Access Rights
Data Backup
Configuration Files
Quotas
System Tables
Server Configuration Parameters
Server Configuration Parameters
Introduction
Server Settings
Settings
Settings
Introduction
Permissions for Queries
Restrictions on Query Complexity
Settings
Settings Profiles
Utilities
Utilities
Overview
clickhouse-copier
clickhouse-local
F.A.Q.
F.A.Q.
General Questions
Development
Development
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
What's New
What's New
Roadmap
Changelog
Security Changelog
Single page version
PDF version
ClickHouse source code
SQL Reference
¶
SELECT
INSERT INTO
CREATE
ALTER
Other types of queries
Original article