Vertica Reviews

Manage big data fast and easy.

The time that the mediation process takes and historical information that I can store.

Yes, there is a functionality in Vertica "Broadcast" that high the process level of our Network Switch Core. I had a serious problem with this because I interrupted the network service in the company. We have to change "Point to point".

Excellent!

Excellent!

Yes, Netezza and SAP HANA.

I would like HP to help me to do more uses cases with Vertica. We are very interested in becoming a Business Partner in order to offer Analytics As A Service to our customers.

Group by performance

Analytic functions

We could run group by queries thousand of times faster, we are able to test more models and improve accuracy.

Debug custom functions in r.

One year

None

None

None

Great! Email response is quickly and also within reported issues are resolved.

Ggreat, they really understand what they are talking about.

Straightforward, very easy.

In house

• 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.

Fast inserts, queries way faster than in SQL Server.

Certain research which was unattainable beforehand, now is in reach.

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 full support of all Vertica features. For example with the "copy to" command it is buggy - extremely hard to debug.

Other issues would be better query plan display and better management tools like command line admin tools. (MC would probably solve a bit here, I saw a demo on the conference). We have several avid Python users in the company, but this how maybe lower priority after I reviewed my conference materials and found that Vertica now has native Python driver.

2 years.

I was acting as my own DBA for a while, so a lot of hurdles before. But things are getting easier as more people in the company bought into the solution. I also got HP Training in house. (Thanks Herb!)

We can scale a lot, wish it was a bit more affordable.

It complements our SQL Server solution.

Own efforts.

Switch to per node from per TB.

Geospatial

Profiling, query optimize, management.

1 year

Some bugs, they were rapidly fixed.

Minute

Not yet

Excellent

Very good

SQL Server did not scale.

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.

We are using Vertica in our warehouse.

I have found that coding support could be simplified.

I have been using this solution for approximately five years.

The solution is stable.

I have found the solution to be scalable.

I have used the local support and I prefer them.

The price could be cheaper and it is best to negotiate the price.

I rate Vertica an eight out of ten.

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.

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.

Yes, we have encountered issues with Projections and performance.

Very bad support, I would rate it two out of 10.

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

Easy setup. Much easier than setting up Oracle RAC.

Licensing is based on size of the database.

They did a good PoC and we were impressed with Vertica. However, when we implemented, it was nightmare with bad support.

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