It has a very good design with high query performance. It provides the scale out capability by adding additional servers instead of scaling up the servers.
Director of Software Development at a tech company with 501-1,000 employees
It is scalable and worth the expense if you need the production capability that it can support.
What is most valuable?
How has it helped my organization?
It has provided much better performance than SQL Server for big data analytics.
What needs improvement?
I would like to see integration with the latest Hadoop ecosystem.
For how long have I used the solution?
We have used this solution for three years.
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 professionals have used our research since 2012.
What do I think about the stability of the solution?
It is usually very stable, but we occasionally see some nodes going down.
What do I think about the scalability of the solution?
There have not been any scalability issues. We are able to support trillions of data elements by adding more servers.
How are customer service and support?
The technical support is pretty good. I would give it a rating of 9/10.
Which solution did I use previously and why did I switch?
We used to use MS SQL Server. It is good for data transactions, but it is not good for big data analytics.
What's my experience with pricing, setup cost, and licensing?
It is pretty expensive, but it is worth it if you need the production capability that it can support.
Which other solutions did I evaluate?
We evaluated SQL Server and Teradata.
What other advice do I have?
It is worth a try if you are looking to provide a high-performance, big data analytics database.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Database Admin at a tech services company with 1,001-5,000 employees
Replication is the main feature for my use.
Valuable Features
Replication
Improvements to My Organization
Replication and Node recovery in 8.0.
Room for Improvement
vbr.py needs to be improve to support diff no of nodes source to target.
Use of Solution
5 years
Deployment Issues
No
Stability Issues
Yes
Scalability Issues
No
Customer Service and Technical Support
Customer Service:
8
Technical Support:8/10
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 professionals have used our research since 2012.
Principal Data Architect (BI) at a media company with 1,001-5,000 employees
I like the fast analytical functions and ability to extend functionality.
What is most valuable?
Bulk loading data using copy
Fast analytical functions
Ability to extend functionality
How has it helped my organization?
Great reporting.
What needs improvement?
Faster deletes!
For how long have I used the solution?
4 years
What was my experience with deployment of the solution?
None
What do I think about the stability of the solution?
Sometimes users write bad queries that has brought down the cluster. Need a way to better manage resources.
What do I think about the scalability of the solution?
None
How are customer service and technical support?
Customer Service:
Great
Technical Support:Great
Which solution did I use previously and why did I switch?
No
What about the implementation team?
In house implementation.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Infrastructure, Data Center and PMO Coordinator at a comms service provider with 501-1,000 employees
We could use it to offer Analytics As A Service to our customers.
Valuable Features
Manage big data fast and easy.
Room for Improvement
The time that the mediation process takes and historical information that I can store.
Deployment Issues
Yes, there is a functionality in Vertica "Broadcast" that high the process level of our Network Switch Core. I had a serious problem with this because I interrupted the network service in the company. We have to change "Point to point".
Customer Service and Technical Support
Customer Service:
Excellent!
Technical Support:Excellent!
Other Solutions Considered
Other Advice
I would like HP to help me to do more uses cases with Vertica. We are very interested in becoming a Business Partner in order to offer Analytics As A Service to our customers.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Scientist at a tech services company with 501-1,000 employees
We're able to test more models and improve accuracy.
Valuable Features
Group by performance
Analytic functions
Improvements to My Organization
We could run group by queries thousand of times faster, we are able to test more models and improve accuracy.
Room for Improvement
Debug custom functions in r.
Use of Solution
One year
Deployment Issues
None
Stability Issues
None
Scalability Issues
None
Customer Service and Technical Support
Customer Service:
Great! Email response is quickly and also within reported issues are resolved.
Technical Support:Ggreat, they really understand what they are talking about.
Initial Setup
Straightforward, very easy.
Implementation Team
In house
Disclosure: I am a real user, and this review is based on my own experience and opinions.
COO at a tech services company with 11-50 employees
A Good Option for Big Data
Valuable Features
Easy Installation, Easy to add and quit nodes...
Improvements to My Organization
SQLs querys 10 to 1 more fast that another commercial databases
Use of Solution
1 Year
Deployment Issues
Vertica support only SQL ANSI 99
Stability Issues
None
Scalability Issues
None
Customer Service and Technical Support
Customer Service: 10/10Technical Support: 5/10
Initial Setup
Easy
ROI
30%
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Project Lead - Digital Transformation Unit at Bodi Electronics LLC
Scalable big data analytics platform that is reasonably priced compared to other solutions
Pros and Cons
- "The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
- "The integration of this solution with ODI could be improved."
What is our primary use case?
Our primary use case for this solution is data analytics.
What is most valuable?
The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.
What needs improvement?
The integration of this solution with ODI could be improved.
For how long have I used the solution?
I have used this solution for 1 year.
What do I think about the stability of the solution?
This is a stable solution with a fast compression system.
What do I think about the scalability of the solution?
This is a scalable solution.
How are customer service and support?
The technical support for this solution is really good. The support team are friendly and provide assistance quickly.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup is straightforward.
What's my experience with pricing, setup cost, and licensing?
The pricing for this solution is very reasonable compared to other vendors.
What other advice do I have?
I would rate this solution a ten out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Manager at Bizinfo Thailand
Scalable, reliable, and good support
Pros and Cons
- "I have found the solution to be scalable."
- "I have found that coding support could be simplified."
What is our primary use case?
We are using Vertica in our warehouse.
What needs improvement?
I have found that coding support could be simplified.
For how long have I used the solution?
I have been using this solution for approximately five years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
I have found the solution to be scalable.
How are customer service and technical support?
I have used the local support and I prefer them.
What's my experience with pricing, setup cost, and licensing?
The price could be cheaper and it is best to negotiate the price.
What other advice do I have?
I rate Vertica an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
Buyer's Guide
Download our free Vertica Report and get advice and tips from experienced pros
sharing their opinions.
Updated: March 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?
I think your description is very trivial ! And also Big Data is not all about the database tech sitting in the background.