Vertica Review

​Data Warehouse response times have decreased​. It doesn't support stored procedures in the way we are used to thinking of them.


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 enhancements, plus the overall choice of functions available. ETL with SSIS was not as easy as one we had expected (must remember to COMMIT and we had some issues with datetime + timezone, but that's was probably our fault).

OleDB and .NET providers need some touches; and another great improvement would be support for Entity Framework, which so far I haven't seen.

There is no serious graphical IDE for HPE Vertica, that's frustrating. One free option available is DbVisualizer for Vertica, but it's a bit basic.

For how long have I used the solution?

One year.

What do I think about the stability of the solution?

We have a one node cluster on Red Hat and last week the DB went down. The setting to restart the database is not very intuitive and by default the DB does not restart alone.

After a reboot, which may be good in some environments, but leaves you with an insecurity feeling.

What do I think about the scalability of the solution?

Our DB isin in the tens of Gigs, we did not need to scale yet.

How are customer service and technical support?

N/A, not used.

Which solution did I use previously and why did I switch?

We had SQL Server, switched for money reasons and space. But we're not sure yet, SQL Server is way more stable and predictable.

How was the initial setup?

No, the documentation is scarce on non standard setups. We had to create a virtual machine locally, set it up and then upload it to AWS.

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

We use the free community license, plenty of space for our environment. If I had unlimited budget I'd buy a preinstalled instance on EC2, much faster, but costly.

Which other solutions did I evaluate?

Netezza, but I didn't like it. For no particular reason, but the feeling was not right. Redshift - I was not impressed by the performance. Google Big Query - we tried it.

What other advice do I have?

Do COMMIT, and enable/enforce constraints because by default they ARE NOT!!!!

Which version of this solution are you currently using?

8.0.0-0​
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Vertica reviews from users
...who work at a Computer Software Company
...who compared it with Teradata
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
511,607 professionals have used our research since 2012.
Add a Comment
ITCS user
Guest