Vertica Review

The fact that it is a columnar database is valuable. Columnar storage has its own benefit with a large amount of data.

What is most valuable?

The fact that it is a columnar database is valuable. Columnar storage has its own benefit with a large amount of data. It's superior to most traditional relational DB when dealing with a large amount of data. We believe that Vertica is one of the best players in this realm.

How has it helped my organization?

Large-volume queries are executed in a relatively short amount of time, so that we could develop reports that consume data in Vertica.

What needs improvement?

Speed: It's already doing what it is supposed to do in terms of speed but still, as a user, I hope it gets even faster.

Specific to our company, we do store the data both in AWS S3 and Vertica. For some batch jobs, we decided to create a Spark job rather than Vertica operations for speed and/or scalability concerns. Maybe this is just due to the computation efficiency between SQL operations vs. a programmatic approach. Even with some optimization (adding projections for merge joins and grouped by pipelined), it's still taking a longer time than a Spark job in some cases.

For how long have I used the solution?

I have personally used it for about 2.5 years.

What do I think about the stability of the solution?

I have not recently encountered any stability issues; we have good health checks/monitoring around Vertica now.

What do I think about the scalability of the solution?

I have not encountered any scalability issues; I think it's scalable.

How are customer service and technical support?

N/A; don't have much experience on this.

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

We do have some pipelines accessing raw data directly and process it as a batch Spark job. Why? I guess it's because the type of operations we do can be done easily in code vs. SQL.

What other advice do I have?

I would recommend using Vertica for those people/teams having large denormalized fact tables that need to be processed efficiently. I worked around optimizing the query performance dealing with projections, merge joins and groupby pipelines. It paid off at the end.

Which version of this solution are you currently using?

**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.
512,711 professionals have used our research since 2012.
Add a Comment
ITCS user