Vertica Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Apr 24 2018
What is most valuable?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… more»
How has it helped my organization?Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI.
What needs improvement?The documentation could be improved with more examples of commands and step-by-step scenarios.
What's my experience with pricing, setup cost, and licensing?Read the fine print carefully.
Which solution did I use previously and why did I switch?NA
What other advice do I have?First, analyze your business requirements and if the analytics, scalability, and lower maintenance are your requirements then go for HPE Vertica.
Jul 20 2017
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.
What is most valuable?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… more»
How has it helped 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… more»
What needs 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… more»
Which solution did I use previously and why did I switch?We previously used Exadata, which is typically very expensive by comparison. This is because Oracle throw top end hardware at the problem as opposed to HP Vertica’s commodity hardware and smart software approach.
What other advice do I have?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… more»
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse. Updated: May 2020.
418,350 professionals have used our research since 2012.
Jan 22 2017
What is most valuable?The most valuable feature in the solution is ad hoc data analysis. It improved the SLAs for our end clients.
What needs 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.
Which solution did I use previously and why did I switch?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… more»
What other advice do I have?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.
Sep 14 2016
I like the clustering aspect with the share-nothing mentality. I also value the ease of maintenance.
What is most valuable?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… more»
How has it helped 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… more»
What needs 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… more»
What's my experience with pricing, setup cost, and licensing?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… more»
Which solution did I use previously and why did I switch?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… more»
What other advice do I have?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… more»
Sep 04 2016
What is most valuable?Fast inserts, queries way faster than in SQL Server.
How has it helped my organization?Certain research which was unattainable beforehand, now is in reach.
What needs improvement?Some GUI Tools out of the box, better python integration. I would love to see some nice query engine, tooled specifically to Vertica extensions of SQL (with IntelliSense). We currently use TOAD, but it has a lot of bugs and does not provide… more»
What's my experience with pricing, setup cost, and licensing?Switch to per node from per TB.
Which solution did I use previously and why did I switch?It complements our SQL Server solution.
Sep 03 2016
A SQL-based compute platform like Vertica enables far less human overhead in operations and analytics.
What is most valuable?Scale-out, analytical functions, ML.
How has it helped my organization?We are an HP partner. A SQL-based compute platform like Vertica enables far less human overhead in operations and analytics.
What needs improvement?More ML, both data prep, models, evaluation and workflow. Improved support for deep analytics/ predictive modelling with machine learning algorithms. This area of… more»
What's my experience with pricing, setup cost, and licensing?Its reasonably priced for non-trivial data problems.
Which solution did I use previously and why did I switch?Postgresql, MySQL, SQL Server. Switched because of scalability and reliability, analytics functionality. V being a better engineered product.
What other advice do I have?See additional functionality above.
Which other solutions did I evaluate?Yes, Hadoop / Spark, SQL Server.
Sep 02 2016
What do you think of Vertica?
What is most valuable?Super-fast aggregated results from massive data.
How has it helped my organization?We can process vast amounts of data, fast and with a high degree of reliability.
What needs improvement?Better feedback from installation. I would like to see more meaningful errors returned and more graceful handling of those. Thankfully, we don't often hit error conditions.
For how long have I used the solution?4 years.
What was my experience with deployment of the solution?No
What do I think about the stability of the solution?No
What do I think about the scalability of the solution?Depends on the environment. Generally pretty good. If you have a large catalog, you can get timeouts adding nodes. Large catalog issues have been dealt with it recent…
Sep 02 2016
What is most valuable?Query Performance.
What needs improvement?More analytical functions. Optimization around DML operations such that we be able to use it more. I understand that Vertica is not meant for that, but I would really love it if it has capability to support procedural processing. Optimization around DML refers to fast DELETE and UPDATE statement such that we can leverage Vertica around those operations. I do understand that Vertica is not meant as an OLTP system, neither I'm asking to have it similar but if DML operations can be optimized, that would be admirable. Regarding, my comment on the capability to support procedural processing -… more»
What is Vertica?
Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
To learn more about Micro Focus Vertica Advanced Analytics, visit our website.
Also known asMicro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.