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 main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"It allows for the storage of huge amounts of data."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"The processing of data is very fast."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"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."
"The product's initial setup phase is extremely simple."
"Speed and resiliency are probably the best parts of this product."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"The solution is quick, has good compression data, and is not expensive."
"Improvement could be made in the area of streaming data."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"Should be made available across zones, like other Multi-AZ solutions."
"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."
"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."
"Very bad support, I would rate it two out of 10."
"Documentation has become much better, but can always use some improvement."
"The geospatial functionality could be designed better."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"I believe the installation process could be streamlined."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 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 Snowflake, Teradata, 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.