Skip to main content

ClickHouse

ClickHouse® is a high-performance, column-oriented SQL database designed for online analytical processing (OLAP) workloads.

Supported Versions and Architectures​

  • Versions: ClickHouse v21.x and above
  • Architectures: Standalone and cluster deployments

Supported Data Types​

CategoryData Types
Numeric TypesInt8, Int16, Int32, Int64, UInt8, UInt16, UInt32, UInt64, Float32, Float64, Decimal
String TypesString, FixedString
Date & Time TypesDate, DateTime, DateTime64
Boolean TypeBool
Array & Tuple TypesArray, Tuple
Special TypesUUID, Enum, Nullable

Quick Setup Guide​

1. Enable Access Control​

Enable access control in ClickHouse configuration and restart the service.

2. Create Database User​

CREATE USER xpipes HOST ANY IDENTIFIED WITH sha256_password BY 'your_password';

3. Grant Permissions​

GRANT SELECT, INSERT, CREATE TABLE, ALTER TABLE, ALTER UPDATE, DROP TABLE, TRUNCATE
ON your_database.* TO xpipes;

Limitations​

  • Binary fields: Binary data types must be excluded via field mapping
  • HTTP port: Uses HTTP API (default port 8123, SSL port 8443)