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.
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
Vertica Database is Easy to understand AS RDBMS
What do you like best about the product?
Since it is columnar database, its different from RDBMS and its saving data as column fashion, so while reading data instead of reading row, it will read column and it will be faster while giving less IO on Disk
What do you dislike about the product?
lack of HIgh concurrency, Vertica can improve in with its concurrency transaction.
What problems is the product solving and how is that benefiting you?
since its transaction happen in memory, its way faster than RDBMS DB.
Recommendations to others considering the product:
Since Vertica is the in memory columnar Database, read transaction for milion data fetch will be faster than Other RDBMS DB, mostly people will use this DB for productbase business.
My Views on Vertica
What do you like best about the product?
Performance and data reliability along with ease of architecture
What do you dislike about the product?
while using on premise, extending or limiting to size and maintaining cleanups was bit hectic
What problems is the product solving and how is that benefiting you?
analysis and data to information.
aggregates, snowflake architecture
aggregates, snowflake architecture
Recommendations to others considering the product:
If someone wants high performance and much more analytical functions then one should go for vertica
Complete Value for money
What do you like best about the product?
Supports a super fast information retrieval.
What do you dislike about the product?
The GUI is a bit old fashioned. Can be implemented in a good manner.
What problems is the product solving and how is that benefiting you?
Analysis and monitoring of applications.
Fast and Easy to Use
What do you like best about the product?
Query Execution Speed, Best Database for Transaction System
What do you dislike about the product?
Can't Write Store Procedure and Function
What problems is the product solving and how is that benefiting you?
Store huge amount of transactional data in shorts of time. Best benefits is projection
Recommendations to others considering the product:
Add PL/SQL functionality
Database is very optimized easy to use and integrate
What do you like best about the product?
sql queries runs very fast and it will give you very quick results when you are dealing with huge amount of data
What do you dislike about the product?
it does not support stored procedures so we have to write explicit functions in code
What problems is the product solving and how is that benefiting you?
pulling and doing calculations on big amount of data is the very big benefit we are getting
showing 141 - 150