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."It allows users to access the data through a web interface."
"The solution is scalable."
"One of the valuable features about this solution is that it's managed services, so it's pretty stable, and scalable as much as you wish. It has all the necessary distributions. With some additional work, it's also possible to change to a Spark version with the latest version of EMR. It also has Hudi, so we are leveraging Apache Hudi on EMR for change data capture, so then it comes out-of-the-box in EMR."
"When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"We are using applications, such as Splunk, Livy, Hadoop, and Spark. We are using all of these applications in Amazon EMR and they're helping us a lot."
"It has a variety of options and support systems."
"The ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions."
"Amazon EMR is a good solution that can be used to manage big data."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"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."
"The legacy versions of the solution are not supported in the new versions."
"The most complicated thing is configuring to the cluster and ensure it's running correctly."
"Amazon EMR is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana."
"The problem for us is it starts very slow."
"There is room for improvement in pricing."
"Amazon EMR can improve by adding some features, such as megastore services and HiveServer2. Additionally, the user interface could be better, similar to what Apache service provides, cross-platform services."
"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."
"Infinite storage is available in Snowflake and is not available in Redshift."
"It takes a lot of time to ingest and update the data."
"Sometimes, it's difficult to get the metadata from Redshift."
"There are too many limitations with respect to concurrency."
"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."
"The explain panel in the Redshift database could be better."
"The product could be improved by making it more flexible."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
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 Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics 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.