Compare Amazon Redshift vs. Vertica

Cancel
You must select at least 2 products to compare!
Amazon Redshift Logo
13,842 views|9,814 comparisons
Vertica Logo
14,490 views|8,334 comparisons
Most Helpful Review
Find out what your peers are saying about Amazon Redshift vs. Vertica and other solutions. Updated: January 2021.
455,301 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"It allows you write complex queries and perform row by row processes.""It allows for the storage of huge amounts of data.""The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it.""The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing.""The initial setup of this solution is straightforward.""The product is relatively easy to use because there is no indexing and no partitions.""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.""The processing of data is very fast."

More Amazon Redshift Pros »

"Eighty percent of the ETL operations have improved since implementing this solution.""The performance is very good and the aggregate records are fast.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""Allows us to take volumes and process them at a very high speed.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""Speed and resiliency are probably the best parts of this product.""It has improved my organization's functionality and performance.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."

More Vertica Pros »

Cons
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations.""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.""The speed of the solution and its portability needs improvement.""Running parallel queries results in poor performance and this needs to be improved.""The product could be improved by making it more flexible.""Pricing is one of the things that it could improve. It should be more competitive.""It would be useful to have an option where all of the data can be queried at once and then have the result shown.""It takes a lot of time to ingest and update the data."

More Amazon Redshift Cons »

"Fact-to-fact joins on multi-billion record tables perform poorly.""When it is about to reach the maximum storage capacity, it becomes slow.""Support is an area where it could get better.""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.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""The geospatial functionality could be designed better.""We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.""They could improve on customer service."

More Vertica Cons »

Pricing and Cost Advice
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20.""The best part about this solution is the cost.""The part that I like best is that you only pay for what you are using.""My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD.""At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."

More Amazon Redshift Pricing and Cost Advice »

"From a cost perspective, the software is less than most of its competitors.""It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
455,301 professionals have used our research since 2012.
Questions from the Community
Top Answer: The processing of data is very fast.
Top Answer: It would be useful to have an option where all of the data can be queried at once and then have the result shown. As it is now, when we run a query and we are looking at the results, part of the data… more »
Top Answer: We use Amazon S3 along with RedShift for storing our data. The data comes from various sources, including our client and third-parties. We get the data as an S3 file and then load it into RedShift… more »
Top Answer: SQreamDB is a GPU DB. It is not suitable for real-time oltp of course. Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)… more »
Top Answer: The performance is very good and the aggregate records are fast.
Top Answer: When it is about to reach the maximum storage capacity, it becomes slow.
Ranking
3rd
Views
13,842
Comparisons
9,814
Reviews
11
Average Words per Review
483
Rating
7.6
4th
Views
14,490
Comparisons
8,334
Reviews
7
Average Words per Review
478
Rating
9.1
Popular Comparisons
Compared 20% of the time.
Compared 14% of the time.
Compared 12% of the time.
Compared 4% of the time.
Compared 24% of the time.
Compared 10% of the time.
Compared 9% of the time.
Compared 8% of the time.
Compared 6% of the time.
Also Known As
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn
Amazon
Micro Focus
Overview

Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.

Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.

Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.

As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about Amazon Redshift
Learn more about Vertica
Sample Customers
Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
REVIEWERS
Comms Service Provider36%
Logistics Company18%
Manufacturing Company9%
Retailer9%
VISITORS READING REVIEWS
Computer Software Company36%
Media Company15%
Comms Service Provider11%
Financial Services Firm5%
REVIEWERS
Computer Software Company23%
Media Company19%
Marketing Services Firm16%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company35%
Comms Service Provider16%
Financial Services Firm7%
Media Company7%
Company Size
REVIEWERS
Small Business25%
Midsize Enterprise43%
Large Enterprise32%
REVIEWERS
Small Business30%
Midsize Enterprise25%
Large Enterprise45%
Find out what your peers are saying about Amazon Redshift vs. Vertica and other solutions. Updated: January 2021.
455,301 professionals have used our research since 2012.

Amazon Redshift is ranked 3rd in Cloud Data Warehouse with 11 reviews while Vertica is ranked 4th in Cloud Data Warehouse with 7 reviews. Amazon Redshift is rated 7.6, while Vertica is rated 9.0. The top reviewer of Amazon Redshift writes "Scales according to our needs, which saves a lot in terms of upfront costs". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Amazon Redshift is most compared with Snowflake, Oracle Exadata, Teradata, Microsoft Azure Synapse Analytics and SAP BW4HANA, whereas Vertica is most compared with Snowflake, Apache Hadoop, Teradata, SQL Server and Oracle Exadata. See our Amazon Redshift vs. Vertica report.

See our list of best Cloud 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.