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.
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.
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.
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.
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.
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.
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.
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.
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...
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.
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
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...
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.
We require one person for maintenance for the 100 users we have. I rate Vertica an eight out of ten.
I would advise others to try the solution out. I rate Vertica a seven out of ten.
I would rate this solution a ten out of ten.
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.
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.
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.
I rate Vertica an eight out of ten.
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.
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.
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.
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 is a complete solution and a also good solution for EC2 instances. I have not tried to integrate it with other products.
Do a good volumetric analysis to manage the storage needed.