---
title: Rocket Vertica Reviews
meta_title: 'Rocket Vertica Reviews 2026: Details, Pricing, & Features | G2'
meta_description: Filter 216 reviews by the users' company size, role or industry
  to find out how Rocket Vertica works for a business like yours.
aggregate_rating:
  rating_value: 4.3
  review_count: 216
  scale: '5'
date_modified: '2026-08-04'
parent_category:
  name: IT Infrastructure
  url: https://www.g2.com/categories/it-infrastructure
---

# Rocket Vertica Reviews
**Vendor:** Rocket Software  
**Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse)  
**Average Rating:** 4.3/5.0  
**Total Reviews:** 216
## About Rocket Vertica
Vertica is the unified analytics platform, based on a massively scalable architecture with a broad set of analytical functions spanning event and time series, pattern matching, geospatial, and built-in machine learning capability. Vertica enables data analytics teams to easily apply these powerful functions to large and demanding analytical workloads, arming them and their customers with predictive business insights. Vertica provides a unified analytics platform across major public clouds and on-premises data centers, and integrates data in cloud object storage and HDFS without forcing any data movement. Available as a SaaS option, or as a customer-managed platform, Vertica helps teams combine growing data siloes for a more complete view of available data. Vertica features separation of compute and storage, so teams can spin up storage and compute resources as needed, then spin down afterwards to reduce costs.




## Rocket Vertica Reviews
  ### 1. Vertica as a Analytical DB

**Rating:** 5.0/5.0 stars

**Reviewed by:** Ashrumochan B. | Senior Data Engineer, Enterprise (> 1000 emp.)

**Reviewed Date:** December 02, 2020

**What do you like best about Rocket Vertica?**

Aggregation works better then traditional rdbms.

**What do you dislike about Rocket Vertica?**

Architecture is changing frequently. They need to stick to ine perticular architecture.

**Recommendations to others considering Rocket Vertica:**

If you are very much sure about your use cases and will have very clean data set.
You can proceed with using Vertica

**What problems is Rocket Vertica solving and how is that benefiting you?**

Data warehouse and analytical reporting

  ### 2. Interesting and powerful database

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** December 16, 2020

**What do you like best about Rocket Vertica?**

Simplicity while using, stability. EON mode is something very useful especially when talking big data.

**What do you dislike about Rocket Vertica?**

Query sometimes lock tables and then it is necessary to use console to end queries. But this also can be a query tool problem.

**Recommendations to others considering Rocket Vertica:**

Very fast and reliable. Try it and you wont regret it.

**What problems is Rocket Vertica solving and how is that benefiting you?**

I am working with data warehouse tools and Vertica is working much faster than our previous database. So I can say it is DWH frendly tool.

  ### 3. One of the best analytical DBs I've used

**Rating:** 5.0/5.0 stars

**Reviewed by:** Ivan P. | Enterprise (> 1000 emp.)

**Reviewed Date:** December 23, 2020

**What do you like best about Rocket Vertica?**

Speed, reliability, well-written documentstion

**What do you dislike about Rocket Vertica?**

I can't recall anything I disliked, therefore I'll say none

**Recommendations to others considering Rocket Vertica:**

It's fast, it's good, it well-documented. Use it.

**What problems is Rocket Vertica solving and how is that benefiting you?**

KPI calculations, preparing data for dashboards and business reviews

  ### 4. I worked in Vertica almost more than 6years. I found it was good analytical DB.

**Rating:** 4.0/5.0 stars

**Reviewed by:** Veerabhadrappa A. | Team Lead, Enterprise (> 1000 emp.)

**Reviewed Date:** December 01, 2020

**What do you like best about Rocket Vertica?**

Columnar DB, concepts of Projection, Continued availablity,flextable etc.

**What do you dislike about Rocket Vertica?**

Updates seems to be slow. We used to follow delete and under concepts.

**What problems is Rocket Vertica 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

  ### 5. Wonderful experience with the scalable data warehouse

**Rating:** 4.0/5.0 stars

**Reviewed by:** Ujjwal Kumar G. | Enterprise (> 1000 emp.)

**Reviewed Date:** August 24, 2020

**What do you like best about Rocket Vertica?**

Elasticity, Use of S3 as the storage, simple to use interface for monitoring and management.

**What do you dislike about Rocket Vertica?**

Lack of in-built load balancing for vertical cluster.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Querying large amount of data quickly and effectively by multiple users simultaneously.

  ### 6. I've been working with vertica for 5 years already. very happy.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 26, 2020

**What do you like best about Rocket Vertica?**

very powerfully , fast , scalable database

**What do you dislike about Rocket Vertica?**

sometimes it is overkill for small systems.
Pooling is not always makes the difference

**Recommendations to others considering Rocket Vertica:**

sure

**What problems is Rocket Vertica solving and how is that benefiting you?**

we are using it as production db and DWH. It performs good for those porpuse.

  ### 7. Great Db experience

**Rating:** 5.0/5.0 stars

**Reviewed by:** Prabhjot K. | Python Automation Engineer, Enterprise (> 1000 emp.)

**Reviewed Date:** December 21, 2020

**What do you like best about Rocket Vertica?**

column orientation: Data is stored in form of columns rather than rows.

**What do you dislike about Rocket Vertica?**

Deletion is tough in Vertica esp in large tables.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Fast query Performance

  ### 8. Vertica review

**Rating:** 5.0/5.0 stars

**Reviewed by:** GURJIT S. | Engineering Manager, Enterprise (> 1000 emp.)

**Reviewed Date:** December 03, 2020

**What do you like best about Rocket Vertica?**

Columnar access to database. Fetch records fastly then row based

**What do you dislike about Rocket Vertica?**

Only accessible on servers. Would like to see it in UI.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Dat files to vertica database and then access to SAS

  ### 9. Experience to worked with vertica cluster database and administration with the glassbeam product.

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** December 06, 2020

**What do you like best about Rocket Vertica?**

I like this product due to simplicity but powerful and easily scalable features in it

**What do you dislike about Rocket Vertica?**

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 .

**Recommendations to others considering Rocket Vertica:**

Definitely great product for Big Data application

**What problems is Rocket Vertica solving and how is that benefiting you?**

Used for storage realtime analytics data with very high volumn

  ### 10. Complete Value for money

**Rating:** 4.5/5.0 stars

**Reviewed by:** Piyush K. | Program Associate A, Enterprise (> 1000 emp.)

**Reviewed Date:** December 05, 2020

**What do you like best about Rocket Vertica?**

Supports a super fast information retrieval.

**What do you dislike about Rocket Vertica?**

The GUI is a bit old fashioned. Can be implemented in a good manner.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Analysis and monitoring of applications.

  ### 11. Vertica review

**Rating:** 4.5/5.0 stars

**Reviewed by:** Archana M. | Data Engineer, Mid-Market (51-1000 emp.)

**Reviewed Date:** November 19, 2020

**What do you like best about Rocket Vertica?**

Vertica 's kafka and spark connectors
Connectors are really nice

**What do you dislike about Rocket Vertica?**

Gets expensive with huge amount of data
Thus pricing is one of the reason

**What problems is Rocket Vertica solving and how is that benefiting you?**

Banking field especially in fraud detection

  ### 12. Vertica for enterprise data warehouse

**Rating:** 4.5/5.0 stars

**Reviewed by:** Robert R. | Senior Data Management Consultant, Mid-Market (51-1000 emp.)

**Reviewed Date:** March 19, 2020

**What do you like best about Rocket Vertica?**

Super fast when queries are optimized. Excellent support.

**What do you dislike about Rocket Vertica?**

You must take care for lot of details for optimized use.

**Recommendations to others considering Rocket Vertica:**

Vertica is one of best analytics databases.

**What problems is Rocket Vertica solving and how is that benefiting you?**

We integrated data from various transaction systems and Vertica made it possible on very efficient way. It has very good integration with Informatica Power center as etl tool and with IBM Cognos and Tableau as reporting tools.
Vertica has excellent support and you can always find lot of resources on their web site. 

I would recommend for data warehouse database if you have lot of data and many parallel users. It has very good user management for managing database resources across users in organisation. It also allows integration with active directory.

It has lot of embedded analytic functions but if it is needed you can build your own functions using Python or other programming languages.

It is scalable so if your data grows you can easily extent storage and processing power.

  ### 13. Vertica is very good in case of huge transactions. We can easily manage vertica servers.

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Semiconductors | Enterprise (> 1000 emp.)

**Reviewed Date:** November 18, 2020

**What do you like best about Rocket Vertica?**

Environment is too good. The way to design the vertica architecture is awesome and we can easily get the health of vertica systems.

**What do you dislike about Rocket Vertica?**

If any disasters, recovery is bit slow. I have observed only one issue, nothing else.

**Recommendations to others considering Rocket Vertica:**

Yes, I can recommend to use vertica product

**What problems is Rocket Vertica solving and how is that benefiting you?**

I have recovered vertica servers many times.  Main benifit is monitoring is too good compare to other big data solutions

  ### 14. Powerful and convenient analytical db

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.)

**Reviewed Date:** January 28, 2021

**What do you like best about Rocket Vertica?**

Query performance on big data sets are great

**What do you dislike about Rocket Vertica?**

The transition between different size of clusters is a pain in the ass

**What problems is Rocket Vertica solving and how is that benefiting you?**

Store and process efficiently big scale of analytical data.

  ### 15. Solution Architect

**Rating:** 2.5/5.0 stars

**Reviewed by:** Verified User in Electrical/Electronic Manufacturing | Enterprise (> 1000 emp.)

**Reviewed Date:** November 17, 2020

**What do you like best about Rocket Vertica?**

Columnar store is both retrieval and storage makes it scalable and good for large set of Data.

**What do you dislike about Rocket Vertica?**

We do not have a IDE where we can view the Structure which would be user friendly

**What problems is Rocket Vertica solving and how is that benefiting you?**

We were able to store huge data and it allowed us to extend same set of data with multi columns from multiple site. It helped us in consolidating and retrieving data.

  ### 16. this is very fast DB, good column compression and since it's SQL it is relatively essay to use

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 22, 2020

**What do you like best about Rocket Vertica?**

fast aggregation for bid data
no downtime when you add new column to existing large table
good compression 
good function documentation

**What do you dislike about Rocket Vertica?**

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

**What problems is Rocket Vertica solving and how is that benefiting you?**

analytic  aggregation over very big tables

  ### 17. Vertica analytics platform

**Rating:** 3.5/5.0 stars

**Reviewed by:** Mohit P. | Senior Data Engineer, Mid-Market (51-1000 emp.)

**Reviewed Date:** November 16, 2020

**What do you like best about Rocket Vertica?**

The computation power and the SQL parser

**What do you dislike about Rocket Vertica?**

Cloud support is not upto the mark as other competitors

**What problems is Rocket Vertica solving and how is that benefiting you?**

An analytics platform  which help in making business decision

  ### 18. Very robust and production ready database option

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.)

**Reviewed Date:** November 13, 2020

**What do you like best about Rocket Vertica?**

The lightweight compared with other similar databases in the market

**What do you dislike about Rocket Vertica?**

Nothing in particular. I think is a very nice product with required capabilities in place

**Recommendations to others considering Rocket Vertica:**

Is a very good database for data lakes and business intelligence  in general. More over if you compre with standard relation databases

**What problems is Rocket Vertica solving and how is that benefiting you?**

Create a proper data lake on prem. Main benefits around speed and performance obtained

  ### 19. Vertica with external table on aws s3

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.)

**Reviewed Date:** December 08, 2020

**What do you like best about Rocket Vertica?**

Vertica projection improved the microstrategy reporting by a huge margin. 

Vertica with aws s3 helped us to leverage 
the elasticity and power of cloud along with the traditional powerful rdbms capabilities.

**What do you dislike about Rocket Vertica?**

Projections some time creates problem while deployments.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Developing a traditional datamart using data stored on aws s3

  ### 20. My Views on Vertica

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.)

**Reviewed Date:** December 06, 2020

**What do you like best about Rocket Vertica?**

Performance and data reliability along with ease of architecture

**What do you dislike about Rocket Vertica?**

while using on premise, extending or limiting to size and maintaining cleanups was bit hectic

**Recommendations to others considering Rocket Vertica:**

If someone wants high performance and much more analytical functions then one should go for vertica

**What problems is Rocket Vertica solving and how is that benefiting you?**

analysis and data to information.
aggregates, snowflake architecture

  ### 21. Speed and Low cost

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.)

**Reviewed Date:** November 19, 2020

**What do you like best about Rocket Vertica?**

Speed of queries and the low cost of ownership.able to take real time streaming data without much preprocessing latency.

**What do you dislike about Rocket Vertica?**

The management console including GUI is lacking features.

**What problems is Rocket Vertica solving and how is that benefiting you?**

We have been at the forefront of digitisation transformation. As collection distribution and using data is critical for us.we have developed a single converged platform to help clients transition.

  ### 22. its a robust Db

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.)

**Reviewed Date:** January 05, 2021

**What do you like best about Rocket Vertica?**

its robust and very fast and works best with large databse

**What do you dislike about Rocket Vertica?**

less supported and not much technical communities

**Recommendations to others considering Rocket Vertica:**

Good for robust Database

**What problems is Rocket Vertica solving and how is that benefiting you?**

its help moving things faster and querying faster

  ### 23. Vertica is good as analytics storage, but open-source Clickhouse took its place on the market

**Rating:** 2.5/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** December 07, 2020

**What do you like best about Rocket Vertica?**

That it works out of the box and goes with cluster support & management tools

**What do you dislike about Rocket Vertica?**

It's price. It's too expensive. And Clickhouse works faster right now for the same purposes

**What problems is Rocket Vertica solving and how is that benefiting you?**

Classical OLAP data storage. The projections concept was pretty nice. Management tools as well

  ### 24. Vertica amazing product and exciting toolset for DW and Analystics platform

**Rating:** 5.0/5.0 stars

**Reviewed by:** Raghav A. | Vertica DBAConsultant, Enterprise (> 1000 emp.)

**Reviewed Date:** August 16, 2020

**What do you like best about Rocket Vertica?**

Troubleshooting on vertica platform is quite easy and it provides very detailed information as well about the insights what vertica is doing inside its database.

Tools and functions available to perform Analytics and handle Warehouse tasks are good.

**What do you dislike about Rocket Vertica?**

Internal debugging documentation is one area which needs improvement

**What problems is Rocket Vertica solving and how is that benefiting you?**

We use vertica for Store once and read more. Mostly helpful for warehousing tasks

  ### 25. Vertica is a powerful tool for Data ware house technology. I have been working nearly 2 years.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.)

**Reviewed Date:** November 23, 2020

**What do you like best about Rocket Vertica?**

Performance and robust. Excellent clustering technology if one of the nodes crashes automatically it will regenerate a new node.

**What do you dislike about Rocket Vertica?**

I would say there is nothing we can say dislike and this is a wonderful product for DW.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Mostly this has backup issues other than that I never faced any issue.

  ### 26. Superb experience

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.)

**Reviewed Date:** December 06, 2020

**What do you like best about Rocket Vertica?**

Speed performance, user friendly. Very innovative way of handling complex data

**What do you dislike about Rocket Vertica?**

No cons till now. Mainly users UI TO BE improved

**Recommendations to others considering Rocket Vertica:**

Superb database

**What problems is Rocket Vertica solving and how is that benefiting you?**

Procurement domain and banking domain. Trillions of data rows with complex business logivs

  ### 27. Analysis tool for SQL engine

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** December 10, 2020

**What do you like best about Rocket Vertica?**

It's analytics of data as well as Parallel processing SQL engine

**What do you dislike about Rocket Vertica?**

Nothing for dislike every part is amazing

**What problems is Rocket Vertica solving and how is that benefiting you?**

Fast access as well as Parallel processing SQL base Engine.fast processing

  ### 28. Great technology for compact data storage, real time processing and optimal performance.

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.)

**Reviewed Date:** January 06, 2021

**What do you like best about Rocket Vertica?**

Columnar storage, projections, Documentation.

**What do you dislike about Rocket Vertica?**

support, lack of community and stability.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Business usecase, historical data analysis.

  ### 29. Fast and Easy to Use

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** December 04, 2020

**What do you like best about Rocket Vertica?**

Query Execution Speed, Best Database for Transaction System

**What do you dislike about Rocket Vertica?**

Can't Write Store Procedure and Function

**Recommendations to others considering Rocket Vertica:**

Add PL/SQL functionality

**What problems is Rocket Vertica solving and how is that benefiting you?**

Store huge amount of transactional data in shorts of time. Best benefits is projection

  ### 30. It's really a very good data platform fir data warehouse house

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** December 07, 2020

**What do you like best about Rocket Vertica?**

Data storage and data management is superb.

**What do you dislike about Rocket Vertica?**

Indexing can be improved and memory also can be taken care

**Recommendations to others considering Rocket Vertica:**

Yes highly recommend

**What problems is Rocket Vertica solving and how is that benefiting you?**

Lots of data analysis done at my end

  ### 31. Great analytical database, great performance.

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 21, 2020

**What do you like best about Rocket Vertica?**

I like performance and volume of data it hold.

**What do you dislike about Rocket Vertica?**

Node goes down or crashes in occasions and need manual intervention.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Using as Analytical database to store data in fact and dimensions tables for reporting purposes.

  ### 32. Smooth data management but could be better.

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Leisure, Travel & Tourism | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 20, 2020

**What do you like best about Rocket Vertica?**

It makes ETL pipeline integration easier. Provides data security and faster data preparation.

**What do you dislike about Rocket Vertica?**

Data size limitation and pretty expensive when dealing with large datasets.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Faster query execution and better data management

  ### 33. Vertical Great Performance

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.)

**Reviewed Date:** November 23, 2020

**What do you like best about Rocket Vertica?**

Data loading is faster.vertics supports big data

**What do you dislike about Rocket Vertica?**

Performance wise slow.it can't support in memory operations

**Recommendations to others considering Rocket Vertica:**

Use it to handle billions of data

**What problems is Rocket Vertica solving and how is that benefiting you?**

Data Analytics 1M dollars saved

  ### 34. Good things are being done

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** December 02, 2020

**What do you like best about Rocket Vertica?**

Good work, excellent commitment, humanitarian will

**What do you dislike about Rocket Vertica?**

Not much of it seems fine let's see how it goes

**What problems is Rocket Vertica solving and how is that benefiting you?**

Pretty good computational problems

  ### 35. A Good Columnar DB solution for analytics needs

**Rating:** 4.0/5.0 stars

**Reviewed by:** Jitender T. | Enterprise (> 1000 emp.)

**Reviewed Date:** August 21, 2020

**What do you like best about Rocket Vertica?**

Columnar storage, Various inbuilt optimization and performance improvement techniques.

**What do you dislike about Rocket Vertica?**

Support for complex data types isn't too mature.

**Recommendations to others considering Rocket Vertica:**

Good columnar DB solution with optimized reads and performance improvement capabilities for queries.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Analytics and reporting needs.

  ### 36. Great

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.)

**Reviewed Date:** November 13, 2020

**What do you like best about Rocket Vertica?**

the visualisation features are the best.

**What do you dislike about Rocket Vertica?**

Nothing as such, I did not find thing is concerning

**Recommendations to others considering Rocket Vertica:**

All good

**What problems is Rocket Vertica solving and how is that benefiting you?**

Sales channel optimisation

  ### 37. Best DB for OLAP

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.)

**Reviewed Date:** November 12, 2020

**What do you like best about Rocket Vertica?**

Performance, columnar features, transaction

**What do you dislike about Rocket Vertica?**

Most of the industry moving towards clouds,it will be great you guys can asap

**What problems is Rocket Vertica solving and how is that benefiting you?**

OLAP application

  ### 38. Great product!

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Retail | Small-Business (50 or fewer emp.)

**Reviewed Date:** August 12, 2020

**What do you like best about Rocket Vertica?**

Administration and Management, flexible scalability, variety of data types.

**What do you dislike about Rocket Vertica?**

Nothing comes to mind. It looks very good overall.

**Recommendations to others considering Rocket Vertica:**

Great product!

**What problems is Rocket Vertica solving and how is that benefiting you?**

It addresses pretty much all; structured and no-structured data. It has high scalability and all kind of connectors.

  ### 39. Likelihood to Recommend

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.)

**Reviewed Date:** August 13, 2020

**What do you like best about Rocket Vertica?**

It's Columnar  and It's Analytical functions.

**What do you dislike about Rocket Vertica?**

I Hate to manage it at Projection level.

**What problems is Rocket Vertica solving and how is that benefiting you?**

I am managing a DWH and analytical reports on DWH. It has very good speed and beautiful data management functions.

  ### 40. From dark data into the ligh

**Rating:** 5.0/5.0 stars

**Reviewed by:** Eva D. | Senior Manager, Data Analytics & Insights, Mid-Market (51-1000 emp.)

**Reviewed Date:** October 01, 2019

**What do you like best about Rocket Vertica?**

Ease of deployment and maintenance.  Database performance on terabytes of data right out of the box.

**What do you dislike about Rocket Vertica?**

It would have been nice if we could have integrated with our LDAP environment.  Permissions on DDL functions were difficult to hand out as those were locked to the DB owner.

**Recommendations to others considering Rocket Vertica:**

Try it!  Get the free trial.  It is worth it.

**What problems is Rocket Vertica solving and how is that benefiting you?**

The data was too large to be able to have any real insights into.  We tried other columnar data stores and HDFS sorts of stores.  With those we spent a lot of time trying to get data with no results.  We stood up Vertica and all our data was available, clustered, highly available.  We were able to gain insights within moments and continue to grow that.

  ### 41. Vertica is the most obvious choice for on-premise data warehousing

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Internet | Enterprise (> 1000 emp.)

**Reviewed Date:** March 15, 2019

**What do you like best about Rocket Vertica?**

We've tested and tested and benchmarked and benchmarked and every time Vertica comes out ahead against competing technologies (OSS or proprietary) in terms of raw throughput and concurrency handling.  We've even seen it rival highly optimized in-memory analytics engines for latency under certain scenarios.  This makes it the obvious choice for us for any sort of general OLAP or dashboarding task.

**What do you dislike about Rocket Vertica?**

We tend to push Vertica pretty hard and have a tendency to automate everything (we use chef for provisioning), which means we have had to write our own tools or adapt Verticas' to our purposes fairly substantially.  This is no deal breaker, but it would be nice if they invested more time in the admin UX.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Vertica is our core analytic database offering and as such is central part of the compute fabric.  The fact that it is so efficient and flexible in this regard means that we leverage it behind many applications, limiting tech sprawl and allowing us to go to market faster and with fewer support staff.

  ### 42. Powerful, efficient, fast SQL Database

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.)

**Reviewed Date:** March 06, 2019

**What do you like best about Rocket Vertica?**

Using and querying Vertica was extremely simple, and easy to learn. Vertica allowed me to visualize datasets in new and interesting ways and, if necessary, apply statistical calculations to my datasets. Vertica allowed our company to scale billions of rows of data easily as well which gave our company the technical infrastructure necessary to grow.

**What do you dislike about Rocket Vertica?**

Environments to query Vertica required a bit of extra setup and configuration, it was not as turnkey as other SQL databases, and sometimes connections would get lost; however, shelling into Vertica was just as effective if outputting datasets was the core goal.

**Recommendations to others considering Rocket Vertica:**

If you will be rebuilding Vertica datasets at any regular cadence, ensure ETL processes are ironclad as data rebuilds across large sets of data can cause significant shifts which can take a long time to complete.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Vertica stored almost all the data that our company collected for its clients. I worked with Vertica to obtain any sort of records about my clients and whatever activity we collected for them and used that data for any number of purposes from implementation, QA, and reporting.

  ### 43. Great performance, reasonable cost and low maintenance.

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.)

**Reviewed Date:** April 30, 2019

**What do you like best about Rocket Vertica?**

I like the fact that is mostly low maintenance with great performance with a good set of features.

**What do you dislike about Rocket Vertica?**

At times the designer generated incremental design causes issues.

**Recommendations to others considering Rocket Vertica:**

Definitely give it a try if you are looking for a good data warehouse that can scale with your business needs. I highly recommend the product.

**What problems is Rocket Vertica solving and how is that benefiting you?**

We use Vertica for all the reporting and analytics needs. We also use it for some large application queries and it performs reasonably well under a lot of different scenarios.

  ### 44. Vertica Big Data

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Gambling & Casinos | Mid-Market (51-1000 emp.)

**Reviewed Date:** May 03, 2019

**What do you like best about Rocket Vertica?**

Vertica is a analytical database 100% ANSI SQL that performs very well for large tables. Data load is incredibly fast and it is very easy to operate. 

**What do you dislike about Rocket Vertica?**

Updates are slow because columnar architecture, but you can replace with delete-insert. 

**What problems is Rocket Vertica solving and how is that benefiting you?**

We use Vertica as traditional Data Warehouse and Big Data experiences. 

  ### 45. Powerful technology, Query speed

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.)

**Reviewed Date:** March 05, 2019

**What do you like best about Rocket Vertica?**

Query speed, Vertica analyze and respond in a record time New features that have been developed, such as Machine Learning and branching

We initially chose Vertica because of its superior performance and query speed, but we now realize there is so much more we can do. Vertica’s machine learning capabilities will help us analyze network performance, predict capacity constraints, and ensure the best quality service to our customers 

**What do you dislike about Rocket Vertica?**

So far we have no inconvniniece with the product, this means there is nothing to dislike about

**Recommendations to others considering Rocket Vertica:**

Ask for a demo (POC) and evaluate the improvements and speed

**What problems is Rocket Vertica solving and how is that benefiting you?**

Vertica delivers drastically improved performance for regulatory compliance and enables an eighty-five percent reduction in fraudrelated costs vs last year

  ### 46. Vertica enables Cerner's Big Data Analytics

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.)

**Reviewed Date:** February 28, 2019

**What do you like best about Rocket Vertica?**

We are inserting 1B rows per hour now.  This data is easily consumed by a mixed mode of users.  It has enabled Cerner to conduct deep analytics across all of our technical stacks resulting in reduced client incidents.

**What do you dislike about Rocket Vertica?**

Hard to perform backups.  If user pools are not continuously evaluated and monitored, large queries can bring the database to its knees.  Still have not perfected a single node out situation.  A single node out has put us into a downtime.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Full analytics and visibility across our technical platforms.  We have been able to do predictive fingerprinting and monitoring/auditing off of our data.  We have approximately 1.1 PB of operational data used across multiple organizations.

  ### 47. Fantastic Analytical Tool

**Rating:** 5.0/5.0 stars

**Reviewed by:** Emon H. | Senior Product Manager, Enterprise (> 1000 emp.)

**Reviewed Date:** March 06, 2019

**What do you like best about Rocket Vertica?**

Ease of use, performance, Return on Investment, Machine Learning and Analytics capabilities

**What do you dislike about Rocket Vertica?**

We've been very happy with Vertica since we started using 6 years ago, no there is nothing to dislike

**Recommendations to others considering Rocket Vertica:**

Vertica offers a lot of support for their prospective customers to try out all the important features before buying. I'll suggest anyone considering to buy to use that opportunity.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Building next generation telco analytics toolsets

  ### 48. Vertica Rocks

**Rating:** 4.5/5.0 stars

**Reviewed by:** Ben W. | Sr DB Architect, Mid-Market (51-1000 emp.)

**Reviewed Date:** March 06, 2019

**What do you like best about Rocket Vertica?**

The ability to optimize for load and query performance.
The community support is unparalleled.

**What do you dislike about Rocket Vertica?**

The default optimizations are mostly useless and don't seem to 'know' the underlying data.

**Recommendations to others considering Rocket Vertica:**

If you are serious about big data, use Vertica

**What problems is Rocket Vertica solving and how is that benefiting you?**

Speed and scale - plain and simple
I am solving the problem of database as a service for an enterprise application.

  ### 49. Scalable, high-speed database on commodity hardware

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.)

**Reviewed Date:** March 04, 2019

**What do you like best about Rocket Vertica?**

The ability to grow a database in either compute or storage with commodity hardware is very valuable. No other database comes to mind for speed of inserts or selects at this scale.

**What do you dislike about Rocket Vertica?**

The documentation has improved over the years but there is less information than some competitors. There aren't as many users of this database products compared to others so the community is somewhat lacking.

**What problems is Rocket Vertica solving and how is that benefiting you?**

Vertica solves the problem of storing petabytes worth of data while actually being able to join across datasets in a timely manner. This allows for discoveries that couldn't be made otherwise.

  ### 50. Blazing speed Big Data on Commodity hardware

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.)

**Reviewed Date:** April 30, 2019

**What do you like best about Rocket Vertica?**

Rapid responses, ability to handle large volumes of data, scalable and works on commodity hardware

**What do you dislike about Rocket Vertica?**

Not ideal for high velocity transactions

**What problems is Rocket Vertica solving and how is that benefiting you?**

Analytics solutions to Physician and Payer organizations. No need for a full time DBA to support a Big Data solution. 


## Rocket Vertica Discussions
  - [What offerings are there to run it in AWS cloud?](https://www.g2.com/discussions/what-offerings-are-there-to-run-it-in-aws-cloud) - 1 comment, 1 upvote
  - [need to check](https://www.g2.com/discussions/36279-need-to-check) - 1 comment, 1 upvote
  - [More and more technical documentation should be available for](https://www.g2.com/discussions/34471-more-and-more-technical-documentation-should-be-available-for) - 1 comment, 1 upvote
  - [How do I learn advanced methods and tuning of queries for free by vertica official](https://www.g2.com/discussions/34344-how-do-i-learn-advanced-methods-and-tuning-of-queries-for-free-by-vertica-official) - 1 comment, 1 upvote
  - [Is it hard to learn to be a Vertica user? Admin?](https://www.g2.com/discussions/user-friendly) - 2 comments, 1 upvote

- [View Rocket Vertica pricing details and edition comparison](https://www.g2.com/products/rocket-vertica/reviews?page=4&section=pricing&secure%5Bexpires_at%5D=2026-08-04+10%3A36%3A41+-0500&secure%5Bsession_id%5D=55a6de66-339b-448a-817b-d524e5a49cdd&secure%5Btoken%5D=7bb8f836457949d6fd1850a35e00d8c8133fa92bb712bade556d965c01ed00d2&format=llm_user)

## Rocket Vertica Features
**Data Management**
- Data Integration
- Data Compression
- Data Quality
- Built-In Data Analytics
- In-Database Machine Learning
- Data Lake Analytics

**Storage**
- Data Model
- Data Types

**Database**
- Real-Time Data Collection
- Data Distribution
- Data Lake

**Integration**
- AI/ ML Integration
- BI Tool Integration
- Data lake Integration

**Availability**
- Auto Sharding
- Auto Recovery
- Data Replication

**Integrations**
- Hadoop Integration
- Spark Integration

**Deployment**
- On-Premise
- Cloud

**Performance**
- Integrated Cache

**Platform**
- Machine Scaling
- Data Preparation
- Spark Integration

**Performance **
- Scalability

**Security**
- Role-Based Authorization
- Authentication
- Audit Logs
- Encryption

**Processing**
- Cloud Processing
- Workload Processing

**Security**
- Data Governance
- Data Security

**Support**
- Multi-Model
- Operating Systems

**Generative AI**
- AI Text Generation
- AI Text Summarization

**Building Reports**
- Data Transformation
- Data Modeling
- WYSIWYG Report Design
- Integration APIs

**Platform**
- Mobile User Support
- Customization 
- User, Role, and Access Management
- Internationalization
- Sandbox / Test Environments
- Performance and Reliability
- Breadth of Partner Applications

## Top Rocket Vertica Alternatives
  - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,144 reviews)
  - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (712 reviews)
  - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (371 reviews)

