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.

To learn more, read our detailed Amazon EMR vs. Amazon Redshift Report (Updated: May 2024).

Buyer's Guide

Amazon EMR vs. Amazon Redshift

May 2024

Download the complete report

Helped 787,061 peers since 2012

Categories and Ranking

Amazon EMR

Ranking in Cloud Data Warehouse

8th

Average Rating

7.8

Number of Reviews

Ranking in other categories

Hadoop (3rd)

Amazon Redshift

Ranking in Cloud Data Warehouse

4th

Average Rating

7.8

Number of Reviews

Ranking in other categories

No ranking in other categories

Market share comparison

As of June 2024, in the Cloud Data Warehouse category, the market share of Amazon EMR is 4.4% and it decreased by 7.3% compared to the previous year. The market share of Amazon Redshift is 6.6% and it decreased by 49.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse

Unique Categories:

Hadoop

14.9%

No other categories found

Featured Reviews

ChetanGoyal

AWS / Big Data Engineer at Waste Management, Inc.

Aug 1, 2023

Suitable for online deployments with a serverless architecture

EMR Serverless is useful for online deployments that require a serverless architecture. We were previously using a server-based architecture, but we have since switched to serverless The product is very well-designed. It is easy to use, and it is very cost-effective. The solution eliminates…

Read full review

FNU AKSHANSH

Senior Data Engineer at a computer software company with 201-500 employees

May 9, 2024

Easy to use, easy to deploy, and the support team is helpful

The solution can be used as a warehouse. We dump any data that exists in our company into it. We spring up different databases based on the requirements The tool is the one place where the company’s data is stored. We use it extensively. Previously, we had data in multiple databases and…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"This is the best tool for hosts and it's really flexible and scalable."

"The solution is pretty simple to set up."

"It has a variety of options and support systems."

"The initial setup is straightforward."

"In Amazon EMR it is easy to rebuild anything, easy to upgrade and has good fault tolerance."

"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."

"It allows users to access the data through a web interface."

More Amazon EMR pros

"The solution has very competitive pricing."

"It allows for the storage of huge amounts of data."

"The initial setup of this solution is straightforward."

"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."

"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."

"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."

"The most valuable feature is the scalability, as it grows according to our needs."

"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."

More Amazon Redshift pros

Cons

"The product must add some of the latest technologies to provide more flexibility to the users."

"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 legacy versions of the solution are not supported in the new versions."

"There is room for improvement in pricing."

"The initial setup was time-consuming."

"There is no need to pay extra for third-party software."

"Modules and strategies should be better handled and notified early in advance."

"Amazon EMR is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana."

More Amazon EMR cons

"The customer support could be more responsive."

"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."

"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."

"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."

"This solution lacks integration with non-AWS sources."

"Infinite storage is available in Snowflake and is not available in Redshift."

"Running parallel queries results in poor performance and this needs to be improved."

"Sometimes, it's difficult to get the metadata from Redshift."

More Amazon Redshift cons

Pricing and Cost Advice

"The cost of Amazon EMR is very high."

"Amazon EMR's price is reasonable."

"You don't need to pay for licensing on a yearly or monthly basis, you only pay for what you use, in terms of underlying instances."

"The price of the solution is expensive."

"There is a small fee for the EMR system, but major cost components are the underlying infrastructure resources which we actually use."

"The product is not cheap, but it is not expensive."

"Amazon EMR is not very expensive."

"There is no need to pay extra for third-party software."

"The product is quite expensive."

"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."

"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."

"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."

"The solution is available at a mid-range price compared to other vendors."

"This solution implements the pay-as-you-use model, so no license. Pricing could be cheaper."

"The part that I like best is that you only pay for what you are using."

"In comparison to the price of similar solutions, Redshift's cost is the lowest."

More Amazon Redshift pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

787,061 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

23%

Computer Software Company

13%

Manufacturing Company

Educational Organization

52%

Financial Services Firm

Computer Software Company

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Amazon EMR?

Amazon EMR is a good solution that can be used to manage big data.

See all answers

What is your experience regarding pricing and costs for Amazon EMR?

Amazon EMR is not very expensive.

See all answers

What needs improvement with Amazon EMR?

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.

See all answers

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?

Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...

See all answers

What do you like most about Amazon Redshift?

The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.

See all answers

What is your experience regarding pricing and costs for Amazon Redshift?

The product is quite expensive.

See all answers

Comparisons

Snowflake vs Amazon EMR

Compared 31% of the time

Cloudera Distribution for Hadoop vs Amazon EMR

Compared 28% of the time

Azure Data Factory vs Amazon EMR

Compared 11% of the time

Apache Spark vs Amazon EMR

Compared 6% of the time

Microsoft Azure Synapse Analytics vs Amazon EMR

Compared 4% of the time

More Amazon EMR Competitors

Teradata vs Amazon Redshift

Compared 11% of the time

Vertica vs Amazon Redshift

Compared 11% of the time

Snowflake vs Amazon Redshift

Compared 10% of the time

Microsoft Azure Synapse Analytics vs Amazon Redshift

Compared 10% of the time

SAP BW4HANA vs Amazon Redshift

Compared 4% of the time

More Amazon Redshift Competitors

Product Reports

Buyer's Guide

Amazon EMR

June 2024

Download Amazon EMR product report

Buyer's Guide

Amazon Redshift

June 2024

Download Amazon Redshift product report

Also Known As

Amazon Elastic MapReduce

No data available

Learn More

Amazon Web Services (AWS)

Overview

Amazon Elastic MapReduce (Amazon EMR) is a web service that makes it easy to quickly and cost-effectively process vast amounts of data. Amazon EMR simplifies big data processing, providing a managed Hadoop framework that makes it easy, fast, and cost-effective for you to distribute and process vast amounts of your data across dynamically scalable Amazon EC2 instances.

What is Amazon Redshift?

Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.

Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of nodes. Once the cluster has been provisioned, users can seamlessly upload data sets, and then begin to perform data analysis queries. Amazon Redshift delivers super-fast query performance, regardless of size, utilizing the exact SQL-based tools and BI applications that most users are already working with today.

The Amazon Redshift service performs all of the work of setting up, operating, and scaling a data warehouse. These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine.

Amazon Redshift Functionalities

Amazon Redshift has many valuable key functionalities. Some of its most useful functionalities include:

Cluster administration: The Amazon Redshift cluster is a group of nodes that contains a leader node and one (or more) compute node(s). The compute nodes needed are dependent on the data size, amount of queries needed, and the query execution functionality desired.
Cluster snapshots: Snapshots are backups of a cluster from an exact point in time. Amazon Redshift offers two types of snapshots: manual and automated. Amazon will store these snapshots internally in the Amazon Simple Storage Service (Amazon S3) utilizing an SSL connection. Whenever a Snapshot restore is needed, Amazon Redshift will create a new cluster and will import data from the snapshot as directed.
Cluster access: Amazon Redshift provides several intuitive features to help define connectivity rules, encrypt data and connections, and control the overall access of your cluster.
IAM credentials and AWS accounts: The Amazon Redshift cluster is only accessible by the AWS account that created the cluster. This automatically secures the cluster and keeps it safe. Inside the AWS account, users access the AWS Identity and IAM protocol to create additional user accounts and manage permissions, granting specified users the desired access needed to control cluster performance.
Encryption: Users have the option to choose to encrypt the clusters for additional added security once the cluster is provisioned. When encryption is enabled, Amazon Redshift will store all the data in user-created tables in a secure encrypted format. To manage Amazon Redshift encryption keys, users will access AWS Key Management Service (AWS KMS).

Reviews from Real Users

“Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there.” - Kundan A., Senior Consultant at Dynamic Elements AS

“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. They have enriched and elaborate documentation that is helpful.”- Aishwarya K., Solution Architect at Capgemini

Sample Customers

Yelp

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

Buyer's Guide

Amazon EMR vs. Amazon Redshift

May 2024

Free Report: Amazon EMR vs. Amazon Redshift

Find out what your peers are saying about Amazon EMR vs. Amazon Redshift and other solutions. Updated: May 2024.

DOWNLOAD NOW

787,061 professionals have used our research since 2012.

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.