HPE Vertica Premium - license - 1 TB capacity

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

Availability: In Stock

Warranties

None

($833.15/month)

Note: Leasing is available to businesses only. Leasing is not available to individuals.

Product Details

License
1 TB capacity
electronic

View Full Product Details

HPE Vertica Premium - license - 1 TB capacity

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.

HPE Vertica Premium - license - 1 TB capacity is rated 3.8 out of 5 by 23.

Rated 4 out of 5 by Joe Gonzalez from The ability to view running queries and cancel problem ones from the Management Console is a very nice feature. Valuable FeaturesI 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.With the Management Console, I am able to easily monitor the system health without having to check individual system tables. The ability to view running queries and cancel problem ones from the Management Console is a very nice feature, and one that I requested when we first started using version 7.0 which had an early version of the Management Console included.Improvements to My OrganizationThe fast columnar store database structure allows our query times to be at least 10x faster than on any other database. This enables us to get answers to data questions as well as numerous analytics on our data out to our internal and external clients quickly. We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently. What was once a two year backlog of report requests on our old data system has been virtually eliminated now that we are using Vertica to provide the solutions.Room for ImprovementMost of the changes I need are in 7.2. We have not yet been able to upgrade to it, but are planning on doing so by the end of the year. Some of the things that are supposed to have been improved/added to Vertica in 7.2 are -* Better support for Live Aggregate Projections, including support for the DISTINCT function* The ability to restore a single object from a full backup instead of having to do an object level backup first* The ability to more easily restore a backup to an alternate cluster* The addition of numerous hints to customize your queries* The ability to enforce check constraints on table load* Major upgrades to the Query OptimizerUse of SolutionI have been using HPE Vertica for about three and a half years now.Deployment IssuesThe installation and deployment was fairly straightforward, and was taken care of by our Linux admins.Stability IssuesOur system is very stable.Scalability IssuesAdding one node was very easy, as was adding memory to all nodes. We are currently in the process of setting up a Dev / DR environment which is going very smoothly.Customer Service and Technical SupportCustomer Service: I have a great relationship with Vertica customer support. They are friendly, knowledgeable, and are quick to respond.Technical Support: HPE Professional Services have also been a huge help to us when needed. They are well worth the investment.Previous SolutionsAt my last company, we initially used Aster Data (now owned by Teradata). Once our database grew too large, it was unable to handle the number of transactions we were completing per day. Many queries on our largest table were taking from 20 minutes to over an hour to complete. Right out of the box, our longest queries went down to under a minute, most completing in a matter of seconds.Initial SetupThe initial setup was straightforward. We used an HPE-affiliated vendor to purchase and properly set up the equipment, completed a POC, and then we had HPE Professional Services assist with the transition from our old system to Vertica.Implementation TeamWe implemented through a vendor. I highly recommend using IIS, they are amazing.Pricing, Setup Cost and LicensingThe pricing, based on raw TB of data stored, is fair and affordable. You can have multiple projections per table without incurring a cost beyond the initial data load. The fact that a Dev and a DR cluster are included in the license cost is a great value!Other Solutions ConsideredWe evaluated Vertica and Greenplum, and chose Vertica due to cost and a number of existing use cases that were nearly identical to ours.Other AdviceMy only advice is to seriously consider using Vertica for your data warehouse needs. I have normally just gone with the flow and learned whatever tools our company chose. When we switched from Aster Data to Vertica, I made the initial recommendation to do so. I am so happy with this product that I am now an HP ASE Certified Vertica Administrator, and moved to a new job that is also using Vertica. I would not have changed jobs if I were not able to continue using this product. I am also recommending to management that we purchase HP IDOL for our upcoming audio and video analytics needs. HP Big Data Solutions is a great product suite, and I have bet my career on its future growth.Disclaimer: I am a real user, and this review is based on my own experience and opinions.

Date published: 2018-01-11

Rated 4 out of 5 by Fahd MirzaChughtai from Its scalability has enabled Pythian's clients to manage data with agility. Valuable Features: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.Improvements to My Organization:Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. It's lower maintenance has also improved the ROI.Room for Improvement:The documentation could be improved with more examples of commands and step-by-step scenarios.Use of Solution:I have used this solution for three years.Stability Issues:There were no stability issues.Scalability Issues:There were no scalability issues.Technical Support:The technical support is good, although it could be improved in terms of the response time and skill-set.Initial Setup:The setup was pretty straightforward as it doesn't take much; if you plan your infrastructure right, then it is a breeze.Cost and Licensing Advice:Read the fine print carefully.Other Advice:First, analyze your business requirements and if the analytics, scalability and lower maintenance are your requirements then, go for HPE Vertica.Disclaimer: I am a real user, and this review is based on my own experience and opinions.

Date published: 2017-07-03

Rated 4 out of 5 by Victor Di Leo from Its column-oriented architecture makes it a database specialized for data warehouses. Valuable Features: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.Improvements to My Organization:It provides very fast results for analysts running reports. These reports are crucial to help our clients strategize their targeted marketing.Room for Improvement:Vertica is relatively new and needs some polish and refinement, but its core functionality is excellent.Documentation overall is fair to good; but lacks continuity or cohesiveness in places.Although its knowledge base is increasing, it is still relatively small, making some issues difficult to diagnose without consulting Vertica Tech Support.Vertica does not have native stored procedures or a native scripting language. Instead, external functions (which can be called from within Vertica) using Java, C++, Linux shell scripting, etc., are supported. This is an unpleasant surprise for many developers, but I feel this has not been a big hindrance in my experience. Complex business logic probably does not belong in a high-performance data warehouse platform. Rather, this should be taken care of during ETL.Use of Solution:I have 3+ years of experience with Vertica.Deployment Issues:Deployment had only a few minor issues that one finds with most software.Stability Issues:It has been very stable.Technical Support:I would give technical support 8 out of 10. They have been responsive, professional and knowledgeable.Previous Solutions:* I have used traditional, row-oriented relational databases like SQL Server, Oracle and PostgreSQL for data warehousing. They are optimized for handling transactions, not data warehousing. Vertica is optimized for data warehousing and that was very clearly demonstrated in its ability to scan large amounts of data at high speed. It is also very fast at loading data.* Vertica uses a distributed, shared-nothing architecture which allows for nodes to be added (or removed) according to need. This is a very scalable architecture which is very difficult to achieve with traditional row-oriented databases.* Compared to Hadoop, Hive, and Spark, Vertica is much more adept at handling concurrent users.Initial Setup:Installation is recommended for someone familiar with Linux (the only OS available for Vertica). For developers with a Linux background, the issues are very manageable. Documentation is good for the installation, so follow it carefully, step-by-step.Implementation Team:Implementation was in-house. No significant issues were encountered.ROI:ROI is good because Vertica, while not cheap, is a better performer than traditional databases.Other Advice:* Understand that its strengths depend on a good data warehouse design using a star schema. It was never intended for high volumes of small, randomly distributed inserts, updates and deletes that are typically found in transactional databases.* It uses column-oriented architecture. It is important to study aspects of this architecture and to implement them and modify them as the database grows in size and more users access the system. This is especially true for projections, run-length encoding, sorting and column ordering. It is important to understand these aspects in order to truly maximize Vertica's performance.Disclaimer: I am a real user, and this review is based on my own experience and opinions.

Date published: 2017-03-03

Rated 4 out of 5 by Jochen Schlosser from Ad-hoc data analysis improved the SLAs for our end clients. Valuable Features:The most valuable feature in the solution is ad hoc data analysis. It improved the SLAs for our end clients.Room for Improvement:There are some predictive analytics features that we might be using which we thought were part of IDOL, but it seems some are also already part of Vertica.Stability Issues:The stability is super good, especially when you scale out.Scalability Issues:Before using Vertica, we used to have problems scaling out because we increase our customer base significantly each year. We have more than 20.000 clients now. Since we implemented the Vertica solution, it is much less effort to maintain scalability.Technical Support:I haven’t used technical support, but the IT colleagues definitely have. I think they are rather happy with it. I haven't heard any complaints. It could be quicker sometimes, but that's always the case with big processes.Previous Solutions:Previously, we were basically using an old school setup based on a relational database. I’m not sure which database management system it was.The performance of the previous solution was no longer adequate to support the growth we were seeing in our business. Response times were up to 10-15 seconds on different queries. We needed to get that down to under a second.Now we’ve moved to a real big data analytics solution.Initial Setup:I wasn’t involved with that, but I think that those who did it were happy with the support.Other Advice:When we chose a solution, we were looking at scalability, maintenance, and ease of use. With Vertica, we can access big data using regular SQL queries.Disclaimer: I am a real user, and this review is based on my own experience and opinions.

Date published: 2017-01-29

Rated 4 out of 5 by DatabaseArch877 from It's pretty straightforward to get the cluster up and running. Valuable Features:* Speed* Parallelization* SQL language* High AvailabilityImprovements to My Organization:I have seen queries that take over 24 hours on MS SQL Server to complete, complete in less than 10 minutes on Vertica. I have seen queries that take several minutes, up to an hour, on MS SQL Server, complete in less than 10 seconds, sometime less than one second on Vertica. That allows analysts to spend their time analyzing results instead of waiting for results. Certain types of analysis weren’t even possible before, simply because it took too long.Room for Improvement:While the documentation is very extensive and relatively complete, it’s poorly organized and there are way too few examples. It’s come a long way since the first version I saw, but it still has a long way to go. Plus, there is very little information on the internet. I can find a solution to nearly any MS SQL Server problem using Google. Not so for Vertica.Use of Solution:I've been using it for five years. I started with version 4, which was prior to the HP acquisition.Deployment Issues:It’s a breeze to setup if you’re using hardware and an OS that meet the minimum requirements. If you try straying from the recommendations, you can find yourself in trouble.Stability Issues:If your queries and projections are optimized properly, it’s rare that you’ll run into stability issues. Stability issues are usually caused by improperly configured hardware/OS, or poorly written queries/projections.Scalability Issues:Scalability is great if you size it correctly to start with. Resizing a cluster isn’t for the faint of heart. All the data needs to be redistributed across the cluster when the cluster size changes, and that can take a very long time, depending on how much data you’re storing.Technical Support:The technical support for Vertica specifically is great. They still have lots of the original (pre-HP acquisition) support people working there who know the product inside and out.Initial Setup:It's pretty straightforward to get the cluster up and running - assuming you follow the vendor recommendations closely. Getting your data in, setting up projections, optimizing queries, etc. is not as straightforward. If you’ve never used it before, save yourself hours of frustration and hire a Vertica consultant.Implementation Team:The first time I used Vertica, we tried doing it ourselves in the beginning. We learned a lot from our failures, but still weren’t getting the results we’d hoped for. After getting professional services help, we were pointed in the right direction, and that made a world of difference. I highly recommend bringing in someone who knows what they’re doing to get you started on the right foot.Cost and Licensing Advice:It’s expensive, but it’s good once you get it working properly. Like any complicated software product, you’re paying for years of research and development, support, etc. Everyone’s use case is different, and sometimes it’s difficult to put a price on speed. You pay for the storage, not the number of processors or nodes. They have a community edition that allows up to three nodes with up to one TB of storage. You can try it out for free that way, and once you realize how well it works, you can purchase a commercial license as your storage footprint grows.Other Solutions Considered:At a previous company, we looked at Greenplum as an alternative to Vertica. For our specific use-case, Vertica won the majority of our benchmark tests. If we had a design that required lots of updates and deletes, we may have compromised and gone with Greenplum.Other Advice:How useful it is depends upon your use case. It’s not a be-all and end-all solution, and it’s great for data that doesn’t change. If you have massive fact and dimension tables, and you need to do analytics on them, this is the Cadillac. If you’re trying to replace your OLTP system, there are better suited solutions out there.These days, there are lots of alternative solutions in the big data space. Open source vs. Commercial. Every imaginable use case. Just like any project, there is the right tool for the job, but you don’t always know what tools are available. You end up using something because it worked before on a different job, or it’s the cheapest solution. Your best bet is always to closely determine your requirements, then find the best match.Disclaimer: I am a real user, and this review is based on my own experience and opinions.

Date published: 2016-11-23

Rated 3 out of 5 by Davide Moraschi from Data Warehouse response times have decreased. It doesn't support stored procedures in the way we are used to thinking of them. Valuable Features:Speed in query in general and specifically in aggregate functions on multi-million rows tables.Improvements to My Organization:Data Warehouse response times have decreased of one order of magnitude with respect to the previous solution (SQL Server + Oracle).Room for Improvement:Sadly, it does not support stored procedures in the way we are used to thinking of them. There is the possibility to code plug-in in C++, but that's out of our reach. Correlated sub-queries are another point where we'd love to see enhancements, plus the overall choice of functions available. ETL with SSIS was not as easy as one we had expected (must remember to COMMIT and we had some issues with datetime + timezone, but that's was probably our fault).OleDB and .NET providers need some touches; and another great improvement would be support for Entity Framework, which so far I haven't seen.There is no serious graphical IDE for HPE Vertica, that's frustrating. One free option available is DbVisualizer for Vertica, but it's a bit basic.Use of Solution:One year.Stability Issues:We have a one node cluster on Red Hat and last week the DB went down. The setting to restart the database is not very intuitive and by default the DB does not restart alone.After a reboot, which may be good in some environments, but leaves you with an insecurity feeling.Scalability Issues:Our DB isin in the tens of Gigs, we did not need to scale yet.Technical Support:N/A, not used.Previous Solutions:We had SQL Server, switched for money reasons and space. But we're not sure yet, SQL Server is way more stable and predictable.Initial Setup:No, the documentation is scarce on non standard setups. We had to create a virtual machine locally, set it up and then upload it to AWS.Cost and Licensing Advice:We use the free community license, plenty of space for our environment. If I had unlimited budget I'd buy a preinstalled instance on EC2, much faster, but costly.Other Solutions Considered:Netezza, but I didn't like it. For no particular reason, but the feeling was not right. Redshift - I was not impressed by the performance. Google Big Query - we tried it.Other Advice:Do COMMIT, and enable/enforce constraints because by default they ARE NOT!!!!Disclaimer: I am a real user, and this review is based on my own experience and opinions.

Date published: 2016-11-08

Rated 4 out of 5 by Rodrick Brown from We built a custom analytical tools on top of Vertica. Valuable Features:* HA Clustering* Speed / PerformanceImprovements to My Organization:We're able to retrieve queries nearly instantaneous for our custom analytical tools we built on top of Vertica.Room for Improvement:More frequent updates.Use of Solution:1 yearStability Issues:None.Scalability Issues:None.Technical Support:Very knowledgable team which has provided excellent documentation for every issue we've had to troubleshoot.Previous Solutions:MonetDB -- unstable, frequent crashes.Initial Setup:Straightforward, was able to get the database up fairly quickly with minimal effort.Cost and Licensing Advice:We're still using the Community Edition (CE).Other Solutions Considered:MonetDB, Cassandra, Amazon RedShift.Other Advice:Great product, very mature and robust. Vertica is able to scale to meet our demands as we scale our business 10x.Disclaimer: I am a real user, and this review is based on my own experience and opinions.

Date published: 2016-11-08

Rated 4 out of 5 by Matt Williams from Columnar storage makes 'hot data' available much faster than a traditional RDBMS solution. Valuable Features:Columnar storage makes 'hot data' available much faster than a traditional RDBMS solution. Also, Vertica scales up quickly and maintains good performance.Improvements to My Organization:Performance management of high-traffic sites - Vertica's ease of scaling has been invaluable for one of our main customers.Room for Improvement:I'm concerned that HP Enterprise has sold their software business, and worry about future investment to enhance predictive/machine-learning capabilities.Use of Solution:3 years.Stability Issues:Not really.... Vertica shines on stability.Scalability Issues:No, scalability is also a strength of the solution.Technical Support:9 out of 10. HPE has some excellent engineers who are eager to help us make Vertica work well.Previous Solutions:I've been a 'full stack' data expert for years, started on Oracle and SQL Server, moved to Hadoop, Mongo, etc, but Vertica was the right fit for large enterprises with high performance demands and ease of scalability.Initial Setup:Initial setup is a bit clunky, like most complex, tunable products can be.Cost and Licensing Advice:Negotiate when their fiscal year is about to close :)Other Advice:It's a solid product that keeps its promises. I do worry about HP Enterprise's sale of Vertica to Micro-FocusRating: 8/10 - it works very well, but some customers worry about 'Vendor lock-in'.Disclaimer: My company has a business relationship with this vendor other than being a customer:We are a Certified Vertica/IDOL (HAVEN) Big Data partner with HP Enterprise.

Date published: 2016-11-06

HPE Vertica Premium - license - 1 TB capacity

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

HPE Vertica Premium - license - 1 TB capacity

Product Overview

Send E-Mail