HPE Vertica Premium - license

Mfg. Part: H7W34AAE | CDW Part: 3923104 | UNSPSC: 43232314
Request Pricing

Have leasing questions? Let us know how can we help.

Note: Leasing is available to organizations only. Leasing is not available to individuals.
Mon-Fri 7am-7:30pm CT
Ships same day if ordered before 4 PM CT
  • License
  • 1 TB capacity
  • electronic
View More
Product Overview
Main Features
  • License
  • 1 TB capacity
  • electronic
With the ever-growing volume, variety and velocity of data, you can't let analytical query performance get in the way of your most important business decisions. With HP Vertica software you get high-performance data analytics for all of your data to make better business decisions in real time. Packed with powerful features for monetizing all of your data, HP Vertica software manages massive amounts of data quickly and reliably, giving you real-time business intelligence for advanced data analytics.

Technical Specifications
Specifications are provided by the manufacturer. Refer to the manufacturer for an explanation of the print speed and other ratings.
Distribution Media: Electronic
License Category: License
License Qty: 1 TB capacity
License Type: License

Brand: HPE
Compatibility: PC
Manufacturer: HP Software
Model: Premium
Packaged Quantity: 1
Product Line: HPE Vertica

Category: Online & appliance based services
Installation Type: Locally installed
Subcategory: Online & appliance based services - data analysis

Product Reviews
Rated 3.8 out of 5 by 12reviewers.
Rated 4 out of 5 by The architecture means it can process/ingest data in parallel to reporting and analyzing because of in-memory Write-Optimized Storage alongside the analytics optimized Read-Optimized Storage. Valuable Features: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.Improvements to My Organization:Our consultancy has introduced Vertica to a number of clients, from small scale ones who benefit from the free tier and per TB pricing model to have a powerful analytics cluster fairly cheaply to large investment banks who have been able to handle data at a scale that wouldn’t otherwise be possible.Room for Improvement:We’ve built a data ingestion tool to sit alongside Vertica for easy data loading, and I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support, IDE with IntelliSense, and stored procedures which we’ve also had to build a work-around module for.Use of Solution:Personally, I've used it for three to four years (since v6), but a few others in Thorium Data Science have used it for longer.Deployment Issues:We've had no issues. You do need to invest a little time to understand how to set things up and optimize for your workload, but it’s all well documented and there are consultancy firms who will happily help with that.Stability Issues:We've had no issues with the stability.Scalability Issues:We've had no issues scaling it.Technical Support:It's very good. HP have some technically smart guys and are willing to give access to them when you start using Vertica. We’ve had some great support from their engineering team with things like telling us about upcoming features (snapshotting, in this case), which were spot on for a need a client of ours had. We were looking into engineering a solution ourselves and HP happened to have just what we needed coming down the pipeline in the next version.Previous Solutions:We previously used Exadata, which is typically very expensive by comparison. This is because Oracle throw top end hardware at the problem as opposed toHP Vertica’s commodity hardware and smart software approach.Initial Setup:It takes some time to come to grips with the various considerations. I’d suggest bringing in a consultant if you don’t have the time or inclination to do it yourself as it takes going through and install and configuration one or two times to really understand the implications of the different options.Other Advice:The implementation itself is excellent with fantastic features, speed and scalability. They lose a point only for the development experience which relies on third party tooling like squirrel, and not having SQL based stored procedures.Go for it! Try the pre-installed VM which HP offers to have a play with it and get a feel for it. It can certainly scale better than any other RDBMS and pushes the envelope of SQL analysis so you can query/analyze/report “BIG-DATA” without having to resort to the complications associated with Hadoop & unstructured data analysis. If your data is structured and large Vertica is what you need.Disclaimer: My company has a business relationship with this vendor other than being a customer:We are an HP Partner offering consultancy on Vertica (as well as Oracle, SQL Server and other DBs). September 29, 2016
Rated 4 out of 5 by We can quickly identify with the root cause analysis where trends are. Valuable Features: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.Improvements to My Organization:The ability to access in-store, big data, and be able to create keywords for faster resolution and look up an individual, hey we did this problem before. It'll show you all the steps and everything, along with different products. Vertica is pretty much the database behind it. It really does the performance aspect of it.Room for Improvement:I guess really the only thing there is if you get a server big enough to handle Vertica, it does just fine. If you're working in a small business, it will tend to overtake most of their budget from a cost perspective because you need so many servers, so much storage, to be able to handle all that stuff.Stability Issues:It's very stable.Initial Setup:We had no issues deploying it.Other Solutions Considered:I did not really look at any competition. Basically, it's like I said, we're an HP shop and a lot of their applications are going to a Vertica database for its storage and processing of data. We were doing a lot of Oracle, but Oracle was actually moving towards Vertica in our environment.Other Advice:Make sure you understand how much data that you're going to be incorporating into the big data, so you can actually define the amount of storage and redundant storage appropriately.Disclaimer: I am a real user, and this review is based on my own experience and opinions. June 27, 2016
Rated 4 out of 5 by It's fast and built for complex analytics queries with a large amount of data. Valuable Features: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.Improvements to My Organization:Vertica is in our core technology stack. We are serving reports and dashboard to clients from it. It's very important to us that it fulfills its function correctly and provides us with an advantage over our competitors.Room for Improvement:The internal documentation. As a DBA, I really want to understand how its internals works. It needs to handle high concurrency short queries better as Vertica is not handling these well, and we have had to develop our own tool to help us with our dashboard.Use of Solution:I've been using it for five years.Stability Issues:The only thing is that it is very sensitive to network glitches and every time it happens, a node will leave the cluster and we need to re-connect it. Apart from this, the stability is very good.Scalability Issues:It is very easy to scale Vertica as you need.Technical Support:It used to be 10/10 but now it's 8/10. Maybe it's because they were bought by HP which is a big company and the transition is hard.Previous Solutions:The last company I worked for shifted from Oracle to Vertica. For our BI queries it's a huge win. Vertica is much better than any other raw store as it is built exactly for complex analytic queries with a huge amount of data.Initial Setup:The earlier version wasn't that good to deploy, but now it's pretty easy to install. If you follow the documentation, you will be OK.Implementation Team:We implemented it in-house. Since it's different than a raw store database, you need to understand the architecture in order to get the most out of Vertica. This means that you will need to design you data model to suit the Vertica architecture otherwise you will get the same performance as the solution you're replacing, or worse. If your implementation is not complex you can just put it in and you will get out of the box improvements, but for complex ones you need to know how Vertica works and build the right design.Other Advice:It's a great tool but to get the most out of it you will have to design your models to fit it.Disclaimer: I am a real user, and this review is based on my own experience and opinions. June 20, 2016
Rated 4 out of 5 by The Workload Analyzer helps you easily to analyze your database workloads and recommends tuning opportunities to maximize the database performance. Valuable Features: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.Improvements to My Organization:We are now able to procde real-time insights into our tracking data, and with that show how our customers are using the products that we have. Furthermore, it is now possible for our Data Science department to easily, and quickly train their new data mining models and get answers faster than ever before.With the hybrid storage model along with well designed resource pools and storage abstraction through projections, we are now able to easily load new data constantly throughout the whole day. While doing this, we can still be available to perform data analytics on new and legacy data quickly, and even Microstrategy for enterprise reporting doesn’t need to cache data. Most reports can be generated with live queries and still finish within seconds.So in a nutshell:- Faster Information Insight (Data to Insight cycle)- Less complexity on data modeling- Less operational costsRoom for Improvement:I would love to see direct connections to other DMSs. Something like a direct connector to Oracle, MySQL, MS SQL, MongoDB, etc. so that you can copy data between Vertica and other vendors directly and more easily without an ETL tool, dump, transport, or load data.Use of Solution:I've been using Vertica for two and a half years.Scalability Issues:We had an issue caused by adding nodes, but this error was caused by ourselves, as we didn’t use the proper process for adding nodes. That led to some problems that needed to be solved. Even though we did something bad, the instance was still working properly from an outside point of view.Technical Support:We had to contact support for the above mentioned issues with adding nodes, and some other minor questions. All pf our questions were been answered in an appropriate time, and for the complicated problem we needed to solve, we were provided a direct contact and solved this during a conference call with a technician from Boston. So all in all, I would rate the customer service and technical support team from HPE Vertica as one of the best.Initial Setup:The documentation and install procedures cannot be any more straightforward. You get all the information you need from the documentation in a well structured form. We also got support from Vertica for the first setup. They made hardware configuration suggestions and involved us in any details to help us to understand the overall process. During installation, the scripts were check numerous hardware and software settings to help you achieve the best performance for your environment.Implementation Team:We implemented our first cluster in collaboration with the HPE Vertica team. I would always suggest this step, as you will be able to better understand the details about Vertica and how to operate the system efficiently.Cost and Licensing Advice:My advice for pricing/licensing/ROI in a "proprietary proprietary“ comparison. You won’t achieve a better cost effectiveness with a different vendor.Other Solutions Considered:We did a PoC between competitors and Vertica. Throughout the whole PoC, Vertica performed much better in terms of its stability, flexibility, performance and ease of use. We didn’t encounter any problems or downsides, and it didn’t matter what we tested. At that stage, just the Management Console had some minor issues, but even those are now fixed and are not important for the core database engine. I would name HPE Vertica as the most mature columnar database with a best of class data storage and query engine.Other Advice:From the beginning, work closely with HPE Vertica. There's a great Vertica community and a great network to many other companies in the world using this system. Vertica is the most flexible columnar storage with an outstanding performance for any kind of situation.Disclaimer: I am a real user, and this review is based on my own experience and opinions. June 20, 2016
Rated 3 out of 5 by The biggest performance improvements are for queries that have to analyze a large amount of historical data. Valuable Features: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.Improvements to My Organization:With traditional RDBMS historical data analysis or any complex queries took minutes to complete. With the addition of Vertica to handle big data queries, these reports are now returned in under 15 seconds. The biggest performance improvements obviously are for queries that have to analyze a large amount of historical data.Room for Improvement:Stability, scalability (3 node Community Edition) and backup/restore all need to be worked on. Without proper work load management and resource pool allocation, any batch/ETL or streaming jobs which refreshes data frequently will impair OLAP query performance.Use of Solution:We've been using the three node cluster for about one and a half years.Stability Issues:We had several incidents where SQL queries with UDF predicates would shutdown the cluster or sometimes a single node. We worked with HP support to get these things fixed with subsequent versions of Vertica.Scalability Issues:With the Community Edition we are restricted to three nodes. We have a lot of enterprise clients who stress our cluster to its limits. The only advice I would give to new adopters is that if you want superior performance and reliability you are better off going all-in with the enterprise edition and a large number of nodes; assuming you have a lot of clients who run queries concurrently.Initial Setup:Setup and administration are very easy. Vertica was designed to be operational with minimal Database Administrator effort.Other Solutions Considered:We evaluated various other solutions but we chose Vertica because its SQL implementation is very similar to PostgreSQL, and therefore it saved us lot of development time re-writing SQL queries. Vertica seems to be one of the few columnar database which can handle both ETL/Batch jobs and OLAP queries simultaneously. We stream data into Vertica from RDBMS frequently than what is typically recommended for Columnar databases.Disclaimer: I am a real user, and this review is based on my own experience and opinions. June 19, 2016
Rated 5 out of 5 by We thought the Management Console was a nice feature, but it turns out it gives us insight on what is happening behind the scenes. Valuable Features: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.Improvements to My Organization:We can have insight into data we never had before. We can provide that insight to internal users so we do not have to generate reports for them all the time. With response times like these there is no concern of having them wait for results to return and so they do not think things are broken.Room for Improvement:Getting the Management Console up and running as expected was a bit of a challenge.Use of Solution:We've been using it for one and a half years.Stability Issues:We have amazing stability. We even had to migrate the databases to other boxes and found it moved the data without much intervention from us and no down time. It worked exactly as a cluster should. We joke here all the time that we would love to say we like Vertica support but since we never need them, we actually do not know!Scalability Issues:Scalability is one of the huge strengths of this product, and scalable in a way, as I said before, that is native to how we do business.Technical Support:We've never had to contact them.Previous Solutions:We switched off of Infobright because it was not performant at all at the scale we needed. The number of limitations on Infobright are too many to list in a small review like this.Initial Setup:Initial setup of the database was straightforward.Implementation Team:We did need support though for the initial installation. They were incredibly responsive and helpful and deployment was completed in a very reasonable amount of time despite issues initially getting the Management Console up and running.Cost and Licensing Advice:Pricing is more than fair. This is very reasonably priced and since it is a perpetual license you are not stuck paying it again and again.Other Solutions Considered:We evaluated Netezza and Teradata alongside Vertica.Other Advice:Do you want to stand up a data warehouse in a reasonable amount of time using the in-house skills accustomed to dealing with an RDBMS? If that is the case, nothing beats Vertica, hands down.Disclaimer: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. May 25, 2016
Rated 3 out of 5 by The most valuable feature is the merge function, which is essentially the upsert function. We've had issues with query time taking longer than expected for our volume of data. Valuable Features: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.Improvements to My Organization:HP Vertica has helped us democratize data, making it available to users across the organization.Room for Improvement:We've had issues with query time taking longer than expected for our volume of data. However, this is due to not understanding the characteristics of the database and how to better tune its performance.Use of Solution:We've been using HP Vertica for three years, but only in the last year have we really started to leverage it more. We're moving to a clustered environment to support the scale out of our data warehouse.We use it as the database for the our data warehouse. In it's current configuration, we use it as a single node, but we're moving to a clustered environment, which is what the vendor recommends.Deployment Issues:We had no issues with the deployment.Stability Issues:We've had no issues with the stability.Scalability Issues:We've had no issues scaling it.Technical Support:I'd rate technical support as low to average. The tech support provides the usual canned response. We've had to learn most of how to harness the tool on our own.Previous Solutions:I haven't used anything similar.Initial Setup:HP Vertica was in place when I joined the company, but it wasn't used as extensively as it is now.Implementation Team:We implemented it in-house, I believe.Other Advice:Loading into HP Vertica is straightforward, similar to other data warehouse appliance databases such as Netezza. However, tuning it for querying requires a lot more thought. It uses projections that are similar to indexes. Knowing how to properly use projections does take time. One thing to be mindful of with columnar databases is that the fewer the columns in your query, the faster the performance. The number of rows impacts query time less.My advice would be to try out the database connecting to your ETL tools and perform time studies on the load and query times. It's a good database. It works similar to Netezza from my experience but it is a lot cheaper. Pricing is based on the size of the database.Disclaimer: I am a real user, and this review is based on my own experience and opinions. April 19, 2016
Rated 4 out of 5 by I like the clustering aspect with the share-nothing mentality. I also value the ease of maintenance. Valuable Features: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.Improvements to My Organization:Loading raw data and leveraging column store to quickly aggregate the values as well as run a general analysis were the biggest improvements we found. Before, we had to scrub the data or reformat, load it, possibly scrub it some more, and then run the first set of analysis, and so on.With Vertica, we were able to combine some of these steps, such as loading gzip data directly into the table and leveraging R in Vertica to run all of the analysis.Room for Improvement:Developer Tools - Vertica really needs some kind of IDE plugin for a system such as Eclipse or IntelliJ. Developing external functions in Vertica can kind of be like shooting in the dark sometimes. Also, an improved monitor or monitoring with alerting built-in that actually works would be a welcome addition.They truly need a Python or some script that can handle all of the low-level system changes for you and find out how the customer has heavily modified their nodes before the install. Some automation here would help a lot.The product overall is a great product, however management tools as well as monitoring tools are lacking. The product does, however, offer a lot of information in the form of system views and tables, but most of the data is hard to translate with out the help of their support team.Use of Solution:I have used HP Vertica in multiple companies over the last four years. We currently have it running on a three-node Centos cluster and a six-node Centos cluster.Deployment Issues:There have been no issues with the deployment.Stability Issues:There have been no issues with the stability.Scalability Issues:We have had no issues scaling it for our needs.Technical Support:Like everything else HP has support for, the support is very poor. You normally have to threaten to leave, not buy support renewals, or call your sales rep to talkto anyone who knows anything about the product. The community normally knows more than support and most of my questions or issues were resolved by searching the old community boards while I wait for overseas support to ask me to send them the logs again for the 50th time.Previous Solutions:I have previously tried SQL PDW, Mongo, Cassandra for alternatives. Even though all of those products are in different landscapes, the Vertica column store ended up being the best thing that was needed.Initial Setup:It is straightforward if you read the documents and have mid to senior-level knowledge of Linux. Non-Linux admins will find the setup complex and cumbersome since most are Windows admin and they want point-and-click.Implementation Team:We implemented through our in-house team. You need to read the docs, then read them again, and then make yourself a cheat sheet. Once you have done the setup for a two-node cluster, do some Research and Development before taking the time to do a large production cluster or buy the license.ROI:ROI is great compared to the previous solution, SQL Server.Cost and Licensing Advice:TCO is much lower given the Linux OS and the fact that Vertica is licensed by data size and not node count. The best advice for licensing is to make sure you have a proper data retention policy in place and well-documented as well as some growth expectations before buying. Following this, it will make sure you don't over or under buy.Other Advice:If you are not Linux savvy, find a person that is. Make a cheat sheet with the commands and/or steps for your environment. If you are in the cloud, make sure to understand the networking aspect is completely different in AWS from it will be in your local data center. Failure to plan is planning to fail with Vertica implementation, and try not to mess up the spread as it's a pain to fix. If you read the documents, you will see what I am talking about.Disclaimer: I am a real user, and this review is based on my own experience and opinions. April 14, 2016
  • 2016-10-30 T09:23:17.007-05:00
  • bvseo_lps, prod_bvrr, vn_prr_5.6
  • cp-1, bvpage1
  • co_hasreviews, tv_12, tr_12
  • loc_en_US, sid_3923104, prod, sort_default
Adding to Cart...
12/5/2016 11:54:01 PM
^ Back to Top

Maximum 300 characters
An account manager will email you within one business day to confirm your request.

Your Quote has been submitted

What Happens Next? A confirmation email is on its way. Within one business day, you will be contacted by an Account Manager to finalize your quote.


Something went wrong.

Please try again later.

License Selector

    The license selector is not currently available. Please try again later.