Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

Vertica by the Hour, Amazon Linux

OpenText | 12.0.4-11

Linux/Unix, Amazon Linux 2.0 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

206 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Information Technology and Services

Good things are being done

  • December 02, 2020
  • Review provided by G2

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


    Syed Asif T.

Robust and Cost effective tool that can prove ROI in shortest time possible

  • December 02, 2020
  • Review provided by G2

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
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.


    Shrijan T.

Real fast database with horizontal scalability and features like UDx making it more powerful

  • December 01, 2020
  • Review provided by G2

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.
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.
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.


    Dhaval B.

World class OLAP database, Great support team

  • December 01, 2020
  • Review verified by G2

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


    Rajat A.

Vertica Pros COns

  • December 01, 2020
  • Review provided by G2

What do you like best about the product?
Good:- Vertica is column fast database for analytical purpose
Vertica easy to install
Vertica has support
What do you dislike about the product?
It needs maintaince
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


    Veerabhadrappa A.

I worked in Vertica almost more than 6years. I found it was good analytical DB.

  • December 01, 2020
  • Review provided by G2

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


    Banking

Fast and scalable database for enterprise data warehousing

  • December 01, 2020
  • Review provided by G2

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
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


    Animesh S.

Vertica: Present and future relevance

  • November 29, 2020
  • Review provided by G2

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.
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


    Anshuman S.

Genuine review for Vertica users

  • November 28, 2020
  • Review provided by G2

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.


    Information Technology and Services

Strange to see every time query output time was exactly same

  • November 27, 2020
  • Review provided by G2

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.
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.
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