Please enable JavaScript.
Coggle requires JavaScript to display documents.
10 Reasons to use Clickhouse (WHY (Russians!, Born because of a need,…
10 Reasons to use Clickhouse
It's fast
instant insert
instant select (sub-second queries)
real-time
evantually delete, update
Better SQL+
countIf
sumIf
multiIf
orderby if
arrayJoin
ARRAY JOIN
arrayMap(Euclidian Distance)
geoLocation
date functions
system.numbers
Integration
Kafka
MySQL
Remote
JDBC as Fact table
ODBC
HDFS
Apache Parquet
Google ProtoBuf
Scalability
Horizontal
Linear
Uses all cores
Compression
Customizable compression
Delta
DeltaDelta
Rest Capabilities
URL
REST server
REST client with JSON
JSON functions
Great Features
clickhouse-local
CLI
3rd-party tools
3rd-party tools
Altinity Kubernetes-operator
chproxy
KittenHouse
Clickhouse-Bulk
Constantly Improving
Production Ready
Already used in Metrica
Fault tolerant
Backup options on the way
Company
Developer
WHY
Russians!
Born because of a need
Simplicity
Awesome Table Capabilities
Array Columns
Nested Columns
TTL Columns
TTL Tables
AggregateTables (Materialized Views)
Enums
Dictionaries