Vertica Valuable Features

Sima Alexandru - PeerSpot reviewer
Support Specialis at Orion Innovation Romania

The best thing about Vertica is that it is a supportive database performance software. Generally, the tool is used for performance and KPIs.

View full review »
SE
Project Manager at Bank of Africa

The solution is quick, has good compression data, and is not expensive.

Vertica is user-friendly.

View full review »
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 »
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
SR
Pathways Operations Manager at a retailer with 10,001+ employees

I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data. 

This feature enables us to fine-tune our queries by modifying different projections, which is highly beneficial.

View full review »
it_user514728 - PeerSpot reviewer
Senior DBA at a local government with 1,001-5,000 employees
  • Compression / speed with highly complex queries
View full review »
it_user550089 - PeerSpot reviewer
Vertica Support Engineer at a media company with 10,001+ employees

Vertica is an excellent data warehouse platform. Its column-oriented architecture makes it a powerful database specialized for data warehouses. Data should be designed around a star schema.

Data is accessed via SQL, which most developers are already familiar with.

Vertica is "catching on" in the software market, so its user knowledge base is gradually increasing.

The price seems reasonable, the product is reliable, and it uses SQL, so developers don't need to learn a new language.

View full review »
SK
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 »
TE
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 »
it_user453681 - PeerSpot reviewer
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees

I have found great use out of many features, most notably the Management Console and the Database Designer. Many people with lots of experience creating table projections can get frustrated trying to optimize some complex queries, however, in Vertica, the Database Designer is normally a big help in these situations. You can feed it your problem queries and it will make projection design suggestions for you. The ability to have multiple projections on a table to work with different queries is a big bonus.

The Management Console is an invaluable tool for monitoring the health of our Production and DR clusters. Copy Cluster and Cluster Replication help us keep both easily in sync on a daily basis. Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams.  

View full review »
AA
Staff Database Developer at a manufacturing company with 10,001+ employees

The most valuable feature of Vertica is the unmatchable database performance at a fraction of cost compared to other similar databases.

View full review »
MG
Senior Technology Architect at a tech vendor with 10,001+ employees

The most valuable feature is Vertica's performance and the ease of using the database. Also, it is great for partnering with data.

View full review »
it_user886260 - PeerSpot reviewer
Bi Group Manager at Intuit Inc.
  • Its projections and encoding are excellent tools for tuning large volumes.
  • The product is simple and elegant.
  • It has excellent written documentation. I am able to answer any question by querying on Google.
View full review »
it_user428343 - PeerSpot reviewer
Managing Partner at Thorium Data Science

Vertica’s analytic capabilities are its key strength. It can aggregate and analyze data at massive scale and neatly bring the calculation logic to the data with external procedures in C, Java and R.

The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage.

Which brings us to projections and the DB designer which intelligently structures how data is actually stored on disk to improve the queries you actually run against it. So tables are a logical construct which are operated on as per other DBMS systems, but there’s a whole next level of intelligence in optimization for querying that puts Vertica in another league.

View full review »
BD
System Architect at a comms service provider with 10,001+ employees

We're just now getting into Vertica, but it allows us to store and access big data very quickly. It comes down to being able to quickly identify where the root cause analysis is and where trends are, so you can actually try to almost predict where problems are before they really become a problem.

View full review »
AG
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 »
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 »
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 »
it_user464571 - PeerSpot reviewer
Senior Data Warehouse Architect at a media company

Storage abstraction through projections. It gives you the possibility to react to any kind of query with an optimal performance.

The Workload Analyzer helps you easily to analyze your database workloads and recommends tuning opportunities to maximize the database performance. This in turn reduces your operational costs.

I love the hybrid storage model and due to that the full control of load and query behavior. I also like the ability to read semistructured data with FlexTables for DataExploration.

View full review »
PI
Vertica Database Architect at a tech consulting company with 51-200 employees
  • Speed
  • Parallelization
  • SQL language
  • High Availability
View full review »
it_user110262 - PeerSpot reviewer
Architect with 501-1,000 employees

It provides very fast query performance after good designs of projections.

It's easy to implement for 24/7 data load and usage because you don’t have to worry about “load time slots” since you can load data into reporting tables at all times without worrying about their query load.

It just keeps up and running all the time.

View full review »
ERICK RAMIREZ - PeerSpot reviewer
CEO at Imexperts Labs

Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure. Vertica is a column oriented database so the response of queries is very fast. 

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 »
it_user102651 - PeerSpot reviewer
Lead Software Engineer - Theatrical Global at a marketing services firm with 1,001-5,000 employees

Fast query processing for historical data analytics. Write Optimized Store (WOS) continuous data loading without drastically impacting performance of OLAP queries. It's one of the few columnar databases that has the capability to provide near real time data delivery for analytics with minimal delay sourcing data from traditional databases or NoSQL data stores or any unstructured data sources.

View full review »
it_user114084 - PeerSpot reviewer
Co-Founder at a tech services company

The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors.

 I think what also draws me to it is that I don't need any special hardware. So I can use commodity hardware, which is nice to have in a commercial solution.

View full review »
it_user418314 - PeerSpot reviewer
Associate at a tech services company with 501-1,000 employees

The biggest, most valuable feature for us is the clustering aspect with a share-nothing mentality. Most clusters usually require their own shared storage, shared subnet, etc. and this becomes a pain and a nightmare to maintain.

The second most valuable feature is that it's very easy to maintain. It's a breeze once you know how to handle it with your scenario in mind.

View full review »
it_user450444 - PeerSpot reviewer
BI Architect / Software Engineer at a tech services company with 51-200 employees

Speed of query response time for complicated queries on tables with billions of rows including joins on varchar columns. There is no limitation on which columns can be queried or joined on and we see query times in the milliseconds for a lot of queries that just won't return at all from other products.

Ease of administration. The Management Console we thought was a nice to have turns out to give us insight on what is happening behind the scenes so easily it has sped up query tuning, insight as to what jobs are running, and resource use on the boxes the product sits on.

Style of deployment. We were able to build out a server farm exactly as we are accustomed to. We did not have to buy fancy hardware. Our first cluster was deployed on servers we had sitting around from other migrations and replaced products. As we grow also the growth is native to how we do business.

View full review »
Jelson-Ghigonetto - PeerSpot reviewer
Senior Solution Architect at Grupo Cimcorp

I am highly trained on Vertica and I am resistant to using other products because I do not have experience with those products. Some of the most valuable features are cybersecurity and backup.

View full review »
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 »
it_user70134 - PeerSpot reviewer
Senior business Intelligence consultant at Asociación SevillaUP

Speed in query in general and specifically in aggregate functions on multi-million rows tables.

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 »
JG
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 »
it_user528873 - PeerSpot reviewer
Data Scientist at a media company with 501-1,000 employees

The fact that it is a columnar database is valuable. Columnar storage has its own benefit with a large amount of data. It's superior to most traditional relational DB when dealing with a large amount of data. We believe that Vertica is one of the best players in this realm.

View full review »
it_user505299 - PeerSpot reviewer
Management Consultant at a computer software company with 51-200 employees

Scale-out, analytical functions, ML.

View full review »
it_user471384 - PeerSpot reviewer
CIO at a tech services company with 1,001-5,000 employees

We use Vertica as our primary data warehouse. It works well, relatively, most of the time.

View full review »
it_user427470 - PeerSpot reviewer
Technical Team Lead, Business Intelligence at a tech company with 501-1,000 employees

The most valuable feature is the merge function, which is essentially the upsert function. It's become our ELT pattern. Previously, when we used the ETL tool to manage upserts, the load time was significantly longer. The merge function load time is pretty much flat relative to the volume of records processed.

View full review »
it_user515835 - PeerSpot reviewer
Solution Engineering and Arcitect - Big Data, Data Science and Cloud Computing at a tech services company with 1,001-5,000 employees

Speed and performance: Vertica stands top among its peers in the MPP world, delivering unparalleled speed and performance in query response time. Its distributed architecture and use of projection (materialized version of data) beats most of its competitors.

View full review »
it_user417525 - PeerSpot reviewer
Software Engineer at a marketing services firm with 51-200 employees

Having projections as a parallel for indexes in a simple MySQL helped keep our data access fast and optimized.

View full review »
JS
Sr. SW Engineer - Databases with 201-500 employees
  • Clustered database
  • Horizontal scaling
  • Disaster recovery
  • Columnar Storage
  • Compression (you read only columns you need)
  • Immutable storage
  • Fast ingesting
View full review »
it_user431877 - PeerSpot reviewer
Consultant at a tech services company with 10,001+ employees
  • I found the columnar storage, which increases performance of sequential record access, to be the most valuable feature. 
  • I also like the projection feature, which increases query performance.
View full review »
it_user531828 - PeerSpot reviewer
Software and Data Architect at a computer software company with 1,001-5,000 employees

The compute and processing engine returns the queries fast and let us use our analysis resources in a better utilization.

The concurrency got better in this version and we are able to run more queries and load concurrently.

View full review »
it_user505260 - PeerSpot reviewer
Senior Data Architect at a media company with 1,001-5,000 employees

Analytic functions.

View full review »
it_user504552 - PeerSpot reviewer
Sr. Developer, Big Data at a comms service provider with 51-200 employees

Columnar data store

View full review »
BS
Sr. Business Intelligence Analyst / Developer at DXC

This most valuable feature is the database designer, which helps significantly improve our storage footprint.

View full review »
it_user624996 - PeerSpot reviewer
Architect at a comms service provider with 1,001-5,000 employees
  • Quick retrieval of data
  • Fast upload of data
View full review »
it_user158742 - PeerSpot reviewer
Director of Software Development at a tech company with 501-1,000 employees

It has a very good design with high query performance. It provides the scale out capability by adding additional servers instead of scaling up the servers.

View full review »
it_user505416 - PeerSpot reviewer
Database Admin at a tech services company with 1,001-5,000 employees
it_user505263 - PeerSpot reviewer
Principal Data Architect (BI) at a media company with 1,001-5,000 employees

Bulk loading data using copy

Fast analytical functions

Ability to extend functionality

View full review »
it_user505218 - PeerSpot reviewer
Infrastructure, Data Center and PMO Coordinator at a comms service provider with 501-1,000 employees

Manage big data fast and easy.

View full review »
it_user505182 - PeerSpot reviewer
Data Scientist at a tech services company with 501-1,000 employees

Group by performance

Analytic functions

View full review »
Ricardo Díaz - PeerSpot reviewer
COO at a tech services company with 11-50 employees
Easy Installation, Easy to add and quit nodes... View full review »
it_user692295 - PeerSpot reviewer
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees

Two of them:

  • The core feature, meaning their highly efficient columnar file format and execution engine along with a great coverage of ANSI SQL, provides our analysts with a highly expressive and performing platform.
  • The extensibility and efficiency provided by their C++ SDK.
View full review »
it_user567630 - PeerSpot reviewer
Senior Vice President Data at Adform

The most valuable feature in the solution is ad hoc data analysis. It improved the SLAs for our end clients.

View full review »
it_user539511 - PeerSpot reviewer
Database Administrator (DBA) at a computer software company with 501-1,000 employees

The auto-distribution to all nodes for fault tolerance and query performance was pretty amazing.

View full review »
it_user505338 - PeerSpot reviewer
High FrequencyTrading Systems and Strategy Architect/Quant Trader at a financial services firm with 51-200 employees

Fast inserts, queries way faster than in SQL Server.

View full review »
it_user505098 - PeerSpot reviewer
Sr. DevOps Engineer, Adometry at a tech company with 10,001+ employees

Super-fast aggregated results from massive data.

View full review »
it_user505137 - PeerSpot reviewer
Owner at a tech vendor
it_user505101 - PeerSpot reviewer
Senior Database Administrator at a financial services firm with 51-200 employees

Recovery by table

Copy cluster

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 »
it_user539496 - PeerSpot reviewer
Development Operations/SRE at a computer software company with 501-1,000 employees
  • HA Clustering
  • Speed / Performance
View full review »
it_user505863 - PeerSpot reviewer
Vertica DBA at a tech services company with 51-200 employees

Analytical features are amazing, the integration is wonderful.

View full review »
it_user505317 - PeerSpot reviewer
DW Admin at a hospitality company with 1,001-5,000 employees

Scalability, query speed.

View full review »
it_user433491 - PeerSpot reviewer
Cloud Architect, Oracle ACE, Oracle DBA at Pythian

HPE Vertica is a unique solution as it handles a huge magnitude of data with matchless speed and simplicity. One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility.

View full review »
it_user533094 - PeerSpot reviewer
Lead Data Scientist Machine Learning at a financial services firm with 51-200 employees

Columnar storage makes 'hot data' available much faster than a traditional RDBMS solution. Also, Vertica scales up quickly and maintains good performance.

View full review »
it_user4518 - PeerSpot reviewer
Head of Databases at a retailer with 501-1,000 employees
• As it can load a lot of data very quickly, it is very helpful for our organization in managing our VLDB. • It has the lowest cost per TB compared to other DW solutions. • Provides us clustering for our commodity hardware and a good data compression ratio compared to other DW tools I've looked into. • It is very scalable. We didn’t face any problems in terms of installation. • Allows concurrent users access. Our staff can process and send query requests simultaneously -- it responds to all requests very efficiently. • It is very easy to use! It also is good in providing OLAP support to our database system. We can also use traditional SQL queries and tables. View full review »
it_user848262 - PeerSpot reviewer
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees

It maximize cloud economics for mission-critical big data analytical initiatives.

View full review »
it_user504570 - PeerSpot reviewer
CIO with 1,001-5,000 employees
  • Massive data ingestion performance
  • Performance
  • SQL standard query engine
View full review »
it_user464844 - PeerSpot reviewer
Big Data DBA & DevOps at a tech vendor with 51-200 employees

The speed of Vertica out of the box with the ability it has to perform complex analytics queries. In other databases, information will return in hours or even days while in Vertica it will be finished in minutes or even seconds. This is the best feature it has.

View full review »
VV
Assistant Manager at M1 NET

The performance is very good and the aggregate records are fast.

Vertica Auto-Projections reduce the knowledge required by the DBA for tuning performance.

View full review »
it_user703536 - PeerSpot reviewer
Technical Leader / Business Intelligence Consultant with 11-50 employees

Vertica is a columnar database, this support our developments in analytics, advanced analytics, and our ETL process with large sets of data.

View full review »
it_user806967 - PeerSpot reviewer
Architect at OpenSCG
  • The tool for performance tuning and recommendations
  • Any novice user can tune vertical queries with minimal training (or no training at all).
View full review »
it_user663669 - PeerSpot reviewer
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees

Partition and join back to node are easy and simple for DBAs.

DBAs don’t need to add a partition every month/quarter like with other DBs.

View full review »
it_user505371 - PeerSpot reviewer
Sr. Software Engineer (Database) at a tech services company with 1,001-5,000 employees

Query Performance.

View full review »
it_user505386 - PeerSpot reviewer
Senior Database Administrator; HP Vertica, MySQL, MSSQL, Cloud Ops at a tech vendor with 501-1,000 employees

Speed of columnar data.

View full review »
it_user505212 - PeerSpot reviewer
Data Scientist at a tech vendor with 201-500 employees

User Defined Extensions

Analytic Functions

View full review »
it_user411165 - PeerSpot reviewer
Big Data, Analytics and Hadoop Expert, Vertica DBA (Technical Leader), Architecture Group at a tech vendor with 5,001-10,000 employees

Ability to get top performance for in-advance known aggregative SQL queries.

View full review »
it_user467523 - PeerSpot reviewer
BI and Reporting Platform Teams and Tech leader at a computer software company with 1,001-5,000 employees

MPP

Analytical functions

HDFS Copy

Resource management

View full review »
it_user540294 - PeerSpot reviewer
Member of Technical Staff at a tech company with 1,001-5,000 employees

We are evaluating storage and database solutions for an OLAP application with following requirements:

  • Extract, transform and load high velocity and volume of a numerical data stream on a distributed system.
  • Interactive (less than 20 sec latency) query performance for critical group-bys.

Vertica is superior to other solutions in query performance.

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