# VMware Greenplum Reviews **Vendor:** Broadcom **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.3/5.0 **Total Reviews:** 60 ## About VMware Greenplum Advanced analytics meets traditional business intelligence with VMware Greenplum, the world’s first fully-featured, multi-cloud, massively parallel processing (MPP) data platform based on the open source Greenplum Database. Greenplum provides comprehensive and integrated analytics on multi-structured data. Powered by one of the world’s most advanced cost-based query optimizers, VMware Greenplum delivers unmatched analytical query performance on massive volumes of data. ## VMware Greenplum Reviews ### 1. Greenplum - BIg Data Database **Rating:** 4.0/5.0 stars **Reviewed by:** Naveen A. | Business Analyst, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** June 18, 2022 **What do you like best about VMware Greenplum?** It is most modern and powerful DB build **What do you dislike about VMware Greenplum?** It's one of the most modern and powerful open source DB built for modern analytics using AI. The Database is built on already popular Postgres DB architecture which is a proven technology. Green plumb provides the unique cost-based query optimizer which helps to query large amounts of data and still pay less. This also does not degrade the DB performance even while dealing with petabytes of data. It's easy to deploy and maintain. Greenplum also provides AI features that collaborate with the analytics and operational workload features. **What problems is VMware Greenplum solving and how is that benefiting you?** Used for storing the retail analytics data and using the inbuild in-database analytics features we are generating various insights with less dependency on the external tools. Also, the machine learning capabilities of the database help run the complex algorithms very effectively. ### 2. Excellent mpp tool and beat for data warehouse and ingestion through big data **Rating:** 4.5/5.0 stars **Reviewed by:** ritesh g. | Data Engineer II, Mid-Market (51-1000 emp.) **Reviewed Date:** March 29, 2020 **What do you like best about VMware Greenplum?** 1)UI and scripting options for greennplum. 2) Greenplum command center and alert with out of memory, max connections and segment failure helps the Dba to solve the issues quickly. **What do you dislike about VMware Greenplum?** Some inbuilt maintenance like vaccum should be there. And some new issues comes up after upgrade so more testing from pivotal is required. **Recommendations to others considering VMware Greenplum:** Good mpp technology can always go ahead with greenplum for ingestion and big data use cases **What problems is VMware Greenplum solving and how is that benefiting you?** Have solved indexing issue in greenplum and backups option as well. Have solved segment failures issue, Max connections and Out of memory and also solved fragmentation issues ### 3. Not widely used but a good option **Rating:** 2.5/5.0 stars **Reviewed by:** Eusuf K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** June 08, 2021 **What do you like best about VMware Greenplum?** Greenplum is a good option to have, but till now, I have not seen significant market depth in its usage. Its capabilities are excellent. **What do you dislike about VMware Greenplum?** While it has great potential, there are other players which are far easier to use and have more acceptance. **Recommendations to others considering VMware Greenplum:** Check out Snowflake, AWS, Azure and GCP offerings as they are the most popular ones as well as provide premium support. **What problems is VMware Greenplum solving and how is that benefiting you?** Greenplum is currently being used by us as a data source for performing ETL. We solve migrating to and from various data sources of which Greenplum is also a part. ### 4. Experience in using greenplum for 2 years **Rating:** 3.5/5.0 stars **Reviewed by:** Forest L. | Vice General Manager, Enterprise (> 1000 emp.) **Reviewed Date:** June 03, 2021 **What do you like best about VMware Greenplum?** - PostgreSQL Compatibility - Versatile plugins - Versatile support for json handling and GIS - Easy of use - Easy of integration with external data source **What do you dislike about VMware Greenplum?** - Performance isn't good for extensive datasets processing (e.g. query, join...) - Performance tuning is hard - Adding new data node is not easy - Concurrency processing isn't good enough - No support for columnar mode query **What problems is VMware Greenplum solving and how is that benefiting you?** I am solving performance issue and learn that distribution key design is so important for greenplumn ### 5. User Friendly and easy to use. It has multiple features which is very effective in data analysis. **Rating:** 4.5/5.0 stars **Reviewed by:** Arunesh T. | Lead Assistant Manager, Enterprise (> 1000 emp.) **Reviewed Date:** April 06, 2020 **What do you like best about VMware Greenplum?** Easy to use, performance and implementation. **What do you dislike about VMware Greenplum?** Consolidation of third party integration **Recommendations to others considering VMware Greenplum:** GreenPlum is highly recommended purely for its performance and the ease of use **What problems is VMware Greenplum solving and how is that benefiting you?** Handling Data analytics problem and large data sets effectively and efficiently with accuracy. ### 6. Excellent Scalable Unsupervised machine learning database **Rating:** 5.0/5.0 stars **Reviewed by:** Anand V. | CGIA Member, Small-Business (50 or fewer emp.) **Reviewed Date:** June 06, 2021 **What do you like best about VMware Greenplum?** Ease of use, Ease of integration, deployment models, visualization, reporting, dashboarding **What do you dislike about VMware Greenplum?** There is nothing that I dislike about the product **What problems is VMware Greenplum solving and how is that benefiting you?** We are solving the integration of DLP with Data Privacy. We have got excellent benefits for the data synchronization ### 7. Principal Greenplum DBA **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Industrial Automation | Mid-Market (51-1000 emp.) **Reviewed Date:** June 15, 2021 **What do you like best about VMware Greenplum?** I like how I can improve my performance in big tables using the MPP architecture that Greenplum gives me **What do you dislike about VMware Greenplum?** The daily maintenance is usually a problem, if we have a big table and a lot of users are using this table **What problems is VMware Greenplum solving and how is that benefiting you?** Dataware house logistic. I can have a response in seconds and get TB's of data ### 8. Greenplum is highly scalable and has extensive parallelism Over the segments **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) **Reviewed Date:** June 07, 2021 **What do you like best about VMware Greenplum?** Mirroring concept , expanding the nodes without downtime and performance is high **What do you dislike about VMware Greenplum?** Sometimes GP Optimizer will not work as expected .. **Recommendations to others considering VMware Greenplum:** I'm good using Greenplum **What problems is VMware Greenplum solving and how is that benefiting you?** For the new applications we are above to provide all the support without news issues .. creating different queues .. auto optimizer to choose best path to pull the data ### 9. It was a very great experience using Greenplum **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** June 09, 2021 **What do you like best about VMware Greenplum?** Massive Parallel Processing is the best. **What do you dislike about VMware Greenplum?** Sometimes it goes slow but there's no such problem in that. **What problems is VMware Greenplum solving and how is that benefiting you?** The benefit is that it saves a lot of time to load the data into database. ### 10. GreenPlum - One of the best solutions for data warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** Salil S. | Enterprise (> 1000 emp.) **Reviewed Date:** April 15, 2020 **What do you like best about VMware Greenplum?** 1. The support for Massive parallel processing that GP offers. 2. Faster query executions - We execute many (100s) of queries on a daily basis and at the same time, the results come back in seconds. 3. Resource management 4. GrrenPlum Support - If we face any issues, the support team is there to help us out. 5. SQL like syntax. **What do you dislike about VMware Greenplum?** A few times we have noticed that the segments go down, but they usually come up in seconds. **Recommendations to others considering VMware Greenplum:** 1. If you have a need for storing and retrieving huge datasets then GreenPlum is one of the best choices to make. 2. Queries perform faster when they are optimized. Eg: Use temp tables instead of joining 10 tables in just one single query. **What problems is VMware Greenplum solving and how is that benefiting you?** 1. We use GreenPlum to process our entire clickstream data and are providing intelligent business solutions to 1000s of customers on a daily basis. 2. To analyze data across tables and provide meaningful insights to customers. 3. Processing a huge amount of data in less time. 4. We are trying to process the data in real-time and have tried out various POC'S to help this happen and the results were promising. 5. Easy User management - Creating and providing read/write/admin access to users has been working very smoothly. ### 11. Robust, Reliable and Multiple Parallel Processing database that checks limitation of PostgreSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Nameet N. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 06, 2020 **What do you like best about VMware Greenplum?** Greenplum is fast because of MPP architecture. Segment fail-over and recovery is very good as system automatically fails over to the mirror segment if a primary copy becomes unavailable. Greenplum is reliable. **What do you dislike about VMware Greenplum?** There is no option to create procedures like we have in OracleDB. We do have Functions but procedures would make a lot of requirements easier to achieve. Also, I feel, the querying interface can be much better. **Recommendations to others considering VMware Greenplum:** Greenplum is a perfect database if you are looking for a robust, reliable solution with multiple parallel processing data warehouse / data lake. It will support real time integration with HVR/ golden gate. While visualizing the data, it supported equally good to Tableu/Sisense. **What problems is VMware Greenplum solving and how is that benefiting you?** We had Data Lake created in Greenplum. working as a senior data engineer, we dumped data from various sources viz. oracle, sql server, csv logs to Greenplum DB. It is easily configurable with HVR tool as well. while the data could be used by data engineers for further consumption and creating functions easily, it was equally easy to work with for Data Scientists. ### 12. Great MPP Experience **Rating:** 4.0/5.0 stars **Reviewed by:** Ramakrishna P. | Lead Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 03, 2020 **What do you like best about VMware Greenplum?** - I have been working on Greenplum database from last 3 years. This is the first ever database for me with Massive Parallel Processing architecture to explore, learn and work on. - Compared to my previous experience with other traditional RDBMS, Greenplum's MPP with distribution of data and processing the work load across multiple segments and hosts was quite interesting and was a great learning. - In my opinion, we dont really have to go for Big data technologies like Hadoop to deal with the big data. - Querying the database using postgresql is quite easy to use for users with basic sql knowledge **What do you dislike about VMware Greenplum?** We have faced some issues in the beginning 3 years ago because of the on premise commodity hardware. But it is good to hear that Greenplum can now run on cloud environments as well. **What problems is VMware Greenplum solving and how is that benefiting you?** We have a huge historical transnational data in PB and a daily incoming load from transnational systems in GB. Greenplum's MPP is the right solution for handling such big data for our requirements - The data distribution and parallel processing by several segments made it really easy to get fast results for our queries against database - The concept of Resource Queues was quite useful to allocate the resources to queries based on business requirements ### 13. GP has Artificial Intelligence capability and promising **Rating:** 5.0/5.0 stars **Reviewed by:** Rico R. | Business Intelligence and ETL Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** April 01, 2020 **What do you like best about VMware Greenplum?** Pivotal Greenplum has AI capability and can execute point queries and can handle workloads in day to day Organizations activities aside that it is also scalable. **What do you dislike about VMware Greenplum?** I think there is no dislike it just need the resources or the required architecture for the Pivotal GP to maximize its features and technology. **Recommendations to others considering VMware Greenplum:** If you are looking for Advance analytics, fast queries, AI capable, scalability, deployment to Public or Private Cloud or on premise. This is a great database technology you can have. It has more features than I thought. **What problems is VMware Greenplum solving and how is that benefiting you?** Using REST API and Advance Analytics. MADlib with Greenplum provides multi-node, multi-GPU and deep learning capabilities. It has model versioning for fast automation, also have the capability to push models from training to production thru REST API. Easy deployment or re-coding analytical models. ### 14. Good Relational and multiple parallel processing Database **Rating:** 4.5/5.0 stars **Reviewed by:** Anusha M. | Senior Software Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2020 **What do you like best about VMware Greenplum?** Greenplum is very flexible and fast because of MPP architecture. I have been working in this since 2.5 years and i would love this the most due to its Massive parallel processing Capabilities and vast functionalities. Querying the DB is very easy using Postgresql. Totally it was a great learning experience with pivotal greenplum **What do you dislike about VMware Greenplum?** Some times queries might take longer time to execute and eventually fails with a deadlock. And also it is little expensive than its counterparts. **Recommendations to others considering VMware Greenplum:** Just go for it **What problems is VMware Greenplum solving and how is that benefiting you?** Pivotal greenplum is used to build our business views which acts as a source for the reporting platform. It benifits us to build vast lines of code to serve the customer needs and do a variety of data analytics. ### 15. Recommended **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** April 26, 2020 **What do you like best about VMware Greenplum?** We had a data lake setup in Greenplum for a retail project. The DB is capable of handling millions of data and follows an MPP architecture. The queries can be made using SQL and it supports integrations with API and all. To sum up it has great features. When it comes to performance I feel it lags behind Teradata very slightly. Though it is really good and recommended to those who are looking for a cheaper and efficient DWH. **What do you dislike about VMware Greenplum?** Nothing much in particular. But the customer support and knowledge base could have been better. **Recommendations to others considering VMware Greenplum:** Recommend **What problems is VMware Greenplum solving and how is that benefiting you?** We dealt with integrations of different systems like oracle,Salesforce and bringing everything together to a common data lake for effective decision making ### 16. Greenplum is a highly horizontally scalable and MPP (Massively Parallel Processing) database **Rating:** 4.5/5.0 stars **Reviewed by:** Karunanithi S. | Advisory Solutions Architect, Enterprise (> 1000 emp.) **Reviewed Date:** May 06, 2020 **What do you like best about VMware Greenplum?** MPP enablement and published a patent on improving it's MPP efficiency through Meta Data Query Agent. **What do you dislike about VMware Greenplum?** I would like them to utilize this Metadata query agent using in-memory metadata tables about the segments to be used to run the query. **Recommendations to others considering VMware Greenplum:** It is great to use for Big Data Analytics. **What problems is VMware Greenplum solving and how is that benefiting you?** Big data analytics and it can be leveraged with multiple cloud platforms such Azure/AWS/GCP etc. as a EMR(Elastic Map Reduce) service. ### 17. Greenplum as data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Umesh M. | Software Engineer - II, Enterprise (> 1000 emp.) **Reviewed Date:** April 09, 2020 **What do you like best about VMware Greenplum?** We had historical data from different sources. Wrote spring batch jobs to dumb data in Greenplum. Which is used by data science team analysis and we use same for reporting. **What do you dislike about VMware Greenplum?** pgadmin for Greenplum is very heavy and difficult to use. **Recommendations to others considering VMware Greenplum:** 1) Prefer command line instead of pgadmin tool. 2) Use partitions. 3) Design your schema properly. **What problems is VMware Greenplum solving and how is that benefiting you?** Good for large amount of data. We use it as data warehouse. Out data science team was pretty happy with the way it performed. ### 18. Incredible performance due to MPP Infrastructure **Rating:** 5.0/5.0 stars **Reviewed by:** Dhamotharan K. | Senior Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 22, 2020 **What do you like best about VMware Greenplum?** 1. Amazingly fast due to Multiple parallel processing. 2. Multiple queries can be triggered at a time. The result will be displayed in milli seconds. 3. Queries are almost similar to Oracle. So easy to adopt. 4. Dumping huge files in the database is quick. 5. Customer support is good. **What do you dislike about VMware Greenplum?** I personally feel that the product a bit expensive. **Recommendations to others considering VMware Greenplum:** Highly recommended **What problems is VMware Greenplum solving and how is that benefiting you?** Customer Support have resolved few of our important problems in no time. ### 19. yeah, but am not sure about the current pricing **Rating:** 3.5/5.0 stars **Reviewed by:** Ahmed M. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 29, 2020 **What do you like best about VMware Greenplum?** simple interface, powerful hardware, excel in ETL jobs specially when dealing with huge files **What do you dislike about VMware Greenplum?** hard to maintain and you should pay for maintenance and support **Recommendations to others considering VMware Greenplum:** should look to other alternative available now days, GP is great but its expensive solution so you should have an expensive problem to for such solution **What problems is VMware Greenplum solving and how is that benefiting you?** mainly i used it to create ETL jobs for large scale projects, using GP it was easy to maintain such huge tables while keeping high performance during read and write operations ### 20. A fast and feature-rich PostgreSQL database **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Hardware | Enterprise (> 1000 emp.) **Reviewed Date:** May 02, 2020 **What do you like best about VMware Greenplum?** We use the Pivotal Greenplum database to warehouse website analytics data, in combination with sales and other analytics. It is a massive amount of data, but Pivotal Greenplum handles it with seemingly ease. Moving from an Oracle solution, the amount of time I spend waiting for queries to process is significantly less! **What do you dislike about VMware Greenplum?** Segments do go down every so often, which can be a bit annoying but they come back quickly. **What problems is VMware Greenplum solving and how is that benefiting you?** Pivotal Greenplum has provided an excellent data warehouse for combining a number of separate analytics databases. It helps us perform advanced analysis by quickly retrieving data and allows for more sophisticated queries. ### 21. Great to use GP **Rating:** 5.0/5.0 stars **Reviewed by:** DINESH KUMAR I. | Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** April 16, 2020 **What do you like best about VMware Greenplum?** Data fetch and data handing and there are many best features which we are using in day to day work life and i would like to use it in my current and future projects **What do you dislike about VMware Greenplum?** need more marketing and learning platform **What problems is VMware Greenplum solving and how is that benefiting you?** We are using GreenPlun right now to solve the big data problems where we were not able to use the feature like handling data in datalakes and fetch/filter the data as required. ### 22. It helps me a lot for OLAP transaction in banking industry. **Rating:** 4.0/5.0 stars **Reviewed by:** Vishnu V. | Technical Product Specialist, Enterprise (> 1000 emp.) **Reviewed Date:** March 31, 2020 **What do you like best about VMware Greenplum?** With my experience to greenplum pivotal. It helps a lot to join the required entity for our main table and also helps to quickly extract the necessary information for our enterprise application for OLAP transaction. With pivotal it helps me in joining the different entity to the main clause. **What do you dislike about VMware Greenplum?** Did not felt any issues yet. So no dislikes. **What problems is VMware Greenplum solving and how is that benefiting you?** Before pivotal we were really fed up to make many joining in the tables it causes performance issue during translation loading. ### 23. Great tool , user friendly and great features **Rating:** 5.0/5.0 stars **Reviewed by:** Anshika G. | Technology Solution Manager, Enterprise (> 1000 emp.) **Reviewed Date:** April 21, 2020 **What do you like best about VMware Greenplum?** The tool has great features which are fairly easy to use and learn. Very effective tool **What do you dislike about VMware Greenplum?** Could not see any downsides of using Pivotal Greenplum **Recommendations to others considering VMware Greenplum:** It’s a great tool, definitely start using it in your project **What problems is VMware Greenplum solving and how is that benefiting you?** I use the software for various problem solving in my current project.. ranging from building various graphs to grids to better show case the data ### 24. We use greenplum to store data after ETL processing as target data into multiple dimension tables. **Rating:** 4.0/5.0 stars **Reviewed by:** Diksha G. | System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 22, 2020 **What do you like best about VMware Greenplum?** The tool is user friendly and makes it easier to use. **What do you dislike about VMware Greenplum?** It is little slower than other databases. Takes a little longer time to show results. **Recommendations to others considering VMware Greenplum:** One can use it if dealing with massive amount of data. It is user friendly. **What problems is VMware Greenplum solving and how is that benefiting you?** It can easily deal to massive amount of data. ### 25. New generation databases which introduced/included some of the revolutionary approaches. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** April 20, 2020 **What do you like best about VMware Greenplum?** Performance better than traditional databases. Successfully worked on Virtual Servers. Easy coding of Stored Procedures. Analytical query performance improved with Greenplum. **What do you dislike about VMware Greenplum?** Backup/recovery limitations command center (greenplum's monitoring tool) isn't able to process and display correct information when the server is under high load. Compression is not supported for "normal " tables. Unique index limitations. **What problems is VMware Greenplum solving and how is that benefiting you?** One of our Customer migrated from Oracle to Greenplum. Performance and cost were 2 goals which were achieved. Another customer we used SSRS on Greenplum for some Analytical reporting. Performance was main criteria. ### 26. Having good experience with Greenplum **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Mid-Market (51-1000 emp.) **Reviewed Date:** April 09, 2020 **What do you like best about VMware Greenplum?** I am working as Greenplum admin since 2017, we have migrated from orcle, Postgres. I am having good experience and the utilities are user friendly. If we understand the architecture then you can save lot of time while doing backups and restore. **What do you dislike about VMware Greenplum?** I observed one thing if any bad query comes into database, then database will restart. Pivotal need to work on that and restrict that query upto segment down only. **What problems is VMware Greenplum solving and how is that benefiting you?** Cluster build, database upgrades and downgrades. There is full of automation just we need to know the correct command/utility. ### 27. Simple and effective platform to work with huge data **Rating:** 4.0/5.0 stars **Reviewed by:** Mohan Prasad K. | Java Application Developer, Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2020 **What do you like best about VMware Greenplum?** Connectivity through different technologies **What do you dislike about VMware Greenplum?** Better to have some videos to work with greenplum to be easy for beginners **What problems is VMware Greenplum solving and how is that benefiting you?** I am working with different technologies to store the data into greenplum using one of the database management system. I see the features provided by greenplum is easy to work on that area. ### 28. Greenplum Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** April 03, 2020 **What do you like best about VMware Greenplum?** Performance at scale. Speed. Easy set-up initially. It was a great platform in the beginning of the Big Data movement. **What do you dislike about VMware Greenplum?** Complexity, hard to tune. Need for specialized support people. Not many people are available that are trained in operating the product. Cloud implementation is sub-optimal. Has NOT enhanced the architecture. It has fallen behind other solutions. **Recommendations to others considering VMware Greenplum:** Become better at deploying in the cloud and supporting Cloud-native solutions **What problems is VMware Greenplum solving and how is that benefiting you?** Ability to ingest several different data types from many different sources. Query response times and access to all of our data assets ### 29. Why will i ever need a NoSQL? Probably the best designed database on earth. **Rating:** 5.0/5.0 stars **Reviewed by:** Rajeev C. | Solution Architect/SDE - Microservices, DevOps, Cloud, Edge Computing & Data Engineering, Enterprise (> 1000 emp.) **Reviewed Date:** April 08, 2020 **What do you like best about VMware Greenplum?** All i need a Relational Database that can Horizontally scale and give an ease of use close to an Elasticsearch. **What do you dislike about VMware Greenplum?** Not really a dislike, but would like to see it even more flexible in use, like the way Elasticsearch is. **Recommendations to others considering VMware Greenplum:** OLAP as good as any other **What problems is VMware Greenplum solving and how is that benefiting you?** BI - OLAP ### 30. Good option to be considered for implementing Data Lake **Rating:** 4.0/5.0 stars **Reviewed by:** Abhinav R. | Senior Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2020 **What do you like best about VMware Greenplum?** I feel it provides best and easiest way for bulk load of data. **What do you dislike about VMware Greenplum?** I felt the database availability was a challenge sometimes. **What problems is VMware Greenplum solving and how is that benefiting you?** I have used Pivotal Greenplum in a hybrid data lake. It was easy to implement and large data can be easily loaded in bulk. ### 31. I'm working on greenplum from last 2 years **Rating:** 5.0/5.0 stars **Reviewed by:** Irannagoud P. | Developer A&I, Mid-Market (51-1000 emp.) **Reviewed Date:** April 08, 2020 **What do you like best about VMware Greenplum?** provides performance advantages over HEAP tables Column storage **What do you dislike about VMware Greenplum?** Here we treat function as procedures but compared to other databases, here we get performance issues if we have complex queries. **What problems is VMware Greenplum solving and how is that benefiting you?** As compared to other databases scalability is good with greenplum ### 32. My Experience with GreenPlum **Rating:** 4.5/5.0 stars **Reviewed by:** Dilipan M. | Associate Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** February 28, 2020 **What do you like best about VMware Greenplum?** I like the User friendliness and the performance **What do you dislike about VMware Greenplum?** Nothing as such. However I feel it can be integrated with lot of other SQL clients **Recommendations to others considering VMware Greenplum:** GreenPlum is highly recommended purely for its performance and the ease of use **What problems is VMware Greenplum solving and how is that benefiting you?** All my BI problems are solved on behalf of the customer ### 33. Its open source and fast **Rating:** 5.0/5.0 stars **Reviewed by:** Wajahatullah K. | Lead Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 28, 2020 **What do you like best about VMware Greenplum?** Parallel processing Gpload, gpfdist, functions **What do you dislike about VMware Greenplum?** Need to analyse tables after every interval **Recommendations to others considering VMware Greenplum:** You will love it while working with it. Must have multiple segments to achieve great performance **What problems is VMware Greenplum solving and how is that benefiting you?** Loading big data ### 34. Pivot greenplum is combination of hadoop and structured database. **Rating:** 4.5/5.0 stars **Reviewed by:** Nayan S. | Technical Lead, Enterprise (> 1000 emp.) **Reviewed Date:** February 28, 2020 **What do you like best about VMware Greenplum?** Master slaves architecture of greenplum help to query in optimized way. **What do you dislike about VMware Greenplum?** Admin UI or admin help for it. Load balancing and distribution of data **What problems is VMware Greenplum solving and how is that benefiting you?** With the help of pivot we resolved problem of storing semi structured data and query it efficiently ### 35. Greenplum has been proved pivotal with growing data **Rating:** 4.5/5.0 stars **Reviewed by:** Kumar A. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 29, 2020 **What do you like best about VMware Greenplum?** Easy integration, implementation and weaving additional solutions around it **What do you dislike about VMware Greenplum?** Consolidation of 3rd party integrations. **Recommendations to others considering VMware Greenplum:** Its easy to use and integrate **What problems is VMware Greenplum solving and how is that benefiting you?** Complex data analytics. Its speed and distribution mechanism has helped a lot ### 36. Very powerful tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.) **Reviewed Date:** April 17, 2020 **What do you like best about VMware Greenplum?** Fast, powerful, easy to interrogate, allows multi-cloud deployments **What do you dislike about VMware Greenplum?** The architecture is not simple at first impact, need best Architects **What problems is VMware Greenplum solving and how is that benefiting you?** Postgres has all the indexes and query answering facilities. The possibilities with this tool are great Some colleagues are satisfied because it runs on Linux. ### 37. GreenPlum experience with Reporting Platforms **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** April 21, 2020 **What do you like best about VMware Greenplum?** MPP architecture, with open source technology. **What do you dislike about VMware Greenplum?** Not tightly couples with reporting platform. **Recommendations to others considering VMware Greenplum:** Study the supported platform guide of 3rd party tool, before trying to integrate with Greenplum **What problems is VMware Greenplum solving and how is that benefiting you?** Odbc connectivity do not support all the functionality with Sap business objects, MPP architecture ### 38. One stop solution for OLAP systems **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** April 04, 2020 **What do you like best about VMware Greenplum?** It is highly scalable and runs on both public and ptivate clouds **What do you dislike about VMware Greenplum?** As of now I did find any issues. It would make sense to implement JDBC’s available for different systems or tools **What problems is VMware Greenplum solving and how is that benefiting you?** Scalability issues for OLAP systems which is not addressed in RDBMS ### 39. Great **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Logistics and Supply Chain | Enterprise (> 1000 emp.) **Reviewed Date:** April 23, 2020 **What do you like best about VMware Greenplum?** Reporting is bit easier on large datasets. **What do you dislike about VMware Greenplum?** Retrieving of table with select query is a bit slow **Recommendations to others considering VMware Greenplum:** Use it if you want to build reporting on top of it **What problems is VMware Greenplum solving and how is that benefiting you?** Reporting based on GP tables ### 40. It's powerful feature of supporting multiple native scripting api **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Services | Mid-Market (51-1000 emp.) **Reviewed Date:** April 02, 2020 **What do you like best about VMware Greenplum?** Native scripting Api, and inbuilt array data type **What do you dislike about VMware Greenplum?** Some sql native fiction like unique is bit slow what I observed **Recommendations to others considering VMware Greenplum:** It's the most flexible data base must know tech in data rich domain. **What problems is VMware Greenplum solving and how is that benefiting you?** Used mostly financial data storing, it's data clustering is too good. ### 41. The experience was similar to Oracle/Netezza. I used it as source/target for data migration. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Insurance | Mid-Market (51-1000 emp.) **Reviewed Date:** April 12, 2020 **What do you like best about VMware Greenplum?** It is very affordable for small enterprises. I have seen it being used by one of my clients. They choose it load or unload data using ETL. **What do you dislike about VMware Greenplum?** Not enough online guide for troubleshooting. Need community support. **What problems is VMware Greenplum solving and how is that benefiting you?** Easy to use ### 42. As greenplum developer it's been 3+ years and it's fantastic for massive data **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Mid-Market (51-1000 emp.) **Reviewed Date:** April 03, 2020 **What do you like best about VMware Greenplum?** Best helpful is distributed system. To load huge data it's just simply superb **What do you dislike about VMware Greenplum?** Update statement wil work Hinder the fastness of GP **Recommendations to others considering VMware Greenplum:** Yes. I wil advice others to consider **What problems is VMware Greenplum solving and how is that benefiting you?** Processing high volume finance data ### 43. Bringing Postgres to another level **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** April 16, 2020 **What do you like best about VMware Greenplum?** Ability to scale quickly and deploy to the cloud **What do you dislike about VMware Greenplum?** So far everything seems good and easy to work with **What problems is VMware Greenplum solving and how is that benefiting you?** Efficient data sharding and quick access ### 44. Non Bias T-SQL Developer` **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Banking | Small-Business (50 or fewer emp.) **Reviewed Date:** April 22, 2020 **What do you like best about VMware Greenplum?** The ability to run multiple queries of dateset over millions of records **What do you dislike about VMware Greenplum?** There is only limited support for open source **What problems is VMware Greenplum solving and how is that benefiting you?** Speed ### 45. Consultant for GreenPlum **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 31, 2020 **What do you like best about VMware Greenplum?** Information_Schema --> Metadata maintenance. Partition Exchange. **What do you dislike about VMware Greenplum?** Utilities. Unlike many other MPP , GP has no varieties of utilities for ETL. **What problems is VMware Greenplum solving and how is that benefiting you?** Partition exchange one of good option on Huge data access/retrieval/manipulate ### 46. Greenplum for feature engineering **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** April 12, 2020 **What do you like best about VMware Greenplum?** Greenplum is very powerful for MPP requirement.Especially for analytics need **What do you dislike about VMware Greenplum?** Sometime performance is unpredictable with heavy queries **What problems is VMware Greenplum solving and how is that benefiting you?** Feature engineering,Machine learning ### 47. Pivotal Review **Rating:** 5.0/5.0 stars **Reviewed by:** Wole O. | Team Leader, Non-Profit Organization Management, Small-Business (50 or fewer emp.) **Reviewed Date:** April 21, 2019 **What do you like best about VMware Greenplum?** The fact that you can adapt your tools and methodologies to a cloud scale. Simply stated, to run apps on the cloud securely and reliably without the stress of manual patching. **What do you dislike about VMware Greenplum?** Using the pivotal solution requires whole bunch of learning and knowledge fine-tunning; the materials available to achieve this knowledge is limited, residual knowledge plays a huge role here. So newbies might be totally frustrated. **Recommendations to others considering VMware Greenplum:** Well... we are still implementing though; but i think its headed in the right direction. This is specifically for technocrats interested in automation and tired of manual patching. Ta-da! its for you **What problems is VMware Greenplum solving and how is that benefiting you?** Patching operating system ### 48. PostgreSQL database for analytics **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** June 22, 2019 **What do you like best about VMware Greenplum?** I like how Greenplum is a very stable and efficient analytics database. It can run complex SQL on multiple notes without too much trouble and the database is pretty tunable. **What do you dislike about VMware Greenplum?** I dislike that this database software is somewhat expensive for what it yields. **What problems is VMware Greenplum solving and how is that benefiting you?** I am solving the problem of needing a scalable SQL database to run queries to pull back a variety of data over a large billion row dataset. The benefits I've realized is the streamlining of analytics work. ### 49. Powerful database in BIG DATA Industry **Rating:** 3.5/5.0 stars **Reviewed by:** SUBHA P. | Technical Lead, Enterprise (> 1000 emp.) **Reviewed Date:** April 17, 2019 **What do you like best about VMware Greenplum?** MPP Architecture so that master sends work load to all the segments internally Zero data loss as replication happens between the segments of primary and mirror segments,also a secondary is present for master too Built on PostgreSQL 8.* version Multiple features like gpload,gpdfist used for external data loading gpaddmirrors ,gpexpand helps in scaling the Greenplum cluster easily gpcheckperf helps in analyzing performance of disk I/O,memory bandwidth,Network **What do you dislike about VMware Greenplum?** The catalog corruption occurs and it slightly becomes difficult to recover failed segments gpcheckcat though helps in detecting catalog issues ,it is not much efficient **What problems is VMware Greenplum solving and how is that benefiting you?** OLAP is the best use for Greenplum,it helps in huge data extraction and it is an opensource software too. ### 50. Review of Pivotal Greenplum **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.) **Reviewed Date:** April 17, 2019 **What do you like best about VMware Greenplum?** Coming form an analytic database world, Pivotal Greenplum is an extremely helpful resource. Aside from Pivotal operating as an odd collection of businesses and enterprises, it does the affect the quality of Pivotal Greenplum. I enjoy how Greenplum reached beyond the traditional SQL construct. Also for my company, we are rolling our projects related to machine learning, and Greenplum support ML through another software called Apache MADlib. All this said, Greenplum's unique ability to process complex SQL queries and multi-load capabilities has proven to be more attractive than other competitors. **What do you dislike about VMware Greenplum?** Greenplum competes in the same market as other giant postgresSQL databases such as Teradata and Redshift. Greenplum is probably more expensive than its counterparts, which is a downside of the product. Greenplum does not offer cloud computing, which is a missed opportunity. **What problems is VMware Greenplum solving and how is that benefiting you?** Greenplum offers awesome analytics in various magnitudes of complexity. ## VMware Greenplum Discussions - [Does it have the capability to use Metadata agent Query Management?](https://www.g2.com/discussions/26865-does-it-have-the-capability-to-use-metadata-agent-query-management) - 1 comment - [View VMware Greenplum pricing details and edition comparison](https://www.g2.com/products/vmware-greenplum/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-19+11%3A13%3A08+-0500&secure%5Bsession_id%5D=bce27f27-7533-4b9d-9967-20447f46ba45&secure%5Btoken%5D=019bab0006e2b889ff309cb8c073fa7d2d18d585e40f0d76737723bfdfd2535d&format=llm_user) ## VMware Greenplum Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Deployment** - On-Premise - Cloud **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization ## Top VMware Greenplum Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (687 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (368 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (744 reviews)