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."The most valuable feature is Vertica's performance and the ease of using the database."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"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."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Speed and resiliency are probably the best parts of this product."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"I like the projection feature, which increases query performance."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"The most valuable feature for us is horizontal scaling."
"It's one of the fastest databases in the market. It's easy to use. From a maintenance perspective it's a good product. The segmentation, or architecture of the product is different than other databases such as Oracle. So even in 10 years, the data distribution for such segments will not affect other segments. The query performance of the product, for complex queries, is very good. It has good integration with Hadoop."
"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."
"Helps us to achieve large-scale 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."
"A very good, open-source platform."
"Very fast for query processing."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"The integration of this solution with ODI could be improved."
"It would be great if this were a managed service in AWS."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"It should provide a GUI interface for data management and tuning."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"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."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"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."
"It will be very useful if we could communicate with other database types from Greenplum (using a database link)."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"The installation is difficult and should be made easier."
"Implementation takes a long time."
"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 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."
Vertica is ranked 4th in Data Warehouse with 83 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 36 reviews. Vertica is rated 8.2, 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 MySQL, 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.
