2018-03-08T15:52:00Z
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
  • 0
  • 7

What advice do you have for others considering Vertica?

If you were talking to someone whose organization is considering Vertica, what would you say?

How would you rate it and why? Any other tips or advice?

13
PeerSpot user
13 Answers
AA
Staff Database Developer at a manufacturing company with 10,001+ employees
Real User
Top 10
2022-10-26T00:53:06Z
Oct 26, 2022

We require one person for maintenance for the 100 users we have. I rate Vertica an eight out of ten.

Search for a product comparison
BS
Group Chief Technology Officer at Netcore Solutions
MSP
Top 20
2022-06-26T13:43:27Z
Jun 26, 2022

I would advise others to try the solution out. I rate Vertica a seven out of ten.

MunkhsaikhanBayar - PeerSpot reviewer
Project Lead - Digital Transformation Unit at Bodi Electronics LLC
Real User
Top 10
2022-04-11T22:01:23Z
Apr 11, 2022

I would rate this solution a ten out of ten.

OJ
Arquitecto Delivery at a tech services company with 501-1,000 employees
Real User
Top 5
2022-01-05T07:04:57Z
Jan 5, 2022

I would rate this solution 8 out of 10. People should be careful with the way they are loading their data because Vertica is very fast at copying data. There are some operations that are slower than Oracle or SQL Server, but normally you wouldn't use that.

MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees
Reseller
2021-10-29T18:01:02Z
Oct 29, 2021

I rate Vertica 10 out of 10. Anyone thinking about using Vertica should try to understand more than its basic functionality. They should look at its more powerful features like advanced, predictive, and real-time analytics. And just to add, that in the world of data warehousing, it's more accurate to say "near real-time" rather than "real-time" analytics.

Santosh Kurakula - PeerSpot reviewer
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
Top 5Leaderboard
2021-09-20T12:13:22Z
Sep 20, 2021

I would recommend this solution to others if it fits their use case. If someone is looking for a data warehouse solution with a fast query process Vertica is a good choice. However, it is different than a relational database. If the choice was between Postgres and Vertica, I would recommend Vertica. I rate Vertica nine out of ten.

Find out what your peers are saying about Micro Focus, Snowflake Computing, Teradata and others in Data Warehouse. Updated: November 2022.
656,862 professionals have used our research since 2012.
Jo Chaiyut - PeerSpot reviewer
Manager at Bizinfo Thailand
Reseller
Top 10
2021-06-05T22:45:18Z
Jun 5, 2021

I rate Vertica an eight out of ten.

JelsonGhigonetto - PeerSpot reviewer
Creator and Manager of Intelligent Water Loss Management Models at Qintess
Real User
Top 10
2020-12-18T00:01:00Z
Dec 18, 2020

This solution is used by several big companies such as Bank of America, Uber, and Facebook. Where you need a BI with intelligence. We use the solution because it is very good, you can make interconnections with anything to collect the data, any type of data. I have tried other products and they did not fit as well as this one did, I recommend Vertica. I rate Vertica a nine out of ten.

Teddy Elias - PeerSpot reviewer
Senior Manager, Systems and Network Engineering at a computer software company with 11-50 employees
Real User
2020-11-27T22:55:00Z
Nov 27, 2020

My advice to someone considering Vertica is to go for it. Nothing is missing. I would rate it a ten out of ten. The only issues are support and the price.

MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees
Reseller
2020-09-13T07:02:21Z
Sep 13, 2020

The customers love them. They absolutely love them. Before implementing this solution, make sure that it is on the list and that you evaluate it. I would rate Vertica a ten out of ten.

SO
Senior Database Architect at a real estate/law firm with 501-1,000 employees
Real User
2020-08-23T08:17:24Z
Aug 23, 2020

Advice that I would give others who are considering this solution is what I always say for all products: you should heavily test your use cases and data with the product. There are different versions of software and there are always new software solutions. You always should do an exhaustive performance testing from the point of view of any database product. Better to let the product speak for itself. Test several vendor's products if possible. To be honest, it is hard to see too many issues with Vertica as a solution. I find a few weaknesses in it, but I think that is the same with all databases. I think when you are doing very large fact table to very large fact table joins pretty much every database will experience problems. Joining two tables that are many multi-million rows is just a large volume to process. Honestly, I think if you get a proof-of-concept up, you do your typical load and then keep multiplying concurrency and data volume — see how it works for concurrency, speed. Vertica so far has proven to be relatively hassle-free. But, like all databases, you do have to keep an eye on how people use it, particularly when it comes to reporting. On a scale from one to ten where one is the worst and ten is the best, I would rate Vertica as a nine.

it_user848262 - PeerSpot reviewer
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees
Consultant
2019-01-14T13:16:00Z
Jan 14, 2019

It is a complete solution and a also good solution for EC2 instances. I have not tried to integrate it with other products.

Alberto Guisande - PeerSpot reviewer
Director at Decision Science
Real User
Top 5Leaderboard
2018-03-08T15:52:00Z
Mar 8, 2018

Do a good volumetric analysis to manage the storage needed.

Related Questions
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Oct 26, 2022
Hi, We all know it's really hard to get good pricing and cost information. Please share what you can so you can help your peers.
2 out of 7 answers
JelsonGhigonetto - PeerSpot reviewer
Creator and Manager of Intelligent Water Loss Management Models at Qintess
Dec 18, 2020
It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy.
Jo Chaiyut - PeerSpot reviewer
Manager at Bizinfo Thailand
Jun 5, 2021
The price could be cheaper and it is best to negotiate the price.
it_user1272297 - PeerSpot reviewer
Special Adviser Strategy at a university with 501-1,000 employees
Apr 19, 2020
I currently am working as a Special Strategic Adviser. I am involved in strategic risk management analysis and mitigation actions. We are currently evaluating SQream Technologies SQream DB. Does anybody have experience with them and can attest to them being the best RDBMS vendor for big data of 30TB+? Are there any other RDBMS solutions for big data that I should be evaluating? Thanks! I ap...
2 out of 4 answers
Russell Rothstein - PeerSpot reviewer
CEO at PeerSpot (formerly IT Central Station)
Jan 27, 2020
Morten, the most popular comparisons of SQream can be found here: https://www.itcentralstation.com/products/sqream-db-alternatives-and-competitors The top ones include Cassandra, MemSQL, MongoDB, and Vertica.
CD
Data Architect at a tech services company with 201-500 employees
Jan 27, 2020
I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505
Related Articles
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias. Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why. You can read user reviews for the Top 5 Data Warehouse Tools to help you d...
Explore this product
Related Articles
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
Top 5 Data Warehouse Tools 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to...
Download Free Report
Download our free Data Warehouse Report and find out what your peers are saying about Micro Focus, Snowflake Computing, Teradata, and more! Updated: November 2022.
DOWNLOAD NOW
656,862 professionals have used our research since 2012.