We performed a comparison between Amazon Redshift 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."Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"It's scalable because it's on the cloud."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"It allows for the storage of huge amounts of data."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"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."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"The performance is very good and the aggregate records are fast."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Planting is the primary key enforcement that should be improved."
"It would be good to see Redshift as a serverless offering."
"It lacks a few features which can be very useful, such as stored procedures"
"Amazon Redshift is a little more expensive than other products."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"In our experiments, the handling of unstructured data was not very smooth."
"In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"It needs integration with multiple clouds."
"The integration of this solution with ODI could be improved."
"The documentation of Vertica is an area with shortcomings where improvements are required."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. Amazon Redshift is rated 7.8, while Vertica is rated 8.2. 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". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Amazon Redshift is most compared with Teradata, Snowflake, AWS Lake Formation, Microsoft Azure Synapse Analytics and Oracle Exadata, whereas Vertica is most compared with Snowflake, SQL Server, Teradata, Oracle Exadata and BigQuery. See our Amazon Redshift vs. Vertica report.
See our list of best Cloud Data Warehouse vendors and best 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.
I am assuming you are asking me a question. I have similar points like the one you sent in the link. However, I will narrow it down further with
highlighted ones that matter.
Redshift is cloud-native so not a good idea if you also need a data center. It does not support document store, so that's another limitation.
Vertica works for the hybrid environment and also supports more APIs and supports all familiar languages.
Look at more features as given in the below table and decide. I would go with Vertica if there is a hybrid cloud, needs document store, secondary indexes are a critical need and need support for more APIs (as given in the table). For AWS native environment, go with RedShift.
Amazon Redshift X:
Description: Large scale data warehouse service for use with business intelligence tools.
Primary database model: Relational DBMS
Secondary database models: Key-value store
Website: aws.amazon.com/redshift
Technical documentation: docs.aws.amazon.com/redshift
Developer: Amazon (based on PostgreSQL)
License: commercial
Cloud-based only: Yes
XML Support: No
Secondary indexes: Restricted
SQL: Yes
APIs and other access methods: JDBC, ODBC
Supported programming languages: All languages supporting JDBC/ODBC
Server-side scripts: User-defined functions
Triggers: No
Vertica X:
Description: Columnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance.
Primary database model: Relational DBMS
Secondary database models: Key-value store, Document store
Website: www.vertica.com
Technical documentation: www.vertica.com/documentation/vertica
Developer: Vertica / Micro Focus
License: Commercial
Cloud-based only: No
XML Support: Yes
Secondary indexes: No
SQL: Yes
APIs and other access methods: Kafka, Proprietary protocol, RESTful HTTP API, ADO.NET, JDBC, ODBC
Supported programming languages: C++, Java, Perl, Python, R
Server-side scripts: Yes
Triggers: No
* Flexibility of deployment: Amazon Redshift can only be deployed on the AWS. Redshift lacks support for the hybrid cloud-and-on premises data warehousing combinations. Vertica’s industry-leading deployment options allow customers to run Vertica on AWS, Azure, Google Cloud Platform, on-premise, and on Hadoop.
* Speed: The query execution performance of Vertica and Redshift and some of the differentiators in the two products with Vertica query response times on the 5 TB dataset, 20 concurrent user test, for example, were 3.4 times faster. Also, when over 100 users are simultaneously running queries on the same data, Amazon Redshift’s performance degrades considerably, leading to hours or even days of query response times.
Which of these two solutions would you recommend to a colleague evaluating cloud data warehouses and why? Vertica. As Vertica has flexibility as your data warehouse evolves long term with best in class speed.