Vertica by the Hour, Red Hat
OpenText | 24.1.0-3Linux/Unix, Red Hat Enterprise Linux 8 - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
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
- Leave a Comment |
- Mark review as helpful
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.
Vertica is good as analytics storage, but open-source Clickhouse took its place on the market
What do you like best about the product?
That it works out of the box and goes with cluster support & management tools
What do you dislike about the product?
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
Good Columnar database for OLAP
What do you like best about the product?
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
1. EON mode no need down time for maintenance
2. Fast and scalable
3. fault Torrance recovery system are good
What do you dislike about the product?
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
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
Superb experience
What do you like best about the product?
Speed performance, user friendly. Very innovative way of handling complex data
What do you dislike about the product?
No cons till now. Mainly users UI TO BE improved
What problems is the product solving and how is that benefiting you?
Procurement domain and banking domain. Trillions of data rows with complex business logivs
Recommendations to others considering the product:
Superb database
showing 131 - 140