- Compression / speed with highly complex queries
We use it for analytics (marketing).
I have used it for three years. I worked with versions 4-7.x.
I occasionally encountered stability issues (more so in earlier versions).
I have not encountered any scalability issues.
Technical support is excellent.
Initially when I first started, the documentation, etc. available was scarce. However, this has improved substantially.
I was used to OLTP and DWH solutions based on technology such as Oracle, so some of the concepts are quite different.
Before choosing this product, other options were considered, e.g., Kognitio.
It’s still not mainstream (especially in the UK) and I would say to some extent still ‘improving’ at each release, but it is enterprise ready and a hugely cheaper option than some.
We did some like-for-like comparisons between HP Vertica and Oracle Exadata (work load / timings) and the two compared favourably, with Vertica being faster than Oracle in all but the biggest and most complex of queries.