Vertica by the Hour, Amazon Linux
OpenText | 24.4.0-0Linux/Unix, Amazon Linux 2023 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
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
- Leave a Comment |
- Mark review as helpful
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
I worked in Vertica almost more than 6years. I found it was good analytical DB.
What do you like best about the product?
Columnar DB, concepts of Projection, Continued availablity,flextable etc.
What do you dislike about the product?
Updates seems to be slow. We used to follow delete and under concepts.
What problems is the product solving and how is that benefiting you?
We did technology transfer from legacy application to new technology, and used Vertica for Trasfermation for data warehousing
Fast and scalable database for enterprise data warehousing
What do you like best about the product?
It’s the best database in terms of loading the huge chunks of transactional data and it’s very fast in doing so. It’s availability and consistency is good compared to other databases in the market right now. Due to Ksafe feature, data is almost every time available for the users.
This is my personal view on the database version I worked on
This is my personal view on the database version I worked on
What do you dislike about the product?
Expensive and few resources to learn more about the product apart from few tech blogs and the documentation comes from Vertica
What problems is the product solving and how is that benefiting you?
Banking domain, we were using for generating customer reporting for business users
Vertica: Present and future relevance
What do you like best about the product?
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 about the product?
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 is the product solving and how is that benefiting you?
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 about the product?
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 about the product?
It's little bit costly compared to other Db.
What problems is the product solving and how is that benefiting you?
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 about the product?
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 about the product?
Not easy to write procedure or scripts on vertica
What problems is the product solving and how is that benefiting you?
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
showing 151 - 160