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 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 Review collected by and hosted on G2.com.
Some times queries might take longer time to execute and eventually fails with a deadlock. And also it is little 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 it's 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 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. Review collected by and hosted on G2.com.
I personally feel that the product 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.
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! Review collected by and hosted on G2.com.
Segments do go down every so often, which can be a bit annoying but they come back quickly. Review collected by and hosted on G2.com.