We performed a comparison between Vertica and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"Eighty percent of the ETL operations have improved since implementing this solution."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"I like the projection feature, which increases query performance."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"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."
"Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform."
"The parallel load features mean that Greenplum is capable of high-volume data loading in parallel to all of the cluster segments, which is really valuable."
"It's super easy to deploy and it also supports different languages and analytics."
"With VMware Tanzu Greenplum, one can make a huge database table and analyze the queries by adding in the SQL command. Some hint or command for the query goes over the multi-parallel execution."
"Pivotal Greenplum's shared-nothing architecture."
"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 loading speed is very good."
"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."
"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."
"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."
"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."
"It needs integration with multiple clouds."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"It should provide a GUI interface for data management and tuning."
"Support is an area where it could get better."
"Limitations in group by projections is where I would like to see an improvement."
"Extra filters would be helpful."
"they need to interact more with customers. They need to explain the features, especially when there are new releases of Greenplum. I know just from information I've found that it has other features, it can be used to for analytics, for integration with Big Data, Hadoop. They need to focus on this part with the customer."
"Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality, like fully down processing, etc."
"If you have a user consuming a huge load of resources, it takes down the entire system."
"They need to enhance integration with other Big Data products... to integrate with Big Data platforms, and to open a bi-directional connection between Greenplum and Big Data."
"They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."
"It will be very useful if we could communicate with other database types from Greenplum (using a database link)."
"Tanzu Greenplum's compression for GPText could be made more efficient."
Vertica is ranked 4th in Data Warehouse with 82 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 36 reviews. Vertica is rated 8.4, while VMware Tanzu Greenplum is rated 7.8. The top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". On the other hand, the top reviewer of VMware Tanzu Greenplum writes "Very efficient at large scale analytics; lacks inbuilt machine-learning functions for complex use cases". Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and SAP HANA, whereas VMware Tanzu Greenplum is most compared with Oracle Exadata, Oracle Database Appliance, Apache Hadoop, Snowflake and Teradata. See our VMware Tanzu Greenplum vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
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.