What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
44 Ratings
30 Ratings

SingleStore

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.1 out of 100
30 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100

Attribute Ratings

  • SingleStore is rated higher in 1 area: Likelihood to Recommend
  • Vertica is rated higher in 1 area: Support Rating

Likelihood to Recommend

9.1

SingleStore

91%
32 Ratings
8.0

Vertica

80%
7 Ratings

Likelihood to Renew

10.0

SingleStore

100%
3 Ratings

Vertica

N/A
0 Ratings

Usability

7.6

SingleStore

76%
6 Ratings

Vertica

N/A
0 Ratings

Performance

9.4

SingleStore

94%
6 Ratings

Vertica

N/A
0 Ratings

Support Rating

7.7

SingleStore

77%
6 Ratings
7.9

Vertica

79%
3 Ratings

Likelihood to Recommend

SingleStore

SingleStore environment is easy to adapt, it is extremely fast on collecting data from different sources (AWS, GCP or Azure), provides monitoring of activities and easy use multiple databases. It is good for analytical and recommendation based scenarios, and provides fast results on complex queries. In SingleStore platform queries execution open new tab result for each run, which makes it difficult to navigate over the results.
Anonymous | TrustRadius Reviewer

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.
Eva Donaldson | TrustRadius Reviewer

Pros

SingleStore

  • Return results of complex queries scanning TBs of data in sub-seconds.
  • Customer support team answer tickets quickly and provide guidance.
  • MySQL engine which allows to query using simple MySQL drivers from different clients.
  • Queries profiling is easy to use and helps investigating performance.
Anonymous | TrustRadius Reviewer

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.
Praveen Murugesan | TrustRadius Reviewer

Cons

SingleStore

  • We wish the product had better support for High Availability of the aggregator. Currently the indexes generated by the two different aggregators are not in the same sequential space and so our apps have more burden to deal with HA.
  • More tools for debugging issues such as high memory usage would be good.
  • The price was the one that kept us away from purchasing for the first few years. Now we are able to afford due to a promotion that gives it at 25% of the list price. Not sure if we'll continue after the promotion offer expires in another 2 years.
Anonymous | TrustRadius Reviewer

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.
Traian Antonescu | TrustRadius Reviewer

Pricing Details

SingleStore

General

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

Starting Price

$69 per hour

SingleStore Editions & Modules

Edition
OnDemand0.691
  1. per hour
Additional Pricing Details

Vertica

General

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

Starting Price

Vertica Editions & Modules

Additional Pricing Details

Likelihood to Renew

SingleStore

SingleStore 10.0
Based on 3 answers
We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.
Anonymous | TrustRadius Reviewer

Vertica

No score
No answers yet
No answers on this topic

Usability

SingleStore

SingleStore 7.6
Based on 6 answers
[Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
Anonymous | TrustRadius Reviewer

Vertica

No score
No answers yet
No answers on this topic

Performance

SingleStore

SingleStore 9.4
Based on 6 answers
It seems good at being able to handle complex queries against large datasets out of the box. In the past, we've had to do quite a bit of manual configuration and database performance-tuning, but SingleStore (so far) has seemed to require minimal configuration in this aspect. Both data imports/exports, as well as queries against the data, run very fast.
Ruslan Smirnov | TrustRadius Reviewer

Vertica

No score
No answers yet
No answers on this topic

Support Rating

SingleStore

SingleStore 7.7
Based on 6 answers
Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
John Barry | TrustRadius Reviewer

Vertica

Vertica 7.9
Based on 3 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.
Anonymous | TrustRadius Reviewer

Alternatives Considered

SingleStore

Vertica, Snowflake, SQL Server, Azure Data Warehouse, PowerBI, Aerospike, etc.From what I've seen MemSQL is well worth the cost when latency and data freshness needs are high, i.e. you need a lot of queries to run with UI latency (the query itself takes less than a second or so), with very fresh streaming fact and dimensional data. It will be more expensive per "unit of performance" but if you need that performance then it'll get the job done.
  • On-prem Vertica (note, not Eon) provides more knobs for optimizing a particular data set and set of queries against it and performs as well or better in a single table, fact table queries. It will also scale to data size more cheaply due to its on-disk model. For large queries against large data sets where data freshness isn't as important (and latency either is or isn't), I'd take Vertica, although if you need to do a lot of joins that will struggle). However, as they still are exclusively columnar, dimension table updates, and recalls based on them, can only be tuned to happen so fast (we could do much better than 10 seconds with 10-100 updates per second for raw replication, and Vertica's joins are always slow so recalls were worse).
  • Snowflake suffers similarly to Vertica in the data freshness, replication, and re-calc area; SF also doesn't give as many knobs to turn as Vertica for data set optimization but seems to be better at joins. If you have a lot of queries to run against a lot of data and joins are limited, you need query latency low and consistent but you don't need a ton of freshness, I'd stick with Vertica. If joins matter more, or you can accept notably-but-not-terribly worse performance, then Snowflake is fine and cheaper from what we've seen. (Again, I can't speak to SF vs Vertica Eon).
  • SQL Server and ADW we couldn't get to perform as well as the other options, but I'll say we didn't try that hard on those.
  • Aerospike is amazing as a KV store; however for OLAP use cases where you want to balance performance against the flexibility of queries against general event (time series) data (i.e. be able to roll up to different grains) then KV becomes challenging.
  • PBI is great if you want an integrated BI tool, but if you want an OLAP solution to build against, with some particular scale or performance needs to be mentioned above, I'd go with one of these other solutions. It really can be great for letting non-tech folks build relatively small data sets and quick insights for customers (internal or external), great leverage in that case.
Anonymous | TrustRadius Reviewer

Vertica

Vertica performs well when the query has good stats and is tuned well. Options for GUI clients are ugly and outdated. IO optimized: it's a columnar store with no indexing structures to maintain like traditional databases. The indexing is achieved by storing the data sorted on disk, which itself is run transparently as a background process.
Anonymous | TrustRadius Reviewer

Return on Investment

SingleStore

  • As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data.
  • Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog.
Anonymous | TrustRadius Reviewer

Vertica

  • Positive impact on ROI by being able to get customer insights in real-time.
  • Positive ROI through reduced time to set-up and maintain Vertica instances.
Anonymous | TrustRadius Reviewer

Screenshots

Add comparison