PeerSpot user
Technical Lead with 1,001-5,000 employees
Real User
Needs more stability in terms of query results but we have improved our query response time.

What is most valuable?

External tables to load the data from flat files.

How has it helped my organization?

It helped us in loading millions of data in quick time & improved query response.

What needs improvement?

More stability in terms of query result.

For how long have I used the solution?

Five years - DCA V2.0 EMC & Greenplum Database

Buyer's Guide
VMware Tanzu Greenplum
April 2024
Learn what your peers think about VMware Tanzu Greenplum. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,976 professionals have used our research since 2012.

What was my experience with deployment of the solution?

No.

What do I think about the stability of the solution?

Not usually, but sometimes we do.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and support?

Customer Service:

Excellent.

Technical Support:

Excellent.

Which solution did I use previously and why did I switch?

We applied MPP Appliance for the first time earlier we were running on SMP’s.

How was the initial setup?

It was straightforward.

What about the implementation team?

Vendor- they had good expertise.

What was our ROI?

Good.

Which other solutions did I evaluate?

We also looked at Teradata.

What other advice do I have?

Very good and cost effective with very good customer support.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user372360 - PeerSpot reviewer
Sr. Software Engineer at a financial services firm with 1,001-5,000 employees
Real User
It provides file loaders to reduce dependency on Informatica.

Valuable Features

  • Distributed data for performance
  • File loaders to reduce dependency on Informatica

Improvements to My Organization

Batch processing times have dramatically decreased from over 12 hours to under three hours. Much of this is converting off of Informatica and using distributed processing. Reporting performance also improved greatly.

Room for Improvement

Since we are upgrading to a new version at this time, it’s hard to say. But we seem to be replacing a disk on the appliance every week.

Use of Solution

I've used it for six years.

Deployment Issues

There's no issues, although we are currently in the middle of an upgrade to v4.3.5.

Stability Issues

It seems like we are replacing a disk on the appliance every week. Not a noticeable issue for users and batch processing is not adversely impacted.

Customer Service and Technical Support

Very good. Response times are good for service calls.

Initial Setup

I believe the set-up was straightforward. I don’t remember any issues.

Implementation Team

We used a vendor team. My advice is that the planning is critical. When converting processing jobs, convert them to PostgreSQL for better performance. Yes they could work as written previously, but you benefit using the features of the product immediately if you adjust the processing to match appliance. Use the bulk processing to your advantage.

Other Solutions Considered

We evaluated other solutions. Not sure of the reasons why this product was chosen.

Other Advice

It’s a good product. We moved from Oracle and I don’t want to go back.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
VMware Tanzu Greenplum
April 2024
Learn what your peers think about VMware Tanzu Greenplum. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,976 professionals have used our research since 2012.
it_user372336 - PeerSpot reviewer
Senior Technical Engineer at a tech company with 1,001-5,000 employees
MSP
The loaders – their methods, insert, update and merge – were most valuable.

What is most valuable?

The Greenplum loaders – their methods, insert, update and merge – were most valuable. The external table feature within Greenplum was also very valuable in achieving performance and scalability

How has it helped my organization?

A lot of customers use Greenplum and for their ETL use cases they use Informatica PWX for Greenplum, which helps them achieve transfer of data from a number of data sources into Greenplum. We can help customers to load data effortlessly and quickly.

What needs improvement?

It would be best if Greenplum would support array writes through ODBC drivers . Currently through Data Direct Greenplum drivers we can have single row inserts into Greenplum only. It would help if array loading is supported.

For how long have I used the solution?

I have been using Greenplum loaders to load data into GreenPlum for three years.

What was my experience with deployment of the solution?

There were no issues in deploying it.

What do I think about the stability of the solution?

The external table feature helps to make this a stable solution.

What do I think about the scalability of the solution?

It scales to our and our customers needs as required.

How are customer service and technical support?

The ongoing response from their support on certain technical issues has been slow. It would help if we can have a faster turn-around here.

Which solution did I use previously and why did I switch?

There was no other solution used previously.

How was the initial setup?

The installation and configuration is straightforward.

What about the implementation team?

We implemented through a in-house team . The overall solution will be useful and is not complex

What other advice do I have?

If the use case is going to be requiring a huge data transfer and big data analytics. This is a good product to use.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Site Manager at a tech services company with 51-200 employees
Real User
Helpful for horizontal scaling, but the deployment process can be made easier
Pros and Cons
  • "The most valuable feature for us is horizontal scaling."
  • "I saw some limitation with respect to the column store, and removing this would be an improvement."

What is our primary use case?

The primary use of this solution is for horizontal scalability.

We have an on-premises deployment.

What is most valuable?

The most valuable feature for us is horizontal scaling.

What needs improvement?

The deployment process for this solution could be made easier.

I saw some limitation with respect to the column store, and removing this would be an improvement.

For how long have I used the solution?

We have been using this solution for about two months.

What do I think about the stability of the solution?

This solution is stable enough. 

What do I think about the scalability of the solution?

We are not yet sure about scalability, but we will see in the future.

How are customer service and technical support?

We have not been in touch with technical support for this solution.

Which solution did I use previously and why did I switch?

We were using MySQL prior to this solution.

How was the initial setup?

The initial setup of this solution was not simple, but it was not too complex, either. I would say that it was of medium complexity.

Our deployment took approximately two days, although this was only a partial deployment. We have yet to add another node.

What about the implementation team?

We performed the deployment in-house.

What's my experience with pricing, setup cost, and licensing?

We are using the open-source version of this solution.

Which other solutions did I evaluate?

Prior to choosing this solution, we evaluated MySQL and PostgreSQL.

What other advice do I have?

I would rate this solution a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user776835 - PeerSpot reviewer
Senior Data Warehouse Developer at a comms service provider with 51-200 employees
Vendor
Provides polymorphic storage and very fast query processing
Pros and Cons
  • "Very fast for query processing."
  • "It will be very useful if we could communicate with other database types from Greenplum (using a database link)."

What is our primary use case?

It is a very good appliance for data warehouse (DWH) usage.

What is most valuable?

  • Very fast for query processing
  • Parallel load
  • Polymorphic storage

How has it helped my organization?

Before we had Oracle Exadata, some queries would take more than 20 hours of execution. With Greenplum, it take a few minutes.

What needs improvement?

It will be very useful if we could communicate with other database types from Greenplum (using a database link).

For how long have I used the solution?

Four years.

What do I think about the stability of the solution?

No issues.

What do I think about the scalability of the solution?

No issues.

How are customer service and technical support?

Good. I would give their technical support a seven out of 10.

Which solution did I use previously and why did I switch?

Yes, Oracle Exadata. Performance was the main criteria for switching to Greenplum.

How was the initial setup?

It was a simple setup.

What's my experience with pricing, setup cost, and licensing?

It is the best product with best fit for price/performance customer objectives.

Which other solutions did I evaluate?

We evaluated Oracle technology that we used before.

What other advice do I have?

I encourage other customer to try Greenplum, specifically for DWH use. It is a very useful product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user371766 - PeerSpot reviewer
Sr. Data Operation Engineer at a marketing services firm with 501-1,000 employees
Vendor
MPP architecture is important to process data in such volume.​ Better integration with big data tech stack is needed.

What is most valuable?

MPP (Massive Parallel Processing); processing large amount of data.

How has it helped my organization?

We process billions of rows of data every hour; MPP architecture is important to process data in such volume.

What needs improvement?

  • Better integration with big data tech stack
  • Scalability: for example, system schema (pg_catalog) is one bottleneck for scalability

For how long have I used the solution?

I've used it for four to five years.

What do I think about the scalability of the solution?

The system has some bottleneck, like system schema; some commands (batch loading) is bottlenecked by master DB architecture

How are customer service and technical support?

Customer Service:

It's very poor.

Technical Support:

It's very poor.

Which solution did I use previously and why did I switch?

Used Greenplum originally. We have evaluated other products; the final decision is based on ROI

How was the initial setup?

Products was installed by vendor; all ETL scripts and schema are designed and implemented in-house.

What about the implementation team?

The product was installed by vendor; all ETL scripts and schema are designed and implemented in-house.

What's my experience with pricing, setup cost, and licensing?

Greenplum has an open source version now.

What other advice do I have?

Scalability is one major concern; once data reach certain level; the performance is dropped and much more issues will be triggered, like disk error; out of memory; etc. Be sure that you proper scope your need (including growth) before the decision of system and its size.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1256802 - PeerSpot reviewer
Consultant/Architect with 51-200 employees
Consultant
Feature-rich solution but the setup is complex
Pros and Cons
  • "Pivotal Greenplum's shared-nothing architecture."
  • "Initial setup is a little complex. It took around two weeks to deploy."

What is our primary use case?

Our primary use case is for telecom customers.

What is most valuable?

In terms of most valuable features, I'd say Pivotal Greenplum's shared-nothing architecture.

What needs improvement?

I'd like to see a bridge between Greenplum and Hadoop.

What do I think about the stability of the solution?

We didn't have any issues yet with stability.

What do I think about the scalability of the solution?

In terms of scalability, I just have one master and two segment hosts.

How was the initial setup?

Initial setup is a little complex. It took around two weeks to deploy.

What other advice do I have?

I prefer an open-source solution but Pivotal Greenplum is cheap and has many functionalities.

On a scale of 1 -10 I'd rate it a 6.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Solutions Engineer at VST-ECS Philippines Inc.
Real User
Allows you to benefit from the contributions of a vibrant community of developers
Pros and Cons
  • "It's super easy to deploy and it also supports different languages and analytics."
  • "They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."

What is most valuable?

It's super easy to deploy and it also supports different languages and analytics.

What needs improvement?

As of now, I honestly don't see any room for improvement. I am very happy with this solution, It's helped me a lot.

They should add more analytics. Their documentation could also be improved so that I don't have to bother my coworkers and tech support so often. 

They should advertise more and make it easier for consumers to leave feedback. That way, customers could read the reviews and decide if it's the right solution for them and their needs.

For how long have I used the solution?

I have been using VMware Tanzu Greenplum for roughly one year.

What do I think about the scalability of the solution?

VMware Tanzu Greenplum is both scalable and stable.

How are customer service and technical support?

Their technical support is great.

How was the initial setup?

The initial setup is very easy. Deployment took us roughly one or two days.

What other advice do I have?

I would definitely recommend VMware Tanzu Greenplum. It's open-source and the support is great. It's also relatively cheap compared to similar solutions.

Overall, on a scale from one to ten, I would give this solution a rating of ten — I really like it.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Download our free VMware Tanzu Greenplum Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Data Warehouse
Buyer's Guide
Download our free VMware Tanzu Greenplum Report and get advice and tips from experienced pros sharing their opinions.