We performed a comparison between Amazon EMR and Vertica 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 initial setup is pretty straightforward."
"The solution is scalable."
"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."
"Amazon EMR's most valuable features are processing speed and data storage capacity."
"The solution is pretty simple to set up."
"Amazon EMR is a good solution that can be used to manage big 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."
"The extensibility and efficiency provided by their C++ SDK."
"The most valuable feature of Vertica is the unmatchable database performance."
"Eighty percent of the ETL operations have improved since implementing this solution."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The performance is very good and the aggregate records are fast."
"I enjoy the cybersecurity and backup features."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"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."
"The legacy versions of the solution are not supported in the new versions."
"Modules and strategies should be better handled and notified early in advance."
"There is room for improvement in pricing."
"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."
"The problem for us is it starts very slow."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"The integration with AI has room for improvement."
"Suboptimal projection design causes queries to not scale linearly."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"Documentation has become much better, but can always use some improvement."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
Amazon EMR is ranked 8th in Cloud Data Warehouse with 20 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. Amazon EMR is rated 7.8, while Vertica is rated 8.2. The top reviewer of Amazon EMR writes "Provides efficient data processing features and has good scalability ". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Amazon EMR is most compared with Snowflake, Cloudera Distribution for Hadoop, Azure Data Factory, Amazon Redshift and Apache Spark, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our Amazon EMR vs. Vertica 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.