What users are saying about

Vertica

Vertica
23 Ratings

Vertica

23 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

Based on 23 reviews and ratings

Likelihood to Recommend

Vertica

Vertica as a data warehouse to deliver analytics in-house and even to your client base on scale is not rivaled anywhere in the market. Frankly, in my experience it is not even close to equaled. Because it is such a powerful data warehouse, some people attempt to use it as a transactional database. It certainly is not one of those. Individual row inserts are slow and do not perform well. Deletes are a whole other story. RDBMS it is definitely not. OLAP it rocks.

Read full review

Eva Donaldson | TrustRadius Reviewer
Eva Donaldson
View all 6 answers on this topic

Pros

Vertica

  • Extremely fast query performance - Vertica is one of the fastest query engines out there.
  • Scales to TBs - Scales reasonably well up to 10-20 nodes and 10 - 100s of TB of data.
  • Easy to Use - Fairly easy to user, we made quite some headway with just 1 person running it for a while.

Read full review

Praveen Murugesan | TrustRadius Reviewer
Praveen Murugesan
View all 6 answers on this topic

Cons

Vertica

  • Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
  • Managing large workloads (concurrent queries) is a bit challenging.
  • Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
  • Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.

Read full review

Traian Antonescu | TrustRadius Reviewer
Traian Antonescu
View all 6 answers on this topic

Support Rating

Vertica

Vertica 7.6
Based on 2 answers
I haven't had any recent opportunity to reach out to Vertica support. From what I remember, I believe whenever I reached out to them the experience was smooth.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 2 answers on this topic

Alternatives Considered

Vertica

SAP HANA, Oracle, MySQL, and PostgreSQL are too heavyweight for achieving real-time latency requirements. Google BigQuery is limited to Cloud that makes hard to integrate with a large ingestion pipeline that may have both Cloud-based and on-prem components. Hadoop is much more complex to setup. Snowflake is again Cloud-based and is a new player so its reputation is not well known.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

Return on Investment

Vertica

  • The ROI on fast, interactive querying is very high.
  • Table size limitations force us to use other tools, slowing things down.
  • Relatively expensive pricing forces us to regularly upgrade our Vertica subscription and database. Each upgrade leads to a downtime of a few days.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

Pricing Details

Vertica

General

Free Trial
—
Free/Freemium Version
—
Premium Consulting/Integration Services
—
Entry-level set up fee?
No

Add comparison