Ability to get top performance for in-advance known aggregative SQL queries.
Big Data, Analytics and Hadoop Expert, Vertica DBA (Technical Leader), Architecture Group at a tech vendor with 5,001-10,000 employees
Simple setup and responsive support.
What is most valuable?
How has it helped my organization?
HP Vertica is an outstanding backend for Big Data-scale interactive dashboards/BI. Achieving top performance however requires a deep understanding of the product architecture and experience in fine tuning of Vertica.
What needs improvement?
I really would like to see Vertica able to use heterogeneous storage (RAM, SSD, HDD). Another issue I have seen is that the SQL optimizer fails to make optimizations that competing products are able to do. That’s something that should be improved as well.
For how long have I used the solution?
I've been using it for two years.
Buyer's Guide
Vertica
April 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,334 professionals have used our research since 2012.
What was my experience with deployment of the solution?
We have had no issues with deployment.
What do I think about the stability of the solution?
They should provide HA with Vertica, the cluster must be put behind Load Balancers.
What do I think about the scalability of the solution?
There have been no issues scaling it for our needs.
How are customer service and support?
I have no complaints, the HP guys were very responsive.
How was the initial setup?
The initial Vertica setup was really simple.
What about the implementation team?
In-house. The vendor team had many persons working on our project and we got an impression that it is difficult for them to focus on our requirements.
Which other solutions did I evaluate?
I have evaluated numerous competing products. HP Vertica was chosen for the top performance of aggregative queries.
What other advice do I have?
It is very easy to start using Vertica, however getting the maximum performance from it is a fine art.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
BI and Reporting Platform Teams and Tech leader at a computer software company with 1,001-5,000 employees
It's enabled us to develop our new reporting system which is used as a SaaS by our users. Greater query concurrency is needed.
Valuable Features
MPP
Analytical functions
HDFS Copy
Resource management
Improvements to My Organization
It's enabled us to develop our new reporting system which is used as a SaaS by hundreds of users. We can also load massive amounts of data in seconds and query it with SLA for online dashboards.
Room for Improvement
- Active-Active clusters with online replication.
- Greater query concurrency.
- Better documentation/white papers as there arte lots of undocumented issues.
Use of Solution
I've used it for three to four years.
Scalability Issues
Rebalancing after adding nodes is an issue in terms of resources and especially locking of tables. It would be nice if this could be more transparent.
Customer Service and Technical Support
8/10
Other Advice
If your product has lots of concurrent queries this solution is not suitable for you, or you need to implement a cache layer.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Vertica
April 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,334 professionals have used our research since 2012.
Member of Technical Staff at a tech company with 1,001-5,000 employees
In a PoC, query performance outperformed other solutions.
What is most valuable?
We are evaluating storage and database solutions for an OLAP application with following requirements:
- Extract, transform and load high velocity and volume of a numerical data stream on a distributed system.
- Interactive (less than 20 sec latency) query performance for critical group-bys.
Vertica is superior to other solutions in query performance.
How has it helped my organization?
We have not yet integrated the solution.
What needs improvement?
Vertica’s resource demands for RAM and I/O during load and storage were challenging for our platform. They recommend reserving 40% of storage for Vertica’s internal usage. Lower I/O usage during load is also highly desirable.
For how long have I used the solution?
The solution is not integrated into our product. We engaged in a PoC for 2-3 months in 2015 and put the evaluation on hold due to other project priorities.
What do I think about the stability of the solution?
We did not encounter any issues with stability.
What do I think about the scalability of the solution?
We did not encounter any issues with scalability.
How is customer service and technical support?
The level of technical support by the sales engineers during our PoC was excellent.
How was the initial setup?
Well-organized, online documentation made the initial setup fairly straightforward.
What about the implementation team?
Our in-house team worked on the PoC.
Which other solutions did I evaluate?
We evaluated a number of open-source and proprietary databases, as well as an in-house solution. Our PoC has been put on hold and we have not made final decision on a solution.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Vertica Report and get advice and tips from experienced pros
sharing their opinions.
Updated: April 2024
Popular Comparisons
Azure Data Factory
SQL Server
Snowflake
Oracle Database
MySQL
MariaDB
Microsoft Azure Synapse Analytics
SAP HANA
Teradata
Oracle Exadata
Amazon Redshift
IBM Db2 Database
MongoDB
BigQuery
Apache Hadoop
Buyer's Guide
Download our free Vertica Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which is the best RDMBS solution for big data?
- What is the biggest difference between Amazon Redshift and Vertica
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?
- What are the main differences between Data Lake and Data Warehouse?
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
- What is the best data warehouse tool?
- Which Data Strategy solution have you used?