IT Central Station is now PeerSpot: Here's why

Vertica Valuable Features

SO
Senior Database Architect at a real estate/law firm with 501-1,000 employees

I think the most valuable thing about the product is the speed and resilience. I would say the strong, well-featured SQL engine with many built-in features — including machine-learning — is also a strong point. 

When testing alternative columnar or in-memory databases the queries their speed may quicker for one or two users, but their concurrency is not as good as Vertica. I would have to say Vertica returns the queries pretty much all the time reliably while other products can sometimes run for 10 minutes and still fail.  

View full review »
JelsonGhigonetto - PeerSpot reviewer
Creator and Manager of Intelligent Water Loss Management Models at Qintess

The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful. 

View full review »
MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees

The data warehouse has exceedingly high performance and has the ability to do large scale queries very effectively. It fits well in large enterprises.

All features are valuable. It's a combination of capabilities that's all in one place, which is incredibly powerful.

For me, it's performance, scalability, low cost, and it's integrated into enterprise and big data environments.

View full review »
Buyer's Guide
Vertica
June 2022
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
609,272 professionals have used our research since 2012.
MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees

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. Vertica handles analytics and large queries extremely well — very high performance —and on top of all of these features, Vertica has a very low total cost ownership.

View full review »
YZ
Sr DBA/ DBA Tech Lead at a non-profit with 1,001-5,000 employees

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.

View full review »
Teddy Elias - PeerSpot reviewer
Senior Manager, Systems and Network Engineering at a computer software company with 11-50 employees

You don't have any more dependency on the local store. In order to build the on-prem process for Vertica, you need to make a lot of changes and be picky about choosing your hardware for it. On Eon, you just put it on S3, so you're not paying a penny for the stores anymore. That's the good thing about Eon. 

View full review »
Santosh Kurakula - PeerSpot reviewer
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa

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.

View full review »
BS
Group Chief Technology Officer at Netcore Solutions

The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good.

View full review »
OJ
Arquitecto Delivery at a tech services company with 501-1,000 employees

It's the fastest database I have ever tested. That's the most important feature of Vertica. It has a lot of contents and machine learning functions. Today we have a lot of options for deploying. It has a lot of integrations.

View full review »
Alberto Guisande - PeerSpot reviewer
Director at Decision Science

Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.

View full review »
MunkhsaikhanBayar - PeerSpot reviewer
Project Lead - Digital Transformation Unit at Bodi Electronics LLC

The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.

View full review »
Buyer's Guide
Vertica
June 2022
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
609,272 professionals have used our research since 2012.