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

Vertica by the Hour, Red Hat

Micro Focus | 12.0.0-0

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

156 reviews
from G2

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


    Jeetendra M.

Excellent MPP system for Analytics

  • December 11, 2020
  • Review provided by G2

What do you like best?
Very easy installation. Robust architecture to store and process terabytes of data very quickly
What do you dislike?
When it comes to GUI based system management it isn't efficient. Also currency is an issue.
What problems is the product solving and how is that benefiting you?
We were working on analytical reporting based on very large number of records, which could not be done using other databases. But with Vertica we could get the results pretty fast for business to make timely decisions. Storing and retrieving data is super efficient.
Recommendations to others considering the product:
Consider it for Data mart type of applications where you need to do specific analytics based out of Teradata bytes of data.


    Insurance

Vertica with external table on aws s3

  • December 10, 2020
  • Review provided by G2

What do you like best?
Vertica projection improved the microstrategy reporting by a huge margin.

Vertica with aws s3 helped us to leverage
the elasticity and power of cloud along with the traditional powerful rdbms capabilities.
What do you dislike?
Projections some time creates problem while deployments.
What problems is the product solving and how is that benefiting you?
Developing a traditional datamart using data stored on aws s3


    Neetu Y.

Robust tool for Data Analytics

  • December 10, 2020
  • Review provided by G2

What do you like best?
Vertica is user friendly to use to fetch data from DB and query run is fast. Also, it is nice tool to handle and fetch large data. It is very useful tool for retail and ecommerce industry which has data in billions.
What do you dislike?
Not any dislike about but in my experience in analytics, vertica is best tool i used to get data using SQL.
What problems is the product solving and how is that benefiting you?
Vertica is very useful to get data using SQL for business which we can use to get reports and insights for top management to take good decision.
Recommendations to others considering the product:
best tool i used to fetch data in billions.


    Divya S.

Vertica review

  • December 10, 2020
  • Review verified by G2

What do you like best?
Analytics functions and query time are good
What do you dislike?
More complex computations like hive can be improved
What problems is the product solving and how is that benefiting you?
Query time optimisation


    Ujjwal Kumar G.

Wonderful experience with the scalable data warehouse

  • December 10, 2020
  • Review provided by G2

What do you like best?
Elasticity, Use of S3 as the storage, simple to use interface for monitoring and management.
What do you dislike?
Lack of in-built load balancing for vertical cluster.
What problems is the product solving and how is that benefiting you?
Querying large amount of data quickly and effectively by multiple users simultaneously.


    Information Technology and Services

It's really a very good data platform fir data warehouse house

  • December 10, 2020
  • Review provided by G2

What do you like best?
Data storage and data management is superb.
What do you dislike?
Indexing can be improved and memory also can be taken care
What problems is the product solving and how is that benefiting you?
Lots of data analysis done at my end
Recommendations to others considering the product:
Yes highly recommend


    Babu R.

vertica is fast and supports SQL reducing learning curve

  • December 10, 2020
  • Review provided by G2

What do you like best?
Column db structure is ideal for reporting. Its distributed architecture helps scale seemlessly which makes it ideal for handling large data. Projections are very useful.
What do you dislike?
Vertica has its own version of SQL in addition to standard SQL which makes it hard to write optimized queries. Its expensive.There is hardly any downtime.
What problems is the product solving and how is that benefiting you?
We have a vertica cluster installed on 64 GB ram systems to query large data (100GB incremental per day) in two different regions of the world- one in USA and other in Europe. Our clients are mostly querying round the clock. One person monitors and maintains the cluster.
Recommendations to others considering the product:
If you want to build a datawarehouse or want to build adhoc queries for large data, Vertica is a good choice. We have tried other RDBMs and finally settled down with Vertica.


    Information Technology and Services

Vertica is good as analytics storage, but open-source Clickhouse took its place on the market

  • December 10, 2020
  • Review provided by G2

What do you like best?
That it works out of the box and goes with cluster support & management tools
What do you dislike?
It's price. It's too expensive. And Clickhouse works faster right now for the same purposes
What problems is the product solving and how is that benefiting you?
Classical OLAP data storage. The projections concept was pretty nice. Management tools as well


    Salman K.

Good Columnar database for OLAP

  • December 10, 2020
  • Review provided by G2

What do you like best?
There are following thing i like about vertica
1. EON mode no need down time for maintenance
2. Fast and scalable
3. fault Torrance recovery system are good
What do you dislike?
bit complex to learn, there are too many new concept as compare to traditional RDBMS
What problems is the product solving and how is that benefiting you?
We are using vertica for implementing OLAP data warehousing system, I love Flex table feature of vertica


    Sanjay S.

Modernizing EDW

  • December 10, 2020
  • Review provided by G2

What do you like best?
Its performance, scalability, integration, easy integration with big data environment. Vertica is capable to support streaming data and able to ingest data stream at low latency.
What do you dislike?
Its data size limitation, pricing is high with large data size.
What problems is the product solving and how is that benefiting you?
Able to ingest high volume/streamed Call Detail Record(CDR), in telecom domain.
Recommendations to others considering the product:
Vertica a columnar database is excellent db for certain use cases.