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."In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"The initial setup of this solution is straightforward."
"The solution is scalable. It handles different loads very well."
"The processing of data is very fast."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"Redshift Spectrum is the most valuable feature."
"The most valuable feature is its scalability."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"I like the projection feature, which increases query performance."
"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 have found the solution to be scalable."
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"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."
"The product could be improved by making it more flexible."
"It lacks a few features which can be very useful, such as stored procedures"
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"Amazon Redshift could improve the user interface support."
"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."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"The geospatial functionality could be designed better."
"It needs integration with multiple clouds."
"The integration of this solution with ODI could be improved."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"It should provide a GUI interface for data management and tuning."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Limitations in group by projections is where I would like to see an improvement."
"The documentation of Vertica is an area with shortcomings where improvements are required."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Vertica is ranked 6th 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 AWS Lake Formation, Snowflake, Teradata, 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.