Vertica by the Hour, Red Hat
OpenText | 12.0.4-11Linux/Unix, Red Hat Enterprise Linux 7.5 - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
Interesting and powerful database
What do you like best about the product?
Simplicity while using, stability. EON mode is something very useful especially when talking big data.
What do you dislike about the product?
Query sometimes lock tables and then it is necessary to use console to end queries. But this also can be a query tool problem.
What problems is the product solving and how is that benefiting you?
I am working with data warehouse tools and Vertica is working much faster than our previous database. So I can say it is DWH frendly tool.
Recommendations to others considering the product:
Very fast and reliable. Try it and you wont regret it.
- Leave a Comment |
- Mark review as helpful
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
Analysis tool for SQL engine
What do you like best about the product?
It's analytics of data as well as Parallel processing SQL engine
What do you dislike about the product?
Nothing for dislike every part is amazing
What problems is the product solving and how is that benefiting you?
Fast access as well as Parallel processing SQL base Engine.fast processing
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
Robust tool for Data Analytics
What do you like best about the product?
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 about the product?
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.
Vertica review
What do you like best about the product?
Analytics functions and query time are good
What do you dislike about the product?
More complex computations like hive can be improved
What problems is the product solving and how is that benefiting you?
Query time optimisation
It's really a very good data platform fir data warehouse house
What do you like best about the product?
Data storage and data management is superb.
What do you dislike about the product?
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
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.
showing 101 - 110