Sign in
Categories
Your Saved List Partners Sell in AWS Marketplace Amazon Web Services Home Help

Vertica by the Hour, Amazon Linux

Micro Focus | 12.0.2-0

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

167 reviews
from G2

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


    Health, Wellness and Fitness

Vertica the high performance DB

  • December 07, 2020
  • Review verified by G2

What do you like best?
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?
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


    Information Technology and Services

Good things are being done

  • December 07, 2020
  • Review provided by G2

What do you like best?
Good work, excellent commitment, humanitarian will
What do you dislike?
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 04, 2020
  • Review provided by G2

What do you like best?
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?
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.


    Rajat A.

Vertica Pros COns

  • December 04, 2020
  • Review provided by G2

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


    Banking

Fast and scalable database for enterprise data warehousing

  • December 04, 2020
  • Review provided by G2

What do you like best?
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?
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


    Pankaj M.

Database is very optimized easy to use and integrate

  • December 03, 2020
  • Review provided by G2

What do you like best?
sql queries runs very fast and it will give you very quick results when you are dealing with huge amount of data
What do you dislike?
it does not support stored procedures so we have to write explicit functions in code
What problems is the product solving and how is that benefiting you?
pulling and doing calculations on big amount of data is the very big benefit we are getting


    Ashrumochan B.

Vertica as a Analytical DB

  • December 03, 2020
  • Review provided by G2

What do you like best?
Aggregation works better then traditional rdbms.
What do you dislike?
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


    Animesh S.

Vertica: Present and future relevance

  • December 03, 2020
  • Review provided by G2

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


    Information Technology and Services

Strange to see every time query output time was exactly same

  • December 02, 2020
  • Review provided by G2

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.
What do you dislike?
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


    Dhaval B.

World class OLAP database, Great support team

  • December 01, 2020
  • Review verified by G2

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