Vertica by the Hour, Amazon Linux
OpenTextExternal reviews
210 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Data Engineering using Vertica for 5 years
What do you like best about the product?
It is a great solution for massive data warehouse application building.
What do you dislike about the product?
It is very costly and was not cool with multiple users accessing it at once.
What problems is the product solving and how is that benefiting you?
Our data warehouse was based on Vertica. Its parallel processing and thus query execution is quite good.
Recommendations to others considering the product:
Use it for computation and processing but do not expose to it transactional users
processing speeds much better than traditional databases ans also easy to setup as well as query
What do you like best about the product?
As we work on servers which receive huge amount of requests per day, integration with vertica for logging all the requests is very efficient as per my perspective. Vertica hds never disappointed ne till now.
What do you dislike about the product?
Databases with big catalog size may takes longer to start, also sometimes you have keep on pressing yes for a prompt while starting big databases
What problems is the product solving and how is that benefiting you?
Processing speed was a major problem which vertica does in seconds,also integrating tradition databases with streaming application s was a pain, which vertica resolved by providing inbuilt schedular.
Recommendations to others considering the product:
If your company needs good processing speeds for huge amount of traffic data to be stored Vertica is always a Good to go over the traditional databases. It is easy to setup as well as vertica has a deep documentation how to do it, easy to query, integrate with other applications and use as well
Excellent MPP system for Analytics
What do you like best about the product?
Very easy installation. Robust architecture to store and process terabytes of data very quickly
What do you dislike about the product?
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.
Vertica with external table on aws s3
What do you like best about the product?
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.
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 about the product?
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
Modernizing EDW
What do you like best about the product?
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 about the product?
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.
vertica is fast and supports SQL reducing learning curve
What do you like best about the product?
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 about the product?
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.
Experience to worked with vertica cluster database and administration with the glassbeam product.
What do you like best about the product?
I like this product due to simplicity but powerful and easily scalable features in it
What do you dislike about the product?
At that time 2010 when worked for Glassbeam product what was my observation is very less technical support and not very well GUI interface which actually not help to managing all the nodes .
What problems is the product solving and how is that benefiting you?
Used for storage realtime analytics data with very high volumn
Recommendations to others considering the product:
Definitely great product for Big Data application
My Views on Vertica
What do you like best about the product?
Performance and data reliability along with ease of architecture
What do you dislike about the product?
while using on premise, extending or limiting to size and maintaining cleanups was bit hectic
What problems is the product solving and how is that benefiting you?
analysis and data to information.
aggregates, snowflake architecture
aggregates, snowflake architecture
Recommendations to others considering the product:
If someone wants high performance and much more analytical functions then one should go for vertica
Complete Value for money
What do you like best about the product?
Supports a super fast information retrieval.
What do you dislike about the product?
The GUI is a bit old fashioned. Can be implemented in a good manner.
What problems is the product solving and how is that benefiting you?
Analysis and monitoring of applications.
Fast and Easy to Use
What do you like best about the product?
Query Execution Speed, Best Database for Transaction System
What do you dislike about the product?
Can't Write Store Procedure and Function
What problems is the product solving and how is that benefiting you?
Store huge amount of transactional data in shorts of time. Best benefits is projection
Recommendations to others considering the product:
Add PL/SQL functionality
showing 81 - 90