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. Review collected by and hosted on G2.com.
Not enough online guide for troubleshooting. Need community support. Review collected by and hosted on G2.com.
Best helpful is distributed system. To load huge data it's just simply superb Review collected by and hosted on G2.com.
Update statement wil work Hinder the fastness of GP Review collected by and hosted on G2.com.
Information_Schema --> Metadata maintenance. Partition Exchange. Review collected by and hosted on G2.com.
Utilities. Unlike many other MPP , GP has no varieties of utilities for ETL. Review collected by and hosted on G2.com.
Greenplum is very powerful for MPP requirement.Especially for analytics need Review collected by and hosted on G2.com.
Sometime performance is unpredictable with heavy queries Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
I dislike that this database software is somewhat expensive for what it yields. Review collected by and hosted on G2.com.
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 Review collected by and hosted on G2.com.
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 Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.