Vertica Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
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… 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.

If you previously used a different solution, which one did you use and why did you switch?

We've used Greenplum, Teradata, and then Vertica. We used the big data open source solutions as well that are getting better. So those are the four that I can think of off the top of my head… more»

What other advice do I have?

The pros are, if you have columnar processing, then this is in your top three solutions. I think the con is the software pricing, and licensing needs to start getting more competitive with the open… more»

Which other solutions did I evaluate?

I evaluated Teradata, and another, but I didn't like either of them, not for what we needed.
Jan-Soubusta
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… more»

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

What's my experience with pricing, setup cost, and licensing?

Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or… more»

If you previously used a different solution, which one did you use and why did you switch?

In my current company I was not responsible for the switch. As far as I know, they switched from PostgreSQL, especially because of performance of analytical queries… more»

What other advice do I have?

It is easy to implement this solution for one customer. By tuning the model (projection design) you get incredible performance. You won’t face issues with metadata… more»

Which other solutions did I evaluate?

2012 - Detailed evaluation including benchmarks of: Greenplum, Vectorwise. 2017 - Evaluation of features and initial communication with vendors, if needed, for: Greenplum… more»
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse. Updated: October 2019.
372,622 professionals have used our research since 2012.
Alberto Guisande
Real User
Director at Decision Science
Jun 07 2019

What is most valuable?

Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.

How has it helped my organization?

Previous to Vertica, some analysis could not be made because of the amount of data needed. Vertica allowed us to take those volumes and process them at a very high speed.

What needs improvement?

* Support is an area where it could get better. * Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.

If you previously used a different solution, which one did you use and why did you switch?

I used Hadoop as the first approach. However, Vertica provided the best of both worlds (huge amounts of data and speed of access for analytics).

What other advice do I have?

Do a good volumetric analysis to manage the storage needed.

Which other solutions did I evaluate?

We evaluated Exasol, but it came out to be too expensive for the use case.
Alfonso Licir
Consultant
Technical Leader / Business Intelligence Consultant with 11-50 employees
Jan 25 2018

What is most valuable?

Vertica is a columnar database, this support our developments in analytics, advanced analytics, and our ETL process with large sets of data.

How has it helped my organization?

Before we used Vertica we used another columnar database which turned out to be very unstable and its performance was inconsistent. Vertica turned that around, to the… more»

What needs improvement?

I believe the installation process could be streamlined.

What's my experience with pricing, setup cost, and licensing?

The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan… more»

If you previously used a different solution, which one did you use and why did you switch?

See "Improvements to organization," above.

What other advice do I have?

The technical requirements for the product are really important. The design tool for vertica is the core of the database for performance. Never forget to use it to create… more»

Which other solutions did I evaluate?

Infobright and MonetDB.
Fahd Mirza Chughtai
Consultant
Cloud Architect, Oracle ACE, Oracle DBA at Pythian
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.

If you previously used a different solution, which one did you use and why did you 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.
Luis Henriquez
Consultant
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees
Jan 14 2019

What is most valuable?

It maximize cloud economics for mission-critical big data analytical initiatives.

How has it helped my organization?

* We gain insights into data in real-time with blazing, fast SQL analytics across exabytes of data. * It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands. * It leverages machine learning and… more»

What needs improvement?

It needs integration with multiple clouds.

What's my experience with pricing, setup cost, and licensing?

It is fast to purchase through the AWS Marketplace. The pricing and licensing depend on the size of your environment and the zone where you want to implement.

What other advice do I have?

It is a complete solution and a also good solution for EC2 instances. I have not tried to integrate it with other products.
Han Nguyen
Real User
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees
Jan 18 2018

What is most valuable?

Partition and join back to node are easy and simple for DBAs. DBAs don’t need to add a partition every month/quarter like with other DBs.

What needs improvement?

There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs.

What's my experience with pricing, setup cost, and licensing?

Licensing is based on size of the database.

If you previously used a different solution, which one did you use and why did you switch?

We use DB2, Oracle , MySQL, MSSQL. We switched to Vertica to explore it for future projects.

What other advice do I have?

My advice regarding this product is a definite "no", due to bad support.

Which other solutions did I evaluate?

They did a good PoC and we were impressed with Vertica. However, when we implemented, it was nightmare with bad support.
Dan Wities
Vendor
Bi Group Manager at a tech company with 201-500 employees
Jun 13 2018

What is most valuable?

* Its projections and encoding are excellent tools for tuning large volumes. * The product is simple and elegant. * It has excellent written documentation. I am able to answer any question by querying on Google.

How has it helped my organization?

It is tremendously scalability, with excellent performance. Vertica gives knowledgeable users and DBAs excellent tools for tuning.

What needs improvement?

You need to know what you are doing to get the most out of Vertica. If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer. It would be great if this were a managed service in AWS.
See 3 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. Updated: October 2019.
372,622 professionals have used our research since 2012.

Vertica Questions

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.

Read Archived Reviews
BUYER'S GUIDE
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