Vertica Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
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»
Real User
Vertica Support Engineer at a media company with 10,001+ employees
Feb 23 2017

What is most valuable?

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

How has it helped my organization?

It provides very fast results for analysts running reports. These reports are crucial to help our clients strategize their targeted marketing.

What needs 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... more»
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse.
290,996 professionals have used our research since 2012.
Real User
Co-Founder at a tech services company
Jan 28 2018

What is most valuable?

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

How has it helped my organization?

We got something like a six-times improvement using Vertica.

What needs improvement?

I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing.
Real User
Database Administrator (DBA) at a software R&D company with 501-1,000 employees
Oct 30 2016

What is most valuable?

The auto-distribution to all nodes for fault tolerance and query performance was pretty amazing.

How has it helped my organization?

Our data warehouse at the time was a multi-terabyte PostgreSQL cluster. It worked really well, but we wanted to increase the size to many TB's and our due to our query and loading patterns we found greater performance from Vertica's... more»

What needs improvement?

In the versions I worked with, if a majority of the nodes were being loaded under heavy, sustained rates the nodes would see some dramatic decreases in performance due to the data shuffling that needed to occur between all the nodes. To work... more»
Real User
Sr. SW Engineer - Databases with 201-500 employees
Jan 17 2018

What is most valuable?

* Clustered database * Horizontal scaling * Disaster recovery * Columnar Storage * Compression (you read only columns you need) * Immutable storage * Fast ingesting

How has it helped my organization?

It enabled delivery of a new Agile Data Warehousing Service. It enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance.

What needs improvement?

Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata. Query performance: Improve either Database Designer... more»
Real User
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees
Jun 27 2017

What is most valuable?

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

How has it helped my organization?

Before Vertica, we used a combination of sharded RDBMSs and Hive: the typical runtime for a query was in the hours. It's now in the seconds, with way more data than then (we're talking hundreds of terabytes).

What needs improvement?

Whatever's out, the core is not always as great as the engine, especially their first version. That's true, for example, for the Kafka or Hadoop integration. But they're getting better release after release.
Consultant
Senior business Intelligence consultant at Asociación SevillaUP
Oct 30 2016

What is most valuable?

Speed in query in general and specifically in aggregate functions on multi-million rows tables.

How has it helped my organization?

Data Warehouse response times have decreased of one order of magnitude with respect to the previous solution (SQL Server + Oracle).

What needs 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... more»
Real User
Software and Data Architect at a software R&D company with 1,001-5,000 employees
Oct 30 2016

What is most valuable?

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.

How has it helped my organization?

We built an internal dashboard using the MicroStrategyto increase visibility to our management and our employees. Also, we built tool to expose the data to our selected partners and users to create better engagement with our platform.

What needs improvement?

* Loading times for “real time” sources - for example, loading from Spark creates a load on the DB at high scale * Connectors to other sources such as Kafka or AWS Kinesis * Better monitoring tools * Better integration with cloud providers -... more»
See 16 More Vertica Reviews

Articles

User Assessments By Topic About Vertica

Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse.
290,996 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.

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!

Sign Up with Email