Bigdata
Now Reading
ClickHouse
0
Review

ClickHouse

Overview
Synopsis

ClickHouse is an open-source Column-oriented DBMS for online analytical processing. ClickHouse's performance exceeds comparable column-oriented DBMS currently available on the market.

Category

Column-oriented DBMS

Features

• Vector engine: Achieve high CPU performance
• Real-time data updates: There is no locking when adding data
• True column-oriented storage
• Parallel and distributed query execution
• State-of-the-art algorithms
• Pluggable external dimension tables

License

• Open source

Price

• Open source

Pricing

Subscription

Free Trial

Available

Users Size

Small (<50 employees), Medium (50 to 1000 employees), Enterprise (>1001 employees)

Company

ClickHouse

What is best?

• Vector engine: Achieve high CPU performance
• Real-time data updates: There is no locking when adding data
• True column-oriented storage
• Parallel and distributed query execution

What are the benefits?

• Parallel processing on multiple cores: Large queries are parallelized in a natural way
• Distributed processing on multiple servers: Reside on different shards
• Support running an aggregation for a limited number of random keys, instead of for all keys
• Fault tolerant: Replicated data are synchronized automatically or semi-automatically after server downtime

PAT Rating™
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
7.6
8.4
Features & Functionality
7.6
8.8
Advanced Features
7.6
7.8
Integration
7.6
8.1
Performance
7.6
10
Customer Support
7.6
8.0
Implementation
9.3
Renew & Recommend
10
Bottom Line

ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.

7.6
Editor Rating
8.8
Aggregated User Rating
11 ratings
You have rated this

ClickHouse is an open-source Column-oriented DBMS for online analytical processing. ClickHouse's performance exceeds comparable column-oriented DBMS currently available on the market. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second. ClickHouse is simple and works out-of-the-box. As well as performing on hundreds of node clusters, this system can be easily installed on a single server or even a virtual machine. ClickHouse uses all available hardware to its full potential to process each query as fast as possible. The peak processing performance for a single query stands at more than 2 terabytes per second. ClickHouse features a user-friendly SQL query dialect with a number of built-in analytics capabilities. For example, it includes probabilistic data structures for fast and memory-efficient calculation of cardinalities and quantiles. There are functions for working dates, times and time zones, as well as some specialized ones like addressing URLs and IPs (both IPv4 and IPv6). ClickHouse can be configured as purely distributed system located on independent nodes, without any single points of failure. ClickHouse allows companies to add servers to their clusters when necessary without investing time or money into any additional DBMS modification. ClickHouse is CPU efficient because of its vectorized query execution involving relevant processor instructions and runtime code generation. By minimizing data transfers for most types of queries, ClickHouse enables companies to manage their data and create reports without using specialized networks that are aimed at high-performance computing. ClickHouse offers flexible limits on query complexity and resource usage, which can be fine-tuned with settings. It is possible to simultaneously serve both a number of high priority low-latency requests and some long-running queries with background priority.

Filter reviews
User Ratings





User Company size



User role





User industry





Ease of use
Features & Functionality
Advanced Features
Integration
Performance
Customer Support
Implementation
Renew & Recommend

What's your reaction?
Love It
0%
Very Good
0%
INTERESTED
0%
COOL
0%
NOT BAD
0%
WHAT !
0%
HATE IT
0%