VMware Greenplum Reviews & Product Details

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. GreenPlum Support - If we face any issues, the support team is there to help us out.

5. SQL like syntax. Review collected by and hosted on G2.com.

A few times we have noticed that the segments go down, but they usually come up in seconds. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

- 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 Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Greenplum is very flexible and fast because of MPP architecture. I have been working in this since 2.5 years and I love it 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. Review collected by and hosted on G2.com.

Sometimes queries might take longer to execute and eventually fail with a deadlock. It is also a little more expensive than its counterparts. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Nothing much in particular. But the customer support and knowledge base could have been better. Review collected by and hosted on G2.com.

MPP enablement and published a patent on improving its MPP efficiency through Meta Data Query Agent. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

pgadmin for Greenplum is very heavy and difficult to use. Review collected by and hosted on G2.com.

1. Amazingly fast due to Multiple parallel processing.

2. Multiple queries can be triggered at a time. The result will be displayed in milliseconds.

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. Review collected by and hosted on G2.com.

I personally feel that the product is a bit expensive. Review collected by and hosted on G2.com.

simple interface, powerful hardware, excel in ETL jobs specially when dealing with huge files Review collected by and hosted on G2.com.

hard to maintain and you should pay for maintenance and support Review collected by and hosted on G2.com.