Need advice about which tool to choose?Ask the StackShare community!
Add tool
Clickhouse vs Vertica: What are the differences?
What is Clickhouse? A column-oriented database management system. It allows analysis of data that is updated in real time. It offers instant results in most cases: the data is processed faster than it takes to create a query.
What is Vertica? Engineering experiences that amaze. Vertica provides a best-in-class, unified analytics platform that will forever be independent from underlying infrastructure.
Clickhouse and Vertica can be primarily classified as "Databases" tools.
According to the StackShare community, Clickhouse has a broader approval, being mentioned in 22 company stacks & 11 developers stacks; compared to Vertica, which is listed in 3 company stacks and 3 developer stacks.
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn MorePros of Clickhouse
Pros of Vertica
Pros of Clickhouse
- Fast, very very fast19
- Good compression ratio11
- Horizontally scalable6
- Great CLI5
- RESTful5
- Utilizes all CPU resources5
- Open-source4
- Great number of SQL functions4
- Has no transactions3
- Buggy3
- Server crashes its normal :(2
- ODBC2
- Flexible connection options2
- Flexible compression options2
- Highly available2
- In IDEA data import via HTTP interface not working1
Pros of Vertica
- Shared nothing or shared everything architecture2
- Reduce costs as reduced hardware is required1
- Offers users the freedom to choose deployment mode1
- Flexible architecture suits nearly any project1
- End-to-End ML Workflow Support1
- All You Need for IoT, Clickstream or Geospatial1
- Freedom from Underlying Storage1
- Pre-Aggregation for Cubes (LAPS)1
- Automatic Data Marts (Flatten Tables)1
- Near-Real-Time Analytics in pure Column Store1
- Fully automated Database Designer tool1
- Query-Optimized Storage1
- Vertica is the only product which offers partition prun1
- Partition pruning and predicate push down on Parquet1
Sign up to add or upvote prosMake informed product decisions
Cons of Clickhouse
Cons of Vertica
Cons of Clickhouse
- Slow insert operations5
Cons of Vertica
Be the first to leave a con
Sign up to add or upvote consMake informed product decisions
What is Clickhouse?
It allows analysis of data that is updated in real time. It offers instant results in most cases: the data is processed faster than it takes to create a query.
What is Vertica?
It provides a best-in-class, unified analytics platform that will forever be independent from underlying infrastructure.
Need advice about which tool to choose?Ask the StackShare community!
Jobs that mention Clickhouse and Vertica as a desired skillset
What companies use Clickhouse?
What companies use Vertica?
What companies use Clickhouse?
See which teams inside your own company are using Clickhouse or Vertica.
Sign up for StackShare EnterpriseLearn MoreSign up to get full access to all the companiesMake informed product decisions
What tools integrate with Clickhouse?
What tools integrate with Vertica?
What tools integrate with Clickhouse?
Sign up to get full access to all the tool integrationsMake informed product decisions
What are some alternatives to Clickhouse and Vertica?
Cassandra
Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
Elasticsearch
Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
InfluxDB
InfluxDB is a scalable datastore for metrics, events, and real-time analytics. It has a built-in HTTP API so you don't have to write any server side code to get up and running.
InfluxDB is designed to be scalable, simple to install and manage, and fast to get data in and out.
Druid
Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.