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.
I have worked for more than 4 years in ETL and data warehousing using Teradata and vertica
What do you like best about the product?
There is no need to create data structures again. It enables to integrate millions of rows to be delivered in real time basis.It also provides advanced analytics features that are not there in Teradata or other platforms.
What do you dislike about the product?
I think vertica should be flexible with cloud providers like Azure, AWS and Google Cloud Platform like Snowflake does. The storage cost and query execution should be more secure using service accounts.
What problems is the product solving and how is that benefiting you?
Vertica is helping me to fetch millions of rows in real time basis. Vertica has faster processing speed although it uses around 90% of space. i thinythey have designed vertica by keeping business needs in mind.
Recommendations to others considering the product:
It is a very good tool for data warehousing and big data.
- Leave a Comment |
- Mark review as helpful
Great experience
What do you like best about the product?
User interface and the last one is the best in the call I can't find it on my phone so I don't know the number of sleepless nights I had beacuse of harsh mails sent to me by the intial and
What do you dislike about the product?
Services to use for the support and understanding during my work with the insights you might have already know about this project in under targeted delivery timelines
What problems is the product solving and how is that benefiting you?
Data Analyst position requires the ability to be successful in the field Not entirely sure where this aritiffical hype will end up with the insights you might have already
Recommendations to others considering the product:
Get some time on introspection Will take care of other partitions
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
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.
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
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
Great performance and great community
What do you like best about the product?
The performance for my use case at my work at one of my previous companies was very good given it is a column based DB. Also, for different usecases and learning new stuff, the community and documentation was an immense support.
What do you dislike about the product?
I think there should be a provision to have an extensive managed service tieup with cloud providers which will further help ease off development rather than self-managing the DB.
What problems is the product solving and how is that benefiting you?
I was working on high scale big data problems involving a lot of columnar transaction data and most queries we hit generally involved picking up a subset of those columns. The performance was very good for our use case.
Vertica is launch of new era
What do you like best about the product?
Powerful functions that vertica provide for data anlytics create a difference between vertica and other tools , it's fast and more powerful for olap use cases and queries
What do you dislike about the product?
Nothing for now , but can be more helpful if we have more deatures to deal with cloud services such as glue catalog , athena and aws data lake , google big query
What problems is the product solving and how is that benefiting you?
Vertica helps me to derive critical data metrics that helps me to understand my data in depth and analytics data that help me to create BI report to visualise my data
Recommendations to others considering the product:
Nothing
The best staging database
What do you like best about the product?
Data reliability, scalability and transaction controls at its best. The compatibility with major ETL( Talend) and dashboarding tools(Qlik) is seemless. Just best!
What do you dislike about the product?
Sometimes we might face node failures and failover controllers are not much handy. Data limit exceeds quickly and there are warnings in command line which i personally felt cumbersome.
What problems is the product solving and how is that benefiting you?
Vertica External tables have Good compatibility with Hadoop's hive. Data can easily be migrated and is quite fast for all datasets. Creating Reporting system in realtime and Near real time is really good.
Recommendations to others considering the product:
Vertica is a good substitute for enterprise database with all the supports and cross platform leverages.
All Rounder Platform for Data Analytics
What do you like best about the product?
I like the tools and support which Vertica G2 provides. Most importantly I like it as helps in performing analytical operations very efficiently and effectively.
What do you dislike about the product?
I would like them to improve the interface and increase more support with the cloud platformd such as AWS, AZURE and GCP. Also like to see if Vertica G2 can integrate more tools and programming features.
What problems is the product solving and how is that benefiting you?
The major problem is the optimisation and performance tunning which I think Vertica G2 can handle very efficiently. Processing and analysing the non structured data is a major problem I see which Vertica can do it.
showing 11 - 20