Vertica Valuable Features
The best thing about Vertica is that it is a supportive database performance software. Generally, the tool is used for performance and KPIs.
SE
Souhar El Mostafa
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
Sean O'Riordan
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.
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
reviewer2132406
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 »- Compression / speed with highly complex queries
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
Santosh Kurakula
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
Teddy Elias
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 »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.
AA
Amol Adhav
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
reviewer1547958
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 »- 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.
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
PM436379
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
Alberto Guisande
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
Bijal Sanghavi
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
reviewer1605324
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 »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
DatabaseArch877
Vertica Database Architect at a tech consulting company with 51-200 employees
- Speed
- Parallelization
- SQL language
- High Availability
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 »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
reviewer1355733
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 »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 »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.
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 »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 »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
reviewer1355733
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 »Speed in query in general and specifically in aggregate functions on multi-million rows tables.
View full review »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
JelsonGhigonetto
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 »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 »Scale-out, analytical functions, ML.
View full review »We use Vertica as our primary data warehouse. It works well, relatively, most of the time.
View full review »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 »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 »Having projections as a parallel for indexes in a simple MySQL helped keep our data access fast and optimized.
View full review »JS
Jan-Soubusta
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
- 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.
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 »Analytic functions.
View full review »Columnar data store
View full review »BS
Ben Santos
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 »- Quick retrieval of data
- Fast upload of data
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 »Replication
View full review »Bulk loading data using copy
Fast analytical functions
Ability to extend functionality
View full review »Manage big data fast and easy.
View full review »
Easy Installation, Easy to add and quit nodes...
View full review »
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.
The most valuable feature in the solution is ad hoc data analysis. It improved the SLAs for our end clients.
View full review »The auto-distribution to all nodes for fault tolerance and query performance was pretty amazing.
View full review »Fast inserts, queries way faster than in SQL Server.
View full review »Super-fast aggregated results from massive data.
View full review »Geospatial
View full review »OJ
reviewer1754802
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 »- HA Clustering
- Speed / Performance
Analytical features are amazing, the integration is wonderful.
View full review »Scalability, query speed.
View full review »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 »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 »
• 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 maximize cloud economics for mission-critical big data analytical initiatives.
View full review »- Massive data ingestion performance
- Performance
- SQL standard query engine
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
Vironica Vironica
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 »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 »- The tool for performance tuning and recommendations
- Any novice user can tune vertical queries with minimal training (or no training at all).
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 »Query Performance.
View full review »Speed of columnar data.
View full review »Ability to get top performance for in-advance known aggregative SQL queries.
View full review »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.