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

Vertica by the Hour, Red Hat

Micro Focus | 11.0.0-3

Linux/Unix, Red Hat Enterprise Linux 7.5 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

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

External reviews

108 reviews
from G2

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


    Bipulsingh K.

If you have bulk Data to process and heavy processing load then vertica is a good choice.

  • December 03, 2020
  • Review provided by G2

What do you like best?
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?
For simple crud operation with some joins query could be faster.
What problems are you solving with the product? What benefits have you realized?
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.


    GURJIT S.

Vertica review

  • December 03, 2020
  • Review provided by G2

What do you like best?
Columnar access to database. Fetch records fastly then row based
What do you dislike?
Only accessible on servers. Would like to see it in UI.
What problems are you solving with the product? What benefits have you realized?
Dat files to vertica database and then access to SAS


    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 are you solving with the product? What benefits have you realized?
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


    Vandana B.

Vertica review

  • December 03, 2020
  • Review provided by G2

What do you like best?
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?
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 are you solving with the product? What benefits have you realized?
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.


    Information Technology and Services

Good things are being done

  • December 02, 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 are you solving with the product? What benefits have you realized?
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?
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 are you solving with the product? What benefits have you realized?
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?
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?
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.
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?
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


    Rajat A.

Vertica Pros COns

  • December 01, 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 are you solving with the product? What benefits have you realized?
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?
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