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 ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions."
"It has a variety of options and support systems."
"The initial setup is pretty straightforward."
"The solution is pretty simple to set up."
"In Amazon EMR it is easy to rebuild anything, easy to upgrade and has good fault tolerance."
"The solution is scalable."
"It allows users to access the data through a web interface."
"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 solution has very competitive pricing."
"You can copy JSON to the column and have it analyzed using simple functions."
"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."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"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."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"Modules and strategies should be better handled and notified early in advance."
"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."
"There is room for improvement in pricing."
"There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange."
"There is no need to pay extra for third-party software."
"The initial setup was time-consuming."
"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."
"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."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"Should be made available across zones, like other Multi-AZ solutions."
"The solution is unable to work fast."
"The product must provide new indexes that support special data structures or data types like TEXT."
"The initial deployment was complex."
"I would like to improve the pricing and the simplicity of using this solution."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
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.