Vertica Overview

Vertica is the #4 ranked solution in our list of top Data Warehouse tools. It is most often compared to Snowflake: Vertica vs Snowflake

What is Vertica?

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.

Vertica is also known as Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand.

Vertica Buyer's Guide

Download the Vertica Buyer's Guide including reviews and more. Updated: July 2021

Vertica Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.

Vertica Video

Pricing Advice

What users are saying about Vertica pricing:
  • "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."
  • "From a cost perspective, the software is less than most of its competitors."
  • "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 price could be cheaper and it is best to negotiate the price."

Filter Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
SO
Senior Database Architect at a real estate/law firm with 501-1,000 employees
Real User
Top 20
Superior performance in speed and resilience makes this a very good warehousing solution

What is our primary use case?

We are very happy to have a good warehouse solution that we can run on-premises. Next year we will start testing it on the cloud so we can progress to a hybrid solution. We would like to have Vertica in the cloud integrating with our data lake. We could go with another cloud solution but Vertica has been a good solution for us so far and we hope the cloud product is as good and flexible. On-premises, Vertica would still be used as our data warehouse solution. That would keep us where we know that the cost for the hardware is relatively reasonable where we have customers running large number of… more »

Pros and Cons

  • "Speed and resiliency are probably the best parts of this product."
  • "The geospatial functionality could be designed better."

What other advice do I have?

Advice that I would give others who are considering this solution is what I always say for all products: you should heavily test your use cases and data with the product. There are different versions of software and there are always new software solutions. You always should do an exhaustive performance testing from the point of view of any database product. Better to let the product speak for itself. Test several vendor's products if possible. To be honest, it is hard to see too many issues with Vertica as a solution. I find a few weaknesses in it, but I think that is the same with all…
JelsonGhigonetto
Creator and Manager of Intelligent Water Loss Management Models at Qintess
Real User
Top 10
Enhanced capabilities, good customer service, large data scalability and stable

What is our primary use case?

The solution is a BI solution that includes machine learning. Our company is involved in the distribution of water and we use it to capturing data for several points and to discover where there might have been a loss of drinkable water. There is a problem with the water distribution because the company that I'm working for has an index of 32% of water loss during the process of the distribution. These losses can be from a different source. It can be from leakage, it can be an error or on the meter read which can have many issues, sometimes the problem occurs in different hours depending on the… more »

Pros and Cons

  • "The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
  • "They could improve on customer service."

What other advice do I have?

This solution is used by several big companies such as Bank of America, Uber, and Facebook. Where you need a BI with intelligence. We use the solution because it is very good, you can make interconnections with anything to collect the data, any type of data. I have tried other products and they did not fit as well as this one did, I recommend Vertica. I rate Vertica a nine out of ten.
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
521,817 professionals have used our research since 2012.
Mike Walker
Director - Big Data, IoT and Analytics at Benchmark Corp
Reseller
Top 5
Low cost, high performance with large scale queries, and integrates well in an enterprise setting

What is our primary use case?

We are resellers and we provide products for our customers. Our clients are using this solution in two ways; one is for a data warehouse, and the second is for analytics in the database.

Pros and Cons

  • "For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
  • "Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."

What other advice do I have?

The customers love them. They absolutely love them. Before implementing this solution, make sure that it is on the list and that you evaluate it. I would rate Vertica a ten out of ten.
YZ
Sr DBA/ DBA Tech Lead at a non-profit with 1,001-5,000 employees
Real User
A scalable unified analytics platform with good performance

What is our primary use case?

Our use case is a typical data warehouse. We just use the data warehouse for reporting and the storage of data. Our users are the staff team who do the reporting and data analysis.

Pros and Cons

  • "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."
  • "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."

What other advice do I have?

We tried to use data lake kind of stuff for machine learning, but for the key functionality of the data warehouse, it's great. Personally, I feel they are over-marketing the machine learning feature and for something like the semi-structured data. But for the data warehouse, it's truly a good solution. I want to recommend it highly. I would tell potential users that it's hard to make it slow for small data volumes. For large volumes, it's hard to make it work, make it faster, and make it scale. Depending on your workload and your use case, you need to first purchase the Red Tool. After that…
Teddy Elias
Senior Manager, Systems and Network Engineering at a computer software company with 11-50 employees
Real User
Top 20
Improved my organization's functionality and performance

Pros and Cons

  • "It has improved my organization's functionality and performance."
  • "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."

What other advice do I have?

My advice to someone considering Vertica is to go for it. Nothing is missing. I would rate it a ten out of ten. The only issues are support and the price.
Alberto Guisande
Director at Decision Science
Real User
Top 5Leaderboard
Allows us to take volumes and process them at a very high speed

What is our primary use case?

Primary use case is advanced analytics over huge amounts of data. Vertica provides high speed access to high volumes.

Pros and Cons

  • "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."
  • "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."

What other advice do I have?

Do a good volumetric analysis to manage the storage needed.
Jo Chaiyut
Manager at Bizinfo Thailand
Reseller
Top 10
Scalable, reliable, and good support

What is our primary use case?

We are using Vertica in our warehouse.

What needs improvement?

I have found that coding support could be simplified.

For how long have I used the solution?

I have been using this solution for approximately five years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

I have found the solution to be scalable.

How are customer service and technical support?

I have used the local support and I prefer them.

What's my experience with pricing, setup cost, and licensing?

The price could be cheaper and it is best to negotiate the price.

What other advice do I have?

I rate Vertica an eight out of ten.

Which deployment model are you using for this solution?

VV
Assistant Manager at M1 NET
Real User
Auto-projections make it easy to tune performance

What is our primary use case?

The primary use of Vertica is as a data warehouse to perform aggregate and summary reports.

How has it helped my organization?

This solution has allowed us to reduce the creation of summarized tables, as the user can perform queries on the fly. It has provided for the faster retrieval of records.

What is most valuable?

The performance is very good and the aggregate records are fast. Vertica Auto-Projections reduce the knowledge required by the DBA for tuning performance.

What needs improvement?

When it is about to reach the maximum storage capacity, it becomes slow.
Buyer's Guide
Download our free Vertica Report and get advice and tips from experienced pros sharing their opinions.