Pivotal Greenplum Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Aug 24 2017
We experience performance of approximately 1TB per hour loading data to Greenplum without the use of specialized hardware.
What is most valuable?Of particular value to our environment and applications are the following Greenplum capabilities: * Scalable (Massive) Parallel Processing (MPP) – The ability to bring to bear large amounts of compute against large data sets with Greenplum and the EMC DCA has proven itself to be very effective. *… more»
What needs improvement?We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL. The current version of Greenplum is based on a fork of PostgreSQL v8.2.15. This edition of PostgreSQL was EOL by the PostgreSQL project on Dec 2011. The current version of PostgreSQL… more»
Which solution did I use previously and why did I switch?The purchase of Greenplum was our first interaction with Pivotal. We have been a customer of EMC for a very long time.
What other advice do I have?My primary reason for reducing points on this rating is due to the fact that Greenplum is based on a fork of PostgreSQL v8.2.15 (EOL by the PostgreSQL project on Dec 2011). The current version of PostgreSQL is v9.5. There are a number of current PostgreSQL features of which we would like to take… more»
Apr 17 2017
We were able to analyze and produce output on large volumes of data very quickly which saved us lots of time.
What is most valuable?Greenplum is an MPP architecture database. Data can be distributed across multiple nodes and strong distribution will allow queries to execute on all segments at once, which is very powerful. As long as we have good SQL knowledge, we can start playing in the platform. Greenplum uses Postgres and… more»
How has it helped my organization?Greenplum is a high powered, multi-node database that was chosen for its capacity to ingest and query data at extremely high rates of speed, enabling in Database Analytics and Statistical output on granular levels of data that was otherwise inaccessible before its deployment. We were able to analyze… more»
Which solution did I use previously and why did I switch?We did use other products in the company but it wasn’t an MPP architecture database. Our data was getting bigger so we needed something with MPP architecture to tackle big data challenges so Greenplum was considered. It was a management decision to purchase this product (not sure whether other… more»
What other advice do I have?Greenplum is a MPP (massively parallel processing) database which is extremely fast. If people are dealing with very high volume of data, it is definitely a product to consider seriously
Find out what your peers are saying about Pivotal, Apache, Micro Focus and others in Data Warehouse. Updated: March 2020.
405,659 professionals have used our research since 2012.
Feb 02 2017
What is most valuable?The MPP element is crucial, so far as it allows us to query millions of rows at a time, at speed.
How has it helped my organization?The previous data warehouse was built in Oracle. One of the things which has improved in GreenPlum is that we can query millions of rows at speed, without creating lags. We’ve also built far more views; slowly changing dimensions can… more»
What needs improvement?We found some issues with larger tables that have daily data appended, where after a while this seems to create lag in the query speed. This might just have to do with local knowledge rather than the product itself. We have a table which is… more»
Which solution did I use previously and why did I switch?We used Oracle previously. We based our choice on expertise in our US operation, where we have a GreenPlum expert who provided some amazing use case examples to help us in our selection process.
What other advice do I have?Investigate whether this solution works for you. It is worth creating a rating matrix to compare other similar products, and it is very useful to look deeply at whether the third-generation MPP software might be a good fit.
Nov 29 2016
What is most valuable?I've found that the database warehouse, data compression, and ETL to be the most valuable features for us.
How has it helped my organization?Loading batch data has really improved the efficiency of our organization.
What needs improvement?I'd like so see better scaling, better performance from in-memory databases, and a higher compression rate. We have been facing some performance issue when doing batch loading with optimizer the scaling does works fine. They are working on… more»
Which solution did I use previously and why did I switch?We tried other MPP’s.
What other advice do I have?If you want to implement this product, you would need to scale your product well before trying to implement.
Nov 29 2016
What do you think of Pivotal Greenplum?
What is most valuable?Strong integration with Greenplum Servers.
How has it helped my organization?Loading data to Greenplum server after batch processing.
For how long have I used the solution?6 months
What was my experience with deployment of the solution?Yes, issues with HA and issues in syncing with the Greenplum.
What do I think about the scalability of the solution?You cannot expect a split second response.
How are customer service and technical support?Customer Service: On a scale of 10 I would rate it as 7 Technical Support: On a scale of 10 I would rate it as 8
Which solution did I use previously and why did I switch?This has just been used for POC period not for a regular use.
How was the initial setup?Initial setup works absolutely well.…
Nov 08 2016
What is most valuable?I've found that the data compression and ETL are the most valuable features for us. In 184.108.40.206 Pivotal confirmed that even restoring schema level backup is possible from a DB backup. - restoring schema from a DB level backup has been tested and working fine . ORCA - the Pivotal Optimizer does a good… more»
How has it helped my organization?Loading batch data has really improved the efficiency of our organization. Running Extracts has drastically improved the timings. Being MPP which is a bulk operator - we were able to do 1.5 million calculation in 15 minutes.
What needs improvement?Scaling of the solution needs to be improved. HD connection is available where as, not to any file system. Connecting Greenplum with Gemfire(In-Memory) to load, sync, and reconcile data would be really valuable.
Which solution did I use previously and why did I switch?We were using Sybase and handling massive data, bulk operation was not possible.
Jun 18 2016
What is most valuable?The most valuable feature of Greenplum is the Massively Parallel Processing (MPP).
How has it helped my organization?With this solution, we've reduced load on the OLTP systems.
What needs improvement?The fact GreenPlum is using an older version of Postgres means developers coming from other products will find many missing features in PostgreSQL, features which you would assume are standard. Greenplum is based on Postgres 8.2.15 which was released in 2009. While the SQL syntax and functionality has continued to evolve in other platforms in the ensuing years it appears to have stagnated in… more»
What is Pivotal Greenplum?
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.
Also known asGreenplum
Pivotal Greenplum customers
General Electric, Conversant, China CITIC Bank, Aridhia, Purdue University