We performed a comparison between Amazon EMR and Amazon Redshift based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"The initial setup is straightforward."
"The solution is pretty simple to set up."
"The solution helps us manage huge volumes of data."
"Amazon EMR's most valuable features are processing speed and data storage capacity."
"The project management is very streamlined."
"Amazon EMR is a good solution that can be used to manage big data."
"The ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions."
"The valuable features are performance, data compression, and scalability."
"The most valuable feature of Redshift is its cluster."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The product is relatively easy to use because there is no indexing and no partitions."
"The most valuable feature is the scalability, as it grows according to our needs."
"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."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"The dashboard management could be better. Right now, it's lacking a bit."
"As people are shifting from legacy solutions to other technologies, Amazon EMR needs to add more features that give more flexibility in managing user data."
"The initial setup was time-consuming."
"The legacy versions of the solution are not supported in the new versions."
"There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange."
"There is room for improvement in pricing."
"The product must add some of the latest technologies to provide more flexibility to the users."
"The product's features for storing data in static clusters could be better."
"I would like to improve the pricing and the simplicity of using this solution."
"The solution is unable to work fast."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"Running parallel queries results in poor performance and this needs to be improved."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"There are too many limitations with respect to concurrency."
"In our experiments, the handling of unstructured data was not very smooth."
Amazon EMR is ranked 8th in Cloud Data Warehouse with 20 reviews while Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews. Amazon EMR is rated 7.8, while Amazon Redshift is rated 7.8. The top reviewer of Amazon EMR writes "Provides efficient data processing features and has good scalability ". On the other hand, 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". Amazon EMR is most compared with Snowflake, Cloudera Distribution for Hadoop, Azure Data Factory, Apache Spark and Microsoft Azure Synapse Analytics, whereas Amazon Redshift is most compared with Snowflake, Teradata, AWS Lake Formation, Vertica and SAP BW4HANA. See our Amazon EMR vs. Amazon Redshift report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.