Vertica Reviews

Geospatial

Profiling, query optimize, management.

1 year

Some bugs, they were rapidly fixed.

Minute

Not yet

Excellent

Very good

SQL Server did not scale.

Recovery by table

Copy cluster

VBR backup used to take more than one week to back up 70 TB of data. After upgrading to latest version, it is taking about 48 hours.

Improve Vertica logging and messages to Vertica startup commands.

4 years

I'm a Vertica specialist, and I'm certified by Micro Focus. The solution is deployed on-premise, but we have another installation on the cloud for another client.

It's the fastest database I have ever tested. That's the most important feature of Vertica. It has a lot of contents and machine learning functions. Today we have a lot of options for deploying. It has a lot of integrations.

I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them.

In other versions of Vertica, there is a lack of integrations in some machine learning models. But today, the latest version has it all. I don't think they need too much improvement in that area. For me, it's great considering the use case I work with.

I have been using this solution for four years.

I haven't really had the opportunity to talk with them, but that's because the database just works. I don't really need technical support for maintaining and running the database. The documentation is very clear too.

The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy.

I would rate this solution 8 out of 10. 

People should be careful with the way they are loading their data because Vertica is very fast at copying data. There are some operations that are slower than Oracle or SQL Server, but normally you wouldn't use that.

• HA Clustering
• Speed / Performance

We're able to retrieve queries nearly instantaneous for our custom analytical tools we built on top of Vertica.

More frequent updates.

1 year

None.

None.

Very knowledgable team which has provided excellent documentation for every issue we've had to troubleshoot.

MonetDB -- unstable, frequent crashes.

Straightforward, was able to get the database up fairly quickly with minimal effort.

We're still using the Community Edition (CE).

MonetDB, Cassandra, Amazon RedShift.

Great product, very mature and robust. Vertica is able to scale to meet our demands as we scale our business 10x.

Analytical features are amazing, the integration is wonderful.

It has helped us escalate, we need information almost real-time.

Documentation, there are functions that are not documented. UDF SDK, I'd like to see a step by step simulator example in a manual. The read-me code is good, however, an example would be great for starters.

3 years

Yes, cluster migration takes time.

Yes, in data streaming ROS containers is a pain to work with.

Not yet.

It is good, they answer in good time. There are times that they really don't come with a proper answer.

Decent.

Yes, regular relational databases. We switched for scalability reasons.

In-house.

Yes, Netezza.

I like the new things they are introducing. I want to see more with Python.

Scalability, query speed.

It is the foundation of our new Data Warehouse platform.

Data velocity and manageability.

The utilization/launching project has lasted for a bit more than a year now.

There have been some issues with deleting and updating data from tables.

No

No

I have not been in contact with their customer service.

I have not been in contact with their tech support.

We used Oracle but it did not scale well enough

It was straightforward.

I was not involved with the implementation.

Don't know.

The pricing is very flexible

There was a proof of concept for a number of technologies but I wasn't involved in those.

It looks promising.

It has performed well for the analytical and data warehousing performance. It has enabled scalability and has added value to the business.

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.

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.

The documentation could be improved with more examples of commands and step-by-step scenarios.

There were no stability issues.

There were no scalability issues.

The technical support is good, although it could be improved in terms of the response time and skill-set.

NA

The setup was pretty straightforward as it doesn't take much; if you plan your infrastructure right, then it is a breeze.

NO

Read the fine print carefully.

First, analyze your business requirements and if the analytics, scalability, and lower maintenance are your requirements then go for HPE Vertica.

Columnar storage makes 'hot data' available much faster than a traditional RDBMS solution. Also, Vertica scales up quickly and maintains good performance.

Performance management of high-traffic sites - Vertica's ease of scaling has been invaluable for one of our main customers.

I'm concerned that HP Enterprise has sold their software business, and worry about future investment to enhance predictive/machine-learning capabilities.

3 years.

Not really.... Vertica shines on stability.

No, scalability is also a strength of the solution.

9 out of 10. HPE has some excellent engineers who are eager to help us make Vertica work well.

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 is a bit clunky, like most complex, tunable products can be.

Negotiate when their fiscal year is about to close :)

It's a solid product that keeps its promises. I do worry about HP Enterprise's sale of Vertica to Micro-Focus

Rating: 8/10 - it works very well, but some customers worry about 'Vendor lock-in'.