Vertica by the Hour, Red Hat
OpenTextExternal reviews
210 reviews
from
and
External reviews are not included in the AWS star rating for the product.
I worked in Vertica almost more than 6years. I found it was good analytical DB.
What do you like best about the product?
Columnar DB, concepts of Projection, Continued availablity,flextable etc.
What do you dislike about the product?
Updates seems to be slow. We used to follow delete and under concepts.
What problems is the product solving and how is that benefiting you?
We did technology transfer from legacy application to new technology, and used Vertica for Trasfermation for data warehousing
Fast and scalable database for enterprise data warehousing
What do you like best about the product?
It’s the best database in terms of loading the huge chunks of transactional data and it’s very fast in doing so. It’s availability and consistency is good compared to other databases in the market right now. Due to Ksafe feature, data is almost every time available for the users.
This is my personal view on the database version I worked on
This is my personal view on the database version I worked on
What do you dislike about the product?
Expensive and few resources to learn more about the product apart from few tech blogs and the documentation comes from Vertica
What problems is the product solving and how is that benefiting you?
Banking domain, we were using for generating customer reporting for business users
Vertica: Present and future relevance
What do you like best about the product?
The speed, Vertica is very fast to use and easily compatible with SQL Workbench tool which helps development , testing , debugging very easy. The columnar structure is the optimum solution for reporting. It is one of the fastest MPPs to work on.
What do you dislike about the product?
The updates are a show stopper in Vertica, they are very costly.
The Projections and order by clause for better resource utilization are not hasslefree.
MemSQL provides a better solution.
The Projections and order by clause for better resource utilization are not hasslefree.
MemSQL provides a better solution.
What problems is the product solving and how is that benefiting you?
Vertica is an advantage on Teradata and Oracle, it is much faster and reporting to iPhone apps works like a charm. The projection provide an easy way to optimize without changing the base tables and thus increases scalability.
Recommendations to others considering the product:
Vertica for Reporting
Genuine review for Vertica users
What do you like best about the product?
I like it most because it's different from all other regular database. It's a columnar database while others are row based. So searching is easy if DB size is very huge.
What do you dislike about the product?
It's little bit costly compared to other Db.
What problems is the product solving and how is that benefiting you?
I was using it for data mining. We were using mostly for creating report. It was very quick.
Recommendations to others considering the product:
I can recommend to other users if they want quick output but their budget should also be high.
Strange to see every time query output time was exactly same
What do you like best about the product?
Fast omputation time.
Very fast to retrieve the output of the query submitted.
Logical representation of the column database.
Good database at the presentation layer for reporting projects.
Very fast to retrieve the output of the query submitted.
Logical representation of the column database.
Good database at the presentation layer for reporting projects.
What do you dislike about the product?
Not easy to write procedure or scripts on vertica
What problems is the product solving and how is that benefiting you?
It helps us to replace Teradata as database over the presentation layer for reporting to users.
Very fast in computation and almost same data retrieval time which is hard to see in Teradata helps us to move to Vertica for the reporting layer for over project.
Very fast in computation and almost same data retrieval time which is hard to see in Teradata helps us to move to Vertica for the reporting layer for over project.
Recommendations to others considering the product:
If you want the fast computation time and looking for a data base who can go with any technology.go for Vertica
I've been working with vertica for 5 years already. very happy.
What do you like best about the product?
very powerfully , fast , scalable database
What do you dislike about the product?
sometimes it is overkill for small systems.
Pooling is not always makes the difference
Pooling is not always makes the difference
What problems is the product solving and how is that benefiting you?
we are using it as production db and DWH. It performs good for those porpuse.
Recommendations to others considering the product:
sure
Columnar storage datawarehouse on cloud
What do you like best about the product?
MPP architecture
columnar compression
high performance
columnar compression
high performance
What do you dislike about the product?
Data size limitations
high pricing
limited options for querying clients
high pricing
limited options for querying clients
What problems is the product solving and how is that benefiting you?
Data warehouse, backend for BI and Analytical tools
Vertical Great Performance
What do you like best about the product?
Data loading is faster.vertics supports big data
What do you dislike about the product?
Performance wise slow.it can't support in memory operations
What problems is the product solving and how is that benefiting you?
Data Analytics 1M dollars saved
Recommendations to others considering the product:
Use it to handle billions of data
Vertica is a powerful tool for Data ware house technology. I have been working nearly 2 years.
What do you like best about the product?
Performance and robust. Excellent clustering technology if one of the nodes crashes automatically it will regenerate a new node.
What do you dislike about the product?
I would say there is nothing we can say dislike and this is a wonderful product for DW.
What problems is the product solving and how is that benefiting you?
Mostly this has backup issues other than that I never faced any issue.
this is very fast DB, good column compression and since it's SQL it is relatively essay to use
What do you like best about the product?
fast aggregation for bid data
no downtime when you add new column to existing large table
good compression
good function documentation
no downtime when you add new column to existing large table
good compression
good function documentation
What do you dislike about the product?
some time the optimiser is not good it may select to not the best way to get the data, and this is not that simple to improve the query.
join with large table are slow
join with large table are slow
What problems is the product solving and how is that benefiting you?
analytic aggregation over very big tables
showing 161 - 170