We performed a comparison between Amazon Redshift and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It allows you write complex queries and perform row by row processes."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"The valuable features are performance, data compression, and scalability."
"The stability of Amazon Redshift is good."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."
"A very good, open-source platform."
"The loading speed is very good."
"Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform."
"Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible."
"The most valuable feature for us is horizontal scaling."
"With VMware Tanzu Greenplum, one can make a huge database table and analyze the queries by adding in the SQL command. Some hint or command for the query goes over the multi-parallel execution."
"Helps us to achieve large-scale analytics."
"It's super easy to deploy and it also supports different languages and analytics."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"Infinite storage is available in Snowflake and is not available in Redshift."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"Improvement could be made in the area of streaming data."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"In our experiments, the handling of unstructured data was not very smooth."
"Initial setup is a little complex. It took around two weeks to deploy."
"One of the disadvantages, not a disadvantage with the product itself, but overall, is the expertise in the marketplace. It's not easy to find a Greenplum administrator in the market, compared to other products such as Oracle."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"VMware Tanzu Greenplum needs improvement in the memory area and improved methods for quick access to the disc. So, one of the quick goals of Greenplum must work on enhancing access to the disc by adding hints in the database."
"Tanzu Greenplum's compression for GPText could be made more efficient."
"Extra filters would be helpful."
"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."
"Lacks sufficient inbuilt machine-learning functions for complex use cases."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 36 reviews. Amazon Redshift is rated 7.8, while VMware Tanzu Greenplum is rated 7.8. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of VMware Tanzu Greenplum writes "Very efficient at large scale analytics; lacks inbuilt machine-learning functions for complex use cases". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and IBM Netezza Performance Server, whereas VMware Tanzu Greenplum is most compared with Oracle Exadata, Vertica, Oracle Database Appliance, Apache Hadoop and IBM Netezza Performance Server. See our Amazon Redshift vs. VMware Tanzu Greenplum report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.