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."
"It has a variety of options and support systems."
"The solution is pretty simple to set up."
"It allows users to access the data through a web interface."
"The project management is very streamlined."
"This is the best tool for hosts and it's really flexible and scalable."
"The initial setup is straightforward."
"In Amazon EMR it is easy to rebuild anything, easy to upgrade and has good fault tolerance."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"It is quite simple to use and there are no issues with creating the tables."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"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."
"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 most complicated thing is configuring to the cluster and ensure it's running correctly."
"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."
"The legacy versions of the solution are not supported in the new versions."
"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."
"There is room for improvement in pricing."
"In our experiments, the handling of unstructured data was not very smooth."
"The explain panel in the Redshift database could be better."
"The product must become a bit more serverless."
"It would be good to see Redshift as a serverless offering."
"Pricing is one of the things that it could improve. It should be more competitive."
"The initial deployment was complex."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
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, Snowflake, AWS Lake Formation, Vertica 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.