Vertica Review

It's enabled us to develop our new reporting system which is used as a SaaS by our users. Greater query concurrency is needed.


Valuable Features

MPP

Analytical functions

HDFS Copy

Resource management

Improvements to My Organization

It's enabled us to develop our new reporting system which is used as a SaaS by hundreds of users. We can also load massive amounts of data in seconds and query it with SLA for online dashboards.

Room for Improvement

  • Active-Active clusters with online replication.
  • Greater query concurrency.
  • Better documentation/white papers as there arte lots of undocumented issues.

Use of Solution

I've used it for three to four years.

Scalability Issues

Rebalancing after adding nodes is an issue in terms of resources and especially locking of tables. It would be nice if this could be more transparent.

Customer Service and Technical Support

8/10

Other Advice

If your product has lots of concurrent queries this solution is not suitable for you, or you need to implement a cache layer.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email