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?