Team Lead Solutions Architect at IMEXPERTS DO BRASIL
Real User
Top 10
2024-06-03T14:07:00Z
Jun 3, 2024
You can implement a cluster of servers, and we should guarantee high availability in a disaster recovery scenario. You can use Vertica in a production environment with distributed workflows and workloads. Vertica is available and has parallel processing and other capabilities. You can implement a cluster of servers to guarantee high availability and massive parallel processing. It's a very sophisticated solution. Vertica can be used to implement machine learning models such as classification, clustering, and aggregation models to support various use cases depending on customer needs. We have already implemented some machine learning models to detect anomalies. Some employees have distinct patterns in their working behaviors. It is another feature-intelligent solution from OpenTex. It can implement or process structural data such as images, videos, text documents, and semi-structured data. I recommend using this kind of solution because you can index your data and use a balancing algorithm to manage and retrieve data efficiently. Customers don't need a very large infrastructure to implement this type of solution. You can use it to implement advanced machine learning models, classification, and clustering. It also supports advanced artificial intelligence solutions. Overall, I rate the solution a nine out of ten.
Vertica improved real-time data ingestion from sources and reporting to business users. The solution's native functions were usable for some simple use cases. However, developers prefer something else, like Python, for some complex projects. Vertica has features very similar to those of other databases like Netezza or Snowflake. The solution provides great value for its price. Vertica's integration with third-party systems is very easy because it supports standard integrations like ODBC and JDBC. The solution's price-performance ratio is great, and it is used as a group data warehouse. Overall, I rate the solution a seven out of ten.
I would describe Vertica as a user-friendly product. The documentation part of Vertica is almost the same as the one for MySQL, which we have in our company. The documentation part of Vertica is very friendly enough to use, but I can never say that the documentation area is better. I don't use ChatGPT to help me with my queries since I try to deal with my issues and queries on my own. I don't want anything improved in the solution as it provides us with everything we require in our IT environment. If I know how to run a query, then the results generated by Vertica turn out to be okay. The stability offered by Vertica is something that depends on the application and the memory of the product. If you work with Vertica in any of your projects, you will see that it works better for you with much more resources than others. You won't encounter problems with Vertica, especially if your company's architects are better at managing and creating interfaces. I recommend Vertica to those who plan to use it since it is easy to configure and use. I don't think you would encounter any problems with Vertica. The syntax in Vertica is easy to use and user-friendly, which you can find on Google. I rate the overall tool a seven out of ten.
Arquitecto Delivery at a tech services company with 501-1,000 employees
Real User
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.
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
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.
Creator and Manager of Intelligent Water Loss Management Models at Qintess
Real User
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.
Vertica is a deploy-anywhere SQL database created for elasticity, speed, and advanced analytics. Vertica enables today’s busy teams to modernize their data warehouses, democratize data and analytics to enable increased access, and deploy analytics in a hybrid cloud environment. Additionally, Vertica merges how companies power their analytics by providing a scalable, open, and elastic database with numerous intuitive features.
In today’s marketplace, organizations are experiencing continued...
I rate Vertica a seven out of ten.
You can implement a cluster of servers, and we should guarantee high availability in a disaster recovery scenario. You can use Vertica in a production environment with distributed workflows and workloads. Vertica is available and has parallel processing and other capabilities. You can implement a cluster of servers to guarantee high availability and massive parallel processing. It's a very sophisticated solution. Vertica can be used to implement machine learning models such as classification, clustering, and aggregation models to support various use cases depending on customer needs. We have already implemented some machine learning models to detect anomalies. Some employees have distinct patterns in their working behaviors. It is another feature-intelligent solution from OpenTex. It can implement or process structural data such as images, videos, text documents, and semi-structured data. I recommend using this kind of solution because you can index your data and use a balancing algorithm to manage and retrieve data efficiently. Customers don't need a very large infrastructure to implement this type of solution. You can use it to implement advanced machine learning models, classification, and clustering. It also supports advanced artificial intelligence solutions. Overall, I rate the solution a nine out of ten.
Vertica improved real-time data ingestion from sources and reporting to business users. The solution's native functions were usable for some simple use cases. However, developers prefer something else, like Python, for some complex projects. Vertica has features very similar to those of other databases like Netezza or Snowflake. The solution provides great value for its price. Vertica's integration with third-party systems is very easy because it supports standard integrations like ODBC and JDBC. The solution's price-performance ratio is great, and it is used as a group data warehouse. Overall, I rate the solution a seven out of ten.
I would describe Vertica as a user-friendly product. The documentation part of Vertica is almost the same as the one for MySQL, which we have in our company. The documentation part of Vertica is very friendly enough to use, but I can never say that the documentation area is better. I don't use ChatGPT to help me with my queries since I try to deal with my issues and queries on my own. I don't want anything improved in the solution as it provides us with everything we require in our IT environment. If I know how to run a query, then the results generated by Vertica turn out to be okay. The stability offered by Vertica is something that depends on the application and the memory of the product. If you work with Vertica in any of your projects, you will see that it works better for you with much more resources than others. You won't encounter problems with Vertica, especially if your company's architects are better at managing and creating interfaces. I recommend Vertica to those who plan to use it since it is easy to configure and use. I don't think you would encounter any problems with Vertica. The syntax in Vertica is easy to use and user-friendly, which you can find on Google. I rate the overall tool a seven out of ten.
I give the solution a nine out of ten.
I would rate Vertica an eight out of ten.
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.