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

156 reviews
from G2

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


    Hospital & Health Care

Scalable, high-speed database on commodity hardware

  • March 05, 2019
  • Review provided by G2

What do you like best?
The ability to grow a database in either compute or storage with commodity hardware is very valuable. No other database comes to mind for speed of inserts or selects at this scale.
What do you dislike?
The documentation has improved over the years but there is less information than some competitors. There aren't as many users of this database products compared to others so the community is somewhat lacking.
What problems is the product solving and how is that benefiting you?
Vertica solves the problem of storing petabytes worth of data while actually being able to join across datasets in a timely manner. This allows for discoveries that couldn't be made otherwise.


    Hospital & Health Care

Vertica enables Cerner's Big Data Analytics

  • March 01, 2019
  • Review provided by G2

What do you like best?
We are inserting 1B rows per hour now. This data is easily consumed by a mixed mode of users. It has enabled Cerner to conduct deep analytics across all of our technical stacks resulting in reduced client incidents.
What do you dislike?
Hard to perform backups. If user pools are not continuously evaluated and monitored, large queries can bring the database to its knees. Still have not perfected a single node out situation. A single node out has put us into a downtime.
What problems is the product solving and how is that benefiting you?
Full analytics and visibility across our technical platforms. We have been able to do predictive fingerprinting and monitoring/auditing off of our data. We have approximately 1.1 PB of operational data used across multiple organizations.


    Internet

Vertica is immensely useful for structured data

  • July 31, 2018
  • Review verified by G2

What do you like best?
High amount of uptime
Clear documentation
Great python modules
What do you dislike?
I have no complaints about Vertica, but I do slightly prefer mysql due to syntax preferences
What problems is the product solving and how is that benefiting you?
Data analystics


    Cameron W.

Vertica in a League of its Own

  • May 06, 2018
  • Review provided by G2

What do you like best?
Vertica query optimizer relies on up-to-date statistics for tables, schema, and the database. The statistics allow the optimizer to determine the most efficient plan to execute a query
What do you dislike?
I am not able to change Profile data, Its saved in the pre made tables provided by creator.
What problems is the product solving and how is that benefiting you?
We are able to store more data, And customize that data into what we need.
Recommendations to others considering the product:
Quires can be made in any fashion as you need
SQL Functions, Each function is annotated with behavior type as immutable, stable or volatile.


    Hospital & Health Care

Great product

  • July 17, 2017
  • Review provided by G2

What do you like best?
HPE is one of the few solutions in their space that actually care about making an effective solution for their customers. Most companies just want the flashy new buzz words, but HPE prioritizes the real needs of their customers.
What do you dislike?
There were no particular things I disliked
What problems is the product solving and how is that benefiting you?
Moved from Oracle to HPE Vertica, saved massive amounts of money on infrastructure and allowed us to scale.


    Marcello P.

Incredible

  • April 29, 2016
  • Review verified by G2

What do you like best?
Before I met HP Vertica, I've worked with a few other column-store databases.

Few were easy to install and use, but were not reliable; others had good performance and stability but were definitely not use to deploy.

After 2-3 hours of deciding to try Vertica, I was running queries on it.

So what I like the best:
- Easy to deploy;
- Easy to Configure;
- Plenty of native tools to help the maintenance;
- Plenty of *clear* documentation to help you though;
- Fast - hands-down, the fastest for hardware I've worked with;
- Small - incredible compression rates to the data;
- Reliable/Stable fault-tolerant and - in my case - no data loss issues;
- No need for planning, analyzing or maintaining table indexes;
- Familiar way of loading data [PostgreSQL-like / COPY]
What do you dislike?
Even though most of the problems I've had were already answered in public forums from the Vertica Communiy - I use the community version -, I feel like there's not a big crowd trying to help or at least trying to make their voice heard online.
What problems is the product solving and how is that benefiting you?
Using the Vertica Community Version, we were able to increase - sometimes by a factor of 10 - the speed of Data Warehouses queries.

As we didn't have much time to try tens of different databases, Vertica showed handy when it comes to Install/Loading data.
Recommendations to others considering the product:
Read all the documents you can about Hardware Requirements. Even though it looks big, it's a very complete document, every DBA should beware of.

Because Vertica looks from outside a lot like PostgreSQL, users tend to forget some of its specificities when writing SQL queries or doing some other maintenance tasks. So beware of subqueries, data types, row-inserts - prefer bulk inserts - table/column drops, etc.