Skip to main content
Products
ClickHouse Cloud
The best way to use ClickHouse.
Available on AWS, GCP, and Azure.
Bring Your Own Cloud
A fully managed ClickHouse Cloud service,
deployed in your own AWS account.
ClickHouse
Spin up a database with open-source
ClickHouse
View 100+ integrations
View 100+ integrations
Use cases
Real-time analytics
Machine learning and GenAI
Business intelligence
Logs, events, and traces
All use cases
All use cases
Docs
Resources
User stories
Blog
Learning and Certification
ClickHouse Academy
Free live training
ClickHouse Certification
Comparisons
BigQuery
PostgreSQL
Redshift
Rockset
Snowflake
Videos
Demos
Pricing
Contact us
41.8k
Search
Sign in
Get started
EN
Getting Started
▼
Cloud
▼
Manage Data
▼
Server Admin
▼
Reference
▼
Integrations
▼
ClickStack
▼
chDB
▼
About
▼
Getting Started
Cloud
Manage Data
Server Admin
Reference
Integrations
ClickStack
chDB
About
Knowledge Base
English
English
日本語
中文
Русский
Skip to main content
Products
ClickHouse Cloud
The best way to use ClickHouse.
Available on AWS, GCP, and Azure.
Bring Your Own Cloud
A fully managed ClickHouse Cloud service,
deployed in your own AWS account.
ClickHouse
Spin up a database with open-source
ClickHouse
View 100+ integrations
View 100+ integrations
Use cases
Real-time analytics
Machine learning and GenAI
Business intelligence
Logs, events, and traces
All use cases
All use cases
Docs
Resources
User stories
Blog
Learning and Certification
ClickHouse Academy
Free live training
ClickHouse Certification
Comparisons
BigQuery
PostgreSQL
Redshift
Rockset
Snowflake
Videos
Demos
Pricing
Contact us
41.8k
Search
Sign in
Get started
EN
main-menu
Introduction
▼
Syntax
Input and Output Formats
Data Types
▼
Statements
▼
Operators
▼
Engines
▼
Functions
▼
Regular Functions
▼
Overview
Arithmetic
Arrays
arrayJoin
Bit
Bitmap
Comparison
Conditional
Dates and time
Distance
Embedded dictionary
Encoding
Encryption
Dictionaries
Files
Financial
Nullable
Geo
▼
Hash
IN Operator
Introspection
IP Addresses
JSON
Logical
Machine Learning
Mathematical
NLP
NumericIndexedVector
Other
Random number
Rounding
String splitting
String
String replacement
String search
Time-series
Time-window
Tuples
Maps
Type conversion
UDF
ULID
uniqTheta
URLs
UUIDs
Aggregate Functions
▼
Table Functions
▼
Window Functions
▼
Getting Started
Cloud
Manage Data
Server Admin
Reference
Integrations
ClickStack
chDB
About
Knowledge Base
English
English
日本語
中文
Русский
Functions
Regular Functions
Distance
Edit this page
Distance functions
Previous
Dates and time
Next
Embedded dictionary
Was this page helpful?
