GreenPlum - One of the best solutions for data warehousing
What do you like best?
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. GrrenPlum Support - If we face any issues, the support team is there to help us out.
5. SQL like syntax.
What do you dislike?
A few times we have noticed that the segments go down, but they usually come up in seconds.
Recommendations to others considering the product:
1. If you have a need for storing and retrieving huge datasets then GreenPlum is one of the best choices to make.
2. Queries perform faster when they are optimized. Eg: Use temp tables instead of joining 10 tables in just one single query.
What problems are you solving with the product? What benefits have you realized?
1. We use GreenPlum to process our entire clickstream data and are providing intelligent business solutions to 1000s of customers on a daily basis.
2. To analyze data across tables and provide meaningful insights to customers.
3. Processing a huge amount of data in less time.
4. We are trying to process the data in real-time and have tried out various POC'S to help this happen and the results were promising.
5. Easy User management - Creating and providing read/write/admin access to users has been working very smoothly.
