We changed our name from IT Central Station: Here's why

Amazon Redshift vs Vertica comparison

Cancel
You must select at least 2 products to compare!
Amazon Redshift Logo
12,282 views|9,547 comparisons
Vertica Logo
9,414 views|6,807 comparisons
Featured Review
Find out what your peers are saying about Amazon Redshift vs. Vertica and other solutions. Updated: January 2022.
563,208 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
"The most valuable feature is the scalability, as it grows according to our needs.""I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.""The initial setup is easy.""It is quite simple to use and there are no issues with creating the tables.""This service can merge and integrate well with all databases.""Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers.""The feature that we find most useful is the ability to do analytics on the fly.""Has a very user-friendly SQL editor and it's very easy to use the connectors."

More Amazon Redshift Pros →

"The performance is very good and the aggregate records are fast.""I have found the solution to be scalable.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.""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.""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.""It has improved my organization's functionality and performance.""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.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."

More Vertica Pros →

Cons
"In our experiments, the handling of unstructured data was not very smooth.""There are too many limitations with respect to concurrency.""Improvement could be made in the area of streaming data.""There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity.""The refreshment rate of data reaching Redshift from other sources should be faster.""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.""The OLAP slide and dice features need to be improved.""The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."

More Amazon Redshift Cons →

"When it is about to reach the maximum storage capacity, it becomes slow.""They could improve on customer service.""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.""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.""Support is an area where it could get better.""I have found that coding support could be simplified.""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."

More Vertica Cons →

Pricing and Cost Advice
  • "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."
  • "The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
  • 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."
  • "The price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    563,208 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
    Top Answer: 
    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.
    Top Answer: 
    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… more »
    Top Answer: 
    The pricing could improve, it is a little expensive.
    Top Answer: 
    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. I know that's… more »
    Ranking
    4th
    Views
    12,282
    Comparisons
    9,547
    Reviews
    12
    Average Words per Review
    509
    Rating
    7.7
    5th
    Views
    9,414
    Comparisons
    6,807
    Reviews
    7
    Average Words per Review
    501
    Rating
    9.4
    Comparisons
    Also Known As
    Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
    Learn More
    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 449
    Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
    Top Industries
    REVIEWERS
    Comms Service Provider29%
    Retailer21%
    Logistics Company14%
    Computer Software Company14%
    VISITORS READING REVIEWS
    Computer Software Company29%
    Comms Service Provider13%
    Media Company10%
    Financial Services Firm8%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company32%
    Comms Service Provider21%
    Financial Services Firm7%
    Media Company4%
    Company Size
    REVIEWERS
    Small Business31%
    Midsize Enterprise36%
    Large Enterprise33%
    REVIEWERS
    Small Business31%
    Midsize Enterprise26%
    Large Enterprise44%
    Find out what your peers are saying about Amazon Redshift vs. Vertica and other solutions. Updated: January 2022.
    563,208 professionals have used our research since 2012.

    Amazon Redshift is ranked 4th in Cloud Data Warehouse with 12 reviews while Vertica is ranked 5th in Cloud Data Warehouse with 10 reviews. Amazon Redshift is rated 7.6, while Vertica is rated 9.4. 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, Microsoft Azure Synapse Analytics, Oracle Exadata, Teradata and Oracle Autonomous Data Warehouse, whereas Vertica is most compared with Snowflake, Teradata, SQL Server, Oracle Exadata and Microsoft Azure Synapse Analytics. 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.