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."The project management is very streamlined."
"The initial setup is pretty straightforward."
"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."
"When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"The ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions."
"The solution helps us manage huge volumes of data."
"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."
"This is the best tool for hosts and it's really flexible and scalable."
"The most valuable feature of Redshift is its cluster."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"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."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"It is quite simple to use and there are no issues with creating the tables."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"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."
"The initial setup is easy."
"There is room for improvement in pricing."
"Modules and strategies should be better handled and notified early in advance."
"There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange."
"The product must add some of the latest technologies to provide more flexibility to the users."
"The dashboard management could be better. Right now, it's lacking a bit."
"The most complicated thing is configuring to the cluster and ensure it's running correctly."
"We don't have much control. If we have multiple users, if they want to scale up, the cost will go and increase and we don't know how we can restrict that price part."
"The initial setup was time-consuming."
"Improvement could be made in the area of streaming data."
"In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic."
"It takes a lot of time to ingest and update the data."
"The customer support could be more responsive."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"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."
"Running parallel queries results in poor performance and this needs to be improved."
"Amazon Redshift is a little more expensive than other products."
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.