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 ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions."
"The solution is scalable."
"The initial setup is pretty straightforward."
"This is the best tool for hosts and it's really flexible and scalable."
"The initial setup is straightforward."
"The project management is very streamlined."
"It has a variety of options and support systems."
"In Amazon EMR it is easy to rebuild anything, easy to upgrade and has good fault tolerance."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The feature that we find most useful is the ability to do analytics on the fly."
"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 most valuable feature is that the solution is fully embedded in the AWS stack."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"We have found Machine Learning use cases are very nice."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"The dashboard management could be better. Right now, it's lacking a bit."
"There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange."
"The problem for us is it starts very slow."
"The product's features for storing data in static clusters could be better."
"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 most complicated thing is configuring to the cluster and ensure it's running correctly."
"There is room for improvement in pricing."
"The initial setup was time-consuming."
"There are too many limitations with respect to concurrency."
"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."
"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."
"I would like to improve the pricing and the simplicity of using this solution."
"The OLAP slide and dice features need to be improved."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"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.