Vertica Reviews

Bulk loading data using copy

Fast analytical functions

Ability to extend functionality

Great reporting.

Faster deletes!

4 years

None

Sometimes users write bad queries that has brought down the cluster. Need a way to better manage resources.

None

Great

Great

No

In house implementation.

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.

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.