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.
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
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
Fast and Optimized
What do you like best about the product?
It takes less space in storing the data and I speed of retrieving the data is quite impressive.
What do you dislike about the product?
It little complicated to use. Setup is also little complicated.
What problems is the product solving and how is that benefiting you?
I am using it for analytical purposes.
Nice
What do you like best about the product?
great product while preparing data lake for syatem
What do you dislike about the product?
In strart I found your flow is not great
What problems is the product solving and how is that benefiting you?
save time
Recommendations to others considering the product:
Good to go
Its very feasible data warehouse and easy to read the data
What do you like best about the product?
efficiency of the data fetching from vertica
What do you dislike about the product?
nothing its really good and nothing to dislike
What problems is the product solving and how is that benefiting you?
data format issue will be found then and then its easy to test the data
Nice experience
What do you like best about the product?
Vertica SQL on Hadoop are best in market
What do you dislike about the product?
No do far ..atleast you can try using it and see the automation results
What problems is the product solving and how is that benefiting you?
Its mostly help on complex queries to make easy
Database performance
What do you like best about the product?
Fast query performance
Columnar Data storage
Columnar Data storage
What do you dislike about the product?
Data size limitations
Pricing
Limited options for quering clients
Pricing
Limited options for quering clients
What problems is the product solving and how is that benefiting you?
Vertica clustering
Smooth integration with big data
Smooth integration with big data
Recommendations to others considering the product:
Highly recommended for big data and Hadoop environment
Amazing Product
What do you like best about the product?
Vertica offers flexibility to work on huge datasets and makes querying super fast.
What do you dislike about the product?
The product needs development on the wide tables performance.
What problems is the product solving and how is that benefiting you?
Performing retro analysis for client reporting. Adhoc analysis. Query execution time lapse are improved.
the exam is a little difficult
What do you like best about the product?
a convenient course with videos and tasks
What do you dislike about the product?
there are no Russian subtitles and voiceovers
What problems is the product solving and how is that benefiting you?
working with MC and a new understanding of SQL
showing 61 - 70