
Vertica by the Hour, Red Hat
OpenText | 25.1.0-0Linux/Unix, Red Hat Enterprise Linux 9 - 64-bit Amazon Machine Image (AMI)
External reviews

External reviews are not included in the AWS star rating for the product.
Vertica amazing product and exciting toolset for DW and Analystics platform
What do you like best about the product?
Troubleshooting on vertica platform is quite easy and it provides very detailed information as well about the insights what vertica is doing inside its database.
Tools and functions available to perform Analytics and handle Warehouse tasks are good.
Tools and functions available to perform Analytics and handle Warehouse tasks are good.
What do you dislike about the product?
Internal debugging documentation is one area which needs improvement
What problems is the product solving and how is that benefiting you?
We use vertica for Store once and read more. Mostly helpful for warehousing tasks
- Leave a Comment |
- Mark review as helpful
Likelihood to Recommend
What do you like best about the product?
It's Columnar and It's Analytical functions.
What do you dislike about the product?
I Hate to manage it at Projection level.
What problems is the product solving and how is that benefiting you?
I am managing a DWH and analytical reports on DWH. It has very good speed and beautiful data management functions.
From dark data into the ligh
What do you like best about the product?
Ease of deployment and maintenance. Database performance on terabytes of data right out of the box.
What do you dislike about the product?
It would have been nice if we could have integrated with our LDAP environment. Permissions on DDL functions were difficult to hand out as those were locked to the DB owner.
What problems is the product solving and how is that benefiting you?
The data was too large to be able to have any real insights into. We tried other columnar data stores and HDFS sorts of stores. With those we spent a lot of time trying to get data with no results. We stood up Vertica and all our data was available, clustered, highly available. We were able to gain insights within moments and continue to grow that.
Recommendations to others considering the product:
Try it! Get the free trial. It is worth it.
Blazing speed Big Data on Commodity hardware
What do you like best about the product?
Rapid responses, ability to handle large volumes of data, scalable and works on commodity hardware
What do you dislike about the product?
Not ideal for high velocity transactions
What problems is the product solving and how is that benefiting you?
Analytics solutions to Physician and Payer organizations. No need for a full time DBA to support a Big Data solution.
Vertica is the most obvious choice for on-premise data warehousing
What do you like best about the product?
We've tested and tested and benchmarked and benchmarked and every time Vertica comes out ahead against competing technologies (OSS or proprietary) in terms of raw throughput and concurrency handling. We've even seen it rival highly optimized in-memory analytics engines for latency under certain scenarios. This makes it the obvious choice for us for any sort of general OLAP or dashboarding task.
What do you dislike about the product?
We tend to push Vertica pretty hard and have a tendency to automate everything (we use chef for provisioning), which means we have had to write our own tools or adapt Verticas' to our purposes fairly substantially. This is no deal breaker, but it would be nice if they invested more time in the admin UX.
What problems is the product solving and how is that benefiting you?
Vertica is our core analytic database offering and as such is central part of the compute fabric. The fact that it is so efficient and flexible in this regard means that we leverage it behind many applications, limiting tech sprawl and allowing us to go to market faster and with fewer support staff.
Hybrid Storage Options are making Vertica more versatile
What do you like best about the product?
Recently added features - Complex Data types, Delegation Tokens, Hierarchial Partitions,
Upcoming features
New Storage options - EON on Prem, EON on GCP, Enterprise on GCP
libhdfs+ erasure coding support, DBD lite, Parquet enhancements
Upcoming features
New Storage options - EON on Prem, EON on GCP, Enterprise on GCP
libhdfs+ erasure coding support, DBD lite, Parquet enhancements
What do you dislike about the product?
Copy cluster not possible across heterogeneous clusters
What problems is the product solving and how is that benefiting you?
OLAP analysis and reporting
Fantastic Analytical Tool
What do you like best about the product?
Ease of use, performance, Return on Investment, Machine Learning and Analytics capabilities
What do you dislike about the product?
We've been very happy with Vertica since we started using 6 years ago, no there is nothing to dislike
What problems is the product solving and how is that benefiting you?
Building next generation telco analytics toolsets
Recommendations to others considering the product:
Vertica offers a lot of support for their prospective customers to try out all the important features before buying. I'll suggest anyone considering to buy to use that opportunity.
It leverages machine learning and predictive analytic features to help preprocess data
The primary use case is as an analytics database on EC2 instances.
How has it helped my organization?
* We gain insights into data in real-time with blazing, fast SQL analytics across exabytes of data.
* It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands.
* It leverages machine learning and predictive analytic features to help preprocess data.
What is most valuable?
It maximize cloud economics for mission-critical big data analytical initiatives.
What needs improvement?
It needs integration with multiple clouds.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
I have implemented it on Amazon EC2 instances with medium IT workloads.
What do I think about the scalability of the solution?
It has an elastic scalability solution.
How was the initial setup?
It is easy to integrate with EC2 instances.
What's my experience with pricing, setup cost, and licensing?
It is fast to purchase through the AWS Marketplace.
The pricing and licensing depend on the size of your environment and the zone where you want to implement.
What other advice do I have?
It is a complete solution and a also good solution for EC2 instances.
Vertica is immensely useful for structured data
What do you like best about the product?
High amount of uptime
Clear documentation
Great python modules
Clear documentation
Great python modules
What do you dislike about the product?
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
Vertica in a League of its Own
What do you like best about the product?
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 about the product?
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.
SQL Functions, Each function is annotated with behavior type as immutable, stable or volatile.
showing 51 - 60