Compare Pivotal Greenplum vs. Vertica

Pivotal Greenplum is ranked 7th in Data Warehouse with 4 reviews while Vertica is ranked 5th in Data Warehouse with 7 reviews. Pivotal Greenplum is rated 7.2, while Vertica is rated 9.2. The top reviewer of Pivotal Greenplum writes "A scalable and future-proof solution for data warehousing". On the other hand, the top reviewer of Vertica writes "Allows us to take volumes and process them at a very high speed". Pivotal Greenplum is most compared with Apache Hadoop, Amazon Redshift and Teradata, whereas Vertica is most compared with Snowflake, Apache Hadoop and Amazon Redshift. See our Pivotal Greenplum vs. Vertica report.
Cancel
You must select at least 2 products to compare!
Pivotal Greenplum Logo
12,124 views|8,593 comparisons
Vertica Logo
16,130 views|8,994 comparisons
Most Helpful Review
Use Pivotal Greenplum? Share your opinion.
Find out what your peers are saying about Pivotal Greenplum vs. Vertica and other solutions. Updated: March 2020.
406,312 professionals have used our research since 2012.
Quotes From Members

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

Pros
Pivotal Greenplum's shared-nothing architecture.The most valuable feature for us is horizontal scaling.Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible.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.

Read more »

The performance is very good and the aggregate records are fast.Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.Allows us to take volumes and process them at a very high speed.Eighty percent of the ETL operations have improved since implementing this solution.It maximize cloud economics for mission-critical big data analytical initiatives.It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands.Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics.Any novice user can tune vertical queries with minimal training (or no training at all).

Read more »

Cons
Initial setup is a little complex. It took around two weeks to deploy.I saw some limitation with respect to the column store, and removing this would be an improvement.Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality, like fully down processing, etc.The installation is difficult and should be made easier.

Read more »

When it is about to reach the maximum storage capacity, it becomes slow.Support is an area where it could get better.Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.Fact-to-fact joins on multi-billion record tables perform poorly.It needs integration with multiple clouds.It should provide a GUI interface for data management and tuning.Monitoring tools need to be lightweight. They should not take up heavy resources of the main server.If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer.

Read more »

Pricing and Cost Advice
We are using the open-source version of this solution.

Read more »

It is fast to purchase through the AWS Marketplace.The pricing and licensing depend on the size of your environment and the zone where you want to implement.Read the fine print carefully.

Read more »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
406,312 professionals have used our research since 2012.
Answers from the Community
Chienlung Chan
Ranking
7th
out of 31 in Data Warehouse
Views
12,124
Comparisons
8,593
Reviews
5
Average Words per Review
433
Avg. Rating
7.4
5th
out of 31 in Data Warehouse
Views
16,130
Comparisons
8,994
Reviews
6
Average Words per Review
214
Avg. Rating
9.0
Top Comparisons
Compared 37% of the time.
Compared 13% of the time.
Compared 11% of the time.
Compared 17% of the time.
Compared 13% of the time.
Compared 11% of the time.
Also Known As
GreenplumMicro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn
Pivotal
Micro Focus
Overview

Advanced analytics meets traditional business intelligence with Pivotal Greenplum, the world’s first fully-featured, multi-cloud, massively parallel processing (MPP) data platform based on the open source Greenplum Database. Pivotal Greenplum provides comprehensive and integrated analytics on multi-structured data. Powered by one of the world’s most advanced cost-based query optimizers, Pivotal Greenplum delivers unmatched analytical query performance on massive volumes of data.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about Pivotal Greenplum
Learn more about Vertica
Sample Customers
General Electric, Conversant, China CITIC Bank, Aridhia, Purdue UniversityCerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
REVIEWERS
Financial Services Firm44%
Marketing Services Firm19%
Comms Service Provider19%
Pharma/Biotech Company6%
VISITORS READING REVIEWS
Software R&D Company34%
Financial Services Firm15%
Comms Service Provider14%
Insurance Company4%
REVIEWERS
Software R&D Company21%
Media Company21%
Marketing Services Firm17%
Comms Service Provider14%
VISITORS READING REVIEWS
Software R&D Company37%
Comms Service Provider21%
Media Company6%
Financial Services Firm5%
Find out what your peers are saying about Pivotal Greenplum vs. Vertica and other solutions. Updated: March 2020.
406,312 professionals have used our research since 2012.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.