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."The processing of data is very fast."
"We have found Machine Learning use cases are very nice."
"It allows for the storage of huge amounts of data."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"This service can merge and integrate well with all databases."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"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."
"The most valuable feature is Vertica's performance and the ease of using the database."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Partition and join back to node are easy and simple for DBAs."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"I have found the solution to be scalable."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"There are too many limitations with respect to concurrency."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"It lacks a few features which can be very useful, such as stored procedures"
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"It takes a lot of time to ingest and update the data."
"Infinite storage is available in Snowflake and is not available in Redshift."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"The integration of this solution with ODI could be improved."
"The geospatial functionality could be designed better."
"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."
"The integration with AI has room for improvement."
"The biggest problem is the cost of cloud deployment."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 57 reviews while Vertica is ranked 6th in Cloud Data Warehouse with 82 reviews. Amazon Redshift is rated 7.8, while Vertica is rated 8.4. 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 AWS Lake Formation, Snowflake, Microsoft Azure Synapse Analytics, Teradata 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.