Try our new research platform with insights from 80,000+ expert users

VMware Tanzu Data Solutions vs Vertica comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Vertica
Ranking in Data Warehouse
5th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (11th)
VMware Tanzu Data Solutions
Ranking in Data Warehouse
9th
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
83
Ranking in other categories
Database Development and Management (7th), Relational Databases Tools (11th), Message Queue (MQ) Software (5th)
 

Mindshare comparison

As of April 2025, in the Data Warehouse category, the mindshare of Vertica is 8.6%, down from 8.7% compared to the previous year. The mindshare of VMware Tanzu Data Solutions is 4.1%, down from 5.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…
Sushma Polavarapu - PeerSpot reviewer
Create essential reporting scripts with simplicity but has some operational challenges
We mainly create functions and scripts required for reporting The product is not complex; I do not have to create stored procedures, functions, or views. It's just simple to use. There is general room for improvement. I have been using it for five years. I have faced stability issues, mainly…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Initiate on one node, and the RPM propagates automatically to all other nodes. ​"
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"The most valuable feature of Vertica is the unmatchable database performance."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database."
"The product is not complex."
"Very fast for query processing."
"Some of the most valuable features are publish and subscribe, fanout, and queues."
"Very sophisticated routing control and priority messaging capabilities"
"The most valuable feature is asynchronous calls, which are easy to configure."
"The security is great."
"Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform."
 

Cons

"The documentation of Vertica is an area with shortcomings where improvements are required."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"The biggest problem is the cost of cloud deployment."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"The fact that a single queue can't be distributed across multiple instances/nodes is a major disadvantage."
"VMware Tanzu Greenplum needs improvement in the memory area and improved methods for quick access to the disc. So, one of the quick goals of Greenplum must work on enhancing access to the disc by adding hints in the database."
"They should improve on the ability to scale your queues in a very simple and elegant way with the same power that they have would be great."
"VMware RabbitMQ needs to create a new queue system."
"The initial deployment was a little difficult."
"Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality, like fully down processing, etc."
"Maintenance is time-consuming."
"The debugging capabilities and testing flexibilities need to be improved."
 

Pricing and Cost Advice

"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"The pricing could improve, it is a little expensive."
"Read the fine print carefully."
"From a cost perspective, the software is less than most of its competitors."
"The pricing for this solution is very reasonable compared to other vendors."
"It's an expensive product"
"It is an open-source product."
"Tanzu Greenplum's pricing is really competitive and gives excellent value for money."
"On a scale of one to five, with five being the most competitive pricing, I would rate this solution as a four."
"We are using the open-source version of this solution."
"are using the open-source version, which can be used free of cost."
"Since the tool is an open-source product, there is no need to pay anything."
"It is the best product with best fit for price/performance customer objectives."
"The solution's pricing is cost-effective as it does not involve significant expenses. Licensing is required only for the server, while clients do not need any licensing. Therefore, it proves to be a cost-efficient option."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
845,040 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Computer Software Company
18%
Manufacturing Company
8%
Real Estate/Law Firm
4%
Financial Services Firm
28%
Computer Software Company
16%
Manufacturing Company
7%
Healthcare Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
How does IBM MQ compare with VMware RabbitMQ?
IBM MQ has a great reputation behind it, and this solution is very robust with great stability. It is easy to use, simple to configure and integrates well with our enterprise ecosystem and protocol...
What is your experience regarding pricing and costs for VMware Tanzu Greenplum?
It’s an open-source solution. There are no expenses for using it.
 

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Greenplum, Pivotal Greenplum, VMware RabbitMQ, VMware Tanzu GemFire, VMware Postgres
 

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
General Electric, Conversant, China CITIC Bank, Aridhia, Purdue University
Find out what your peers are saying about VMware Tanzu Data Solutions vs. Vertica and other solutions. Updated: February 2025.
845,040 professionals have used our research since 2012.