Vertica by the Hour, Red Hat
OpenTextExternal reviews
210 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Vertica the high performance DB
What do you like best about the product?
It's performance, scalability and it's ease of use.Its reduced data storage is another great feature. It is IO optimized DB
What do you dislike about the product?
Pricing, supporting procedure would be a good option.Deletion is slower in vertica
What problems is the product solving and how is that benefiting you?
It helped in our huge volume and query performance issue which was a pain in traditional DB
Recommendations to others considering the product:
Please go ahead with vertica as it is one of the best DB for analytics.A POC will help in judging it's advantages
If you have bulk Data to process and heavy processing load then vertica is a good choice.
What do you like best about the product?
we have machine learning and NLP work, I like the most about is I can do much Regular expression and Data cleaning directly in Vertica. We can create our own function which is most helpful thing.
What do you dislike about the product?
For simple crud operation with some joins query could be faster.
What problems is the product solving and how is that benefiting you?
Regular expression at Vertica level I personally used the most for my profesional work. And our team is using it work various machine learning work.
Recommendations to others considering the product:
If you are looking for ETL solution then give a chance to Vertica. Performance is good and maximize performance for work related to big data.
Vertica review
What do you like best about the product?
Columnar access to database. Fetch records fastly then row based
What do you dislike about the product?
Only accessible on servers. Would like to see it in UI.
What problems is the product solving and how is that benefiting you?
Dat files to vertica database and then access to SAS
Vertica as a Analytical DB
What do you like best about the product?
Aggregation works better then traditional rdbms.
What do you dislike about the product?
Architecture is changing frequently. They need to stick to ine perticular architecture.
What problems is the product solving and how is that benefiting you?
Data warehouse and analytical reporting
Recommendations to others considering the product:
If you are very much sure about your use cases and will have very clean data set.
You can proceed with using Vertica
You can proceed with using Vertica
Vertica review
What do you like best about the product?
It's extremely helpful for fast querying on the reporting side involving TBs of data. We had migrated same data to newer streaming dbs which did not perform as well for the large data. It's easy to learn and implement - uncluttered and simple ! System tables are easy to read to understand underlying workings.
What do you dislike about the product?
Tuning is developer centric. Which means performance heavily depends on the developers decisions and knowledge. Conditional Updates not possible for alrge datasets - db crashes
What problems is the product solving and how is that benefiting you?
Sub second performance benchmark are met and nice integration with dashboards
Recommendations to others considering the product:
Awesome for sub second performance for huge datasets.
Good things are being done
What do you like best about the product?
Good work, excellent commitment, humanitarian will
What do you dislike about the product?
Not much of it seems fine let's see how it goes
What problems is the product solving and how is that benefiting you?
Pretty good computational problems
Robust and Cost effective tool that can prove ROI in shortest time possible
What do you like best about the product?
Columnar distribution and compression for reduced footprint. MPP for performance and scalability. ANSI compliance makes it easy for change management since users with previous SQL knowledge can move to Vertica easily. Documentation is pretty much clear even video tutorials for users are available which can be a great help. Vertica certification enables users to make more out of Vertica for understanding basic and advanced concepts.
What do you dislike about the product?
Per TB licensing. Users have to worry about license usage at all times which becomes a challenge with you are working in an organization with huge amounts of data. Though buddy projections do not use any license still users tend to create copies of data for the various purpose which in result exhaust license which is a challenge.
What problems is the product solving and how is that benefiting you?
First of all performance challenges secondly start small with vertical and then scale up.
Query execution times are improved using Vertica.
The administration is pretty easy since there is a lot of admin stuff maintained by Vertica itself
Query execution times are improved using Vertica.
The administration is pretty easy since there is a lot of admin stuff maintained by Vertica itself
Recommendations to others considering the product:
For those who want to validate its ROI, there is a good chance you start small with a minimum number of nodes, and as value realized start building on top of it and scale. Its less expensive than other RDBMS and offer more performance and scalability. The need for specialized is still there which again is not a big problem. We have implemented Vertica at numerous organizations and feedback from users is very positive and even hardcore Oracle and DB2 enthusiasts have recognized significant improvements in the overall solution.
Real fast database with horizontal scalability and features like UDx making it more powerful
What do you like best about the product?
Vertica UDx is one of the best capabilities from which you can extend Vertica based on your custom needs, along with this it's integrated environment for ML models is pretty good which brings analytics on plate in just matter of steps.
Vertica Eon mode is another best function which provides greater scalability without downtime and even saves the cost.
Vertica Eon mode is another best function which provides greater scalability without downtime and even saves the cost.
What do you dislike about the product?
Despite pros con is if you want to bring node up after crash all ip address needs to be same or as an alternative you have to update catalogue (which is generally not recommended)
What problems is the product solving and how is that benefiting you?
Analytical problem for various dashboard and reporting solutions.
Major benefit is sub second performance, logging integration with Kafka for real-time data syncing etc.
Major benefit is sub second performance, logging integration with Kafka for real-time data syncing etc.
Recommendations to others considering the product:
If you have analytical workload comprising of realtime and scheduled load and tou need sub second performance, give a try to Vertica as its friendly and cost effective with lot of flexibility and good support.
World class OLAP database, Great support team
What do you like best about the product?
Projections feature and rich analytical functions are something I really liked and solved multiple problems
What do you dislike about the product?
No inbuilt Encryption feature, would have better if encryption could be enabled easily
What problems is the product solving and how is that benefiting you?
Building Analytical Dashboard and reporting modules on over huge volume of data
Recommendations to others considering the product:
Good warehousing DB for most of your analytics workload
Vertica Pros COns
What do you like best about the product?
Good:- Vertica is column fast database for analytical purpose
Vertica easy to install
Vertica has support
Vertica easy to install
Vertica has support
What do you dislike about the product?
It needs maintaince
Experts are not easily available
Experts are not easily available
What problems is the product solving and how is that benefiting you?
move entire Business Intelligence system
300 reports from Oracle to Vertica
it was fast 5sec SLA
it was easily maintainable
it has integration with almost all reporting system and ETLs
300 reports from Oracle to Vertica
it was fast 5sec SLA
it was easily maintainable
it has integration with almost all reporting system and ETLs
showing 151 - 160