Vertica Reviews

4.1 out of 5 stars
 (49)
Acb9d1ae 3d41 4d18 80e9 f05c1f45a688 avatar
Real User
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees
Jun 23 2016

What is most valuable?

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... more»

How has it helped my organization?

The 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... more»

What needs improvement?

Documentation has become much better, but can always use some improvement. Love the tech support, but hoping Micro Focus will invest in some additional training for the Level 1 responders so they are much more familiar with more areas of the... more»
Anonymous avatar x80
Consultant
Vertica Database Architect at a tech consulting company with 51-200 employees
Jun 23 2016

What is most valuable?

* Speed * Parallelization * SQL language * High Availability

How has it helped 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... more»

What needs 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... more»
Data warehouse report from it central station 2018 04 29 thumbnail
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse.
269,608 professionals have used our research since 2012.
2cf8da0a 1fb6 4d53 9732 7044a1fa652c avatar
Real User
Associate at a tech services company with 501-1,000 employees
Sep 14 2016

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 and a nightmare to maintain. The second... 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, load it, possibly scrub it some more, and... 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. Also, an improved monitor or monitoring with... more»
Bd3b4d79 34e6 423b 8a01 466c920de2ef avatar
Real User
Senior Data Warehouse Architect at a media company
Jun 24 2016

What is most valuable?

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... more»

How has it helped 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... more»

What needs 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,... more»
442e4a26 2206 451b ac45 7589b29ef04c avatar
Real User
Managing Partner at Thorium Data Science
Jul 20 2017

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, and... more»
See 44 more reviews

Articles

User Assessments By Topic About Vertica

Data warehouse report from it central station 2018 04 29 thumbnail
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse.
269,608 professionals have used our research since 2012.

Vertica Questions

Vertica Projects By Members

Vertica Consultants

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 as
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Vertica customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.

Vendor 7619 screenshot 1521912797
BUYER'S GUIDE
Not sure which Data Warehouse solution is right for you?

Download our free Data Warehouse Report and find out what your peers are saying about Micro Focus, Oracle, Teradata, and more!
Data warehouse report from it central station 2018 04 29 thumbnail

Sign Up with Email