Vertica by the Hour, Red Hat
Micro Focus | 10.0.1-4Linux/Unix, Red Hat Enterprise Linux 7.5 - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
Real fast database with horizontal scalability and features like UDx making it more powerful
What do you like best?
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?
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 are you solving with the product? What benefits have you realized?
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.
- Leave a Comment |
- Mark review as helpful
World class OLAP database, Great support team
What do you like best?
Projections feature and rich analytical functions are something I really liked and solved multiple problems
What do you dislike?
No inbuilt Encryption feature, would have better if encryption could be enabled easily
What problems are you solving with the product? What benefits have you realized?
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
I worked in Vertica almost more than 6years. I found it was good analytical DB.
What do you like best?
Columnar DB, concepts of Projection, Continued availablity,flextable etc.
What do you dislike?
Updates seems to be slow. We used to follow delete and under concepts.
What problems are you solving with the product? What benefits have you realized?
We did technology transfer from legacy application to new technology, and used Vertica for Trasfermation for data warehousing
Vertica: Present and future relevance
What do you like best?
The speed, Vertica is very fast to use and easily compatible with SQL Workbench tool which helps development , testing , debugging very easy. The columnar structure is the optimum solution for reporting. It is one of the fastest MPPs to work on.
What do you dislike?
The updates are a show stopper in Vertica, they are very costly.
The Projections and order by clause for better resource utilization are not hasslefree.
MemSQL provides a better solution.
The Projections and order by clause for better resource utilization are not hasslefree.
MemSQL provides a better solution.
What problems are you solving with the product? What benefits have you realized?
Vertica is an advantage on Teradata and Oracle, it is much faster and reporting to iPhone apps works like a charm. The projection provide an easy way to optimize without changing the base tables and thus increases scalability.
Recommendations to others considering the product:
Vertica for Reporting
Genuine review for Vertica users
What do you like best?
I like it most because it's different from all other regular database. It's a columnar database while others are row based. So searching is easy if DB size is very huge.
What do you dislike?
It's little bit costly compared to other Db.
What problems are you solving with the product? What benefits have you realized?
I was using it for data mining. We were using mostly for creating report. It was very quick.
Recommendations to others considering the product:
I can recommend to other users if they want quick output but their budget should also be high.
Strange to see every time query output time was exactly same
What do you like best?
Fast omputation time.
Very fast to retrieve the output of the query submitted.
Logical representation of the column database.
Good database at the presentation layer for reporting projects.
Very fast to retrieve the output of the query submitted.
Logical representation of the column database.
Good database at the presentation layer for reporting projects.
What do you dislike?
Not easy to write procedure or scripts on vertica
What problems are you solving with the product? What benefits have you realized?
It helps us to replace Teradata as database over the presentation layer for reporting to users.
Very fast in computation and almost same data retrieval time which is hard to see in Teradata helps us to move to Vertica for the reporting layer for over project.
Very fast in computation and almost same data retrieval time which is hard to see in Teradata helps us to move to Vertica for the reporting layer for over project.
Recommendations to others considering the product:
If you want the fast computation time and looking for a data base who can go with any technology.go for Vertica
I've been working with vertica for 5 years already. very happy.
What do you like best?
very powerfully , fast , scalable database
What do you dislike?
sometimes it is overkill for small systems.
Pooling is not always makes the difference
Pooling is not always makes the difference
What problems are you solving with the product? What benefits have you realized?
we are using it as production db and DWH. It performs good for those porpuse.
Recommendations to others considering the product:
sure
Columnar storage datawarehouse on cloud
What do you like best?
MPP architecture
columnar compression
high performance
columnar compression
high performance
What do you dislike?
Data size limitations
high pricing
limited options for querying clients
high pricing
limited options for querying clients
What problems are you solving with the product? What benefits have you realized?
Data warehouse, backend for BI and Analytical tools
Vertical Great Performance
What do you like best?
Data loading is faster.vertics supports big data
What do you dislike?
Performance wise slow.it can't support in memory operations
What problems are you solving with the product? What benefits have you realized?
Data Analytics 1M dollars saved
Recommendations to others considering the product:
Use it to handle billions of data
Vertica is a powerful tool for Data ware house technology. I have been working nearly 2 years.
What do you like best?
Performance and robust. Excellent clustering technology if one of the nodes crashes automatically it will regenerate a new node.
What do you dislike?
I would say there is nothing we can say dislike and this is a wonderful product for DW.
What problems are you solving with the product? What benefits have you realized?
Mostly this has backup issues other than that I never faced any issue.
showing 1 - 10