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."This service can merge and integrate well with all databases."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"The product is relatively easy to use because there is no indexing and no partitions."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"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."
"Redshift Spectrum is the most valuable feature."
"Easy to build out our snowflake design and load data."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"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."
"The extensibility and efficiency provided by their C++ SDK."
"Its projections and encoding are excellent tools for tuning large volumes."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"The performance is very good and the aggregate records are fast."
"The solution is quick, has good compression data, and is not expensive."
"The explain panel in the Redshift database could be better."
"The OLAP slide and dice features need to be improved."
"It would be good to see Redshift as a serverless offering."
"The product could be improved by making it more flexible."
"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."
"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 speed of the solution and its portability needs improvement."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"They could improve on customer service."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"We faced some challenges when trying to use the temporary tables feature."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"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."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
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, Microsoft Azure Synapse Analytics, AWS Lake Formation and Oracle Exadata, whereas Vertica is most compared with Snowflake, SQL Server, Teradata, BigQuery and Oracle Exadata. 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.