Vertica by the Hour, Amazon Linux
OpenText | 24.4.0-0Linux/Unix, Amazon Linux 2023 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Vertica is best in class in it's domain of providing both world class products and services
What do you like best about the product?
Vertica is not just a database, it is a best in class analytical platform as well and is powerful enough to store huge data from big data platforms in a single unified platform
What do you dislike about the product?
Vertica can host it's more services as our offering, also as SAS cloud service. Also can make their cost model more flexible so customer can have more liberty to chose as per necessity
What problems is the product solving and how is that benefiting you?
Vertica is mainly used for both typical ETL and ELT use cases. It helped in pulling data from and migrating from On-premise storage systems and also helped in building unified data platform
- Leave a Comment |
- Mark review as helpful
As i have worked on the projection it will help the to get the faster data processing by optimizing
What do you like best about the product?
Projections and functions to query data.
What do you dislike about the product?
Performance and scalability. Its required high memory to query data.
What problems is the product solving and how is that benefiting you?
Data warehousing with very effective procing and that is every business want to do.
My Vertica Experience
What do you like best about the product?
The UI is quite user friendly and easy to understand.
What do you dislike about the product?
Nothing for now. I haven't yet explored that much to comment.
What problems is the product solving and how is that benefiting you?
It provides many useful big data services and supports languages like java and python.
4 years of experience with using vertica for our BI tool Lumenore.
What do you like best about the product?
All the syntax and function naming speaks for themself on top of that good documentation always comes to the rescue they also have very active and huge community for helping in case.
What do you dislike about the product?
no multi-line insert statement is kinda stopping us sometimes need some tweaking around to find the exact solution which will work perfectly It is inherent problem when you comes to columunar DB.
What problems is the product solving and how is that benefiting you?
we need to store a huge amount of data in the database and query some of it at a time. while querying few column from big database it takes constant amount of time when using vertica
Recommendations to others considering the product:
best for data storage and bi tools
A very satisfied programmer ,curious on how you guys achieve this
What do you like best about the product?
Performance.
We can process millions of records and the aggregation operation is also super fast.
Also, the insert operation is not taking that much time. The usage of CTEs which actually her stands in analogous to temp table operation is also very useful.
We can process millions of records and the aggregation operation is also super fast.
Also, the insert operation is not taking that much time. The usage of CTEs which actually her stands in analogous to temp table operation is also very useful.
What do you dislike about the product?
A native development environment and absence of parameters and absence of stored procedures. It would be better if you could provide all these and along with some profiler service.
Plus the performance is very poor if we use UNION ALL operation that too with the same data set.
Plus the performance is very poor if we use UNION ALL operation that too with the same data set.
What problems is the product solving and how is that benefiting you?
First of all it's super fast.
I don't know how you guys do that and I couldn't see any perfect documentation on this as well.
The aggregation operation is so fast that we are planning for data streaming rather than ETL and we hope the same performance will be there as well.
We are processing millions of records within milliseconds using Vertica, and there is no considerable variation in performance even when we use "OR" conditions in filter, which is one of the bottlenecks in conventional RDBMSs
I don't know how you guys do that and I couldn't see any perfect documentation on this as well.
The aggregation operation is so fast that we are planning for data streaming rather than ETL and we hope the same performance will be there as well.
We are processing millions of records within milliseconds using Vertica, and there is no considerable variation in performance even when we use "OR" conditions in filter, which is one of the bottlenecks in conventional RDBMSs
Recommendations to others considering the product:
Absence of parameters and stored procedures leads to extensive use of dynamic queries, which should be handled by the backend
Vertica review its trustworthy and data oriented
What do you like best about the product?
Vertica provides comprehensive live on demand and in person training covering self placed training and instructor lead classes , webinars and certifications
Gets customer to problems or bottleneck
Gets customer to problems or bottleneck
What do you dislike about the product?
One things that person should know is new structure
Not successful in cloud busine transformation
Cannoy say its best in industry yet
Recent changes Leadership changes
Not successful in cloud busine transformation
Cannoy say its best in industry yet
Recent changes Leadership changes
What problems is the product solving and how is that benefiting you?
Problems could be solved using best cloud solutions and engineering solutions benefits would be to reach that milestone to achieve desired goal and employees can learn new technologies
Recommendations to others considering the product:
Go with it
It's great DB
What do you like best about the product?
Vertica is real fast query engines, scalable and easy to use it
What do you dislike about the product?
At the moment nothing, I like it very much
What problems is the product solving and how is that benefiting you?
Performance per query of millions of tuples
Experience with Vertica
What do you like best about the product?
I really liked the way Vertica manages the huge data and partition concept.
What do you dislike about the product?
Resource management process as it admin have more chances to prioritize the accounts
What problems is the product solving and how is that benefiting you?
Data unavailability issues and data mismatch issues mostly
Demanding but great course
What do you like best about the product?
This is a comprehensive review of the essential knowledge you need to understand the more fundamental concepts in Vertica. It reviews from hardware to administration.
What do you dislike about the product?
The workspace was not properly configured, thus I had to reconfigure some network parameters (node names) while doing the configuration file in the backup module. Sometimes, the course is slow-paced, especially in the hands-on labs.
What problems is the product solving and how is that benefiting you?
Three businesses that belong to the firm I work on have Vertica as their main database storage system. The infrastructure is designed to work in development and production environments. Of those three businesses, only one has been able to fully deploy into production and that was possible only through Vertica. This is especially relevant because Vertica has full integration capabilities with BI tools like Tableau and is the only way to show data to executive users
Experience with Vertica
What do you like best about the product?
Bring the value to the business to attract the customer based on the right time accurate analysis in a faster way using Vertica.
What do you dislike about the product?
Nothing to dislike since all are valuable
What problems is the product solving and how is that benefiting you?
Handling huge data and getting the right KPIs after processing and analysing the data
showing 81 - 90