--- 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. good analytics tools with cloud support and save cost **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Logistics and Supply Chain | Small-Business (50 or fewer emp.) **Reviewed Date:** July 10, 2022 **What do you like best about Rocket Vertica?** cost saving and cloud support are best about vertica **What do you dislike about Rocket Vertica?** documentation with use cases can be improved **What problems is Rocket Vertica solving and how is that benefiting you?** analytics has help in user engagement and conversion **Official Response from Paige Roberts:** > Thank you for the great review! Much appreciated, Paige ### 2. Nice **Rating:** 4.0/5.0 stars **Reviewed by:** Abubakar K. | Tech Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** April 18, 2022 **What do you like best about Rocket Vertica?** great product while preparing data lake for syatem **What do you dislike about Rocket Vertica?** In strart I found your flow is not great **Recommendations to others considering Rocket Vertica:** Good to go **What problems is Rocket Vertica solving and how is that benefiting you?** save time **Official Response from Paige Roberts:** > Thanks for the review! Cheers, Paige ### 3. There are a lot of opportunities for improvement areas for Vertica **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 06, 2022 **What do you like best about Rocket Vertica?** Performance and architecture. BugData Concepts **What do you dislike about Rocket Vertica?** Slow development and missing functionalities and cloud support **Recommendations to others considering Rocket Vertica:** Na **What problems is Rocket Vertica solving and how is that benefiting you?** Handling Huge data sets **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! I'm not sure which version you're on, but Vertica has had cloud support on all three major clouds for a few years. Contact us to see if the latest version might have the capabilities you're looking for. Cheers, Paige ### 4. Great lab environment **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Government Administration | Small-Business (50 or fewer emp.) **Reviewed Date:** December 05, 2021 **What do you like best about Rocket Vertica?** Exercises were clear and informative, nice to have a possibility to restart modules if needed. Nice to have the 3 node cluster with vertica management console installed. **What do you dislike about Rocket Vertica?** This is a tricky question. I didn't like that in the test, I couldn't see in the summary at the end what questions were wrong because I thought I had everything right (93%). Also, some questions were a bit misleading - for example I think the question was how Vertica stores the data: answer: in projections, but you could argue that in tables as well. I don't remember the question exactly. **What problems is Rocket Vertica solving and how is that benefiting you?** Nothing for now, but I will be assigned to a project where we will be working with a Vertica cluster. ................................................................... ### 5. Long-term leader for big data analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Gregory W. | Database Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** August 25, 2021 **What do you like best about Rocket Vertica?** I most like the breadth of functionality that Vertica offers. For example, analytic lags and deltas and event pattern matching. **What do you dislike about Rocket Vertica?** Whilst the documentation is generally good, I do manage to find and report back mistakes. It can sometimes take a while for these corrections to be incorporated into another documentation release. **What problems is Rocket Vertica solving and how is that benefiting you?** Log analysis and aggregation, complex KPI generation, and sessionisation of data. Using Vertica we have managed to combine data from a large number of sources and query it in one place. ### 6. Fast and Optimized **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Enterprise (> 1000 emp.) **Reviewed Date:** April 22, 2022 **What do you like best about Rocket Vertica?** It takes less space in storing the data and I speed of retrieving the data is quite impressive. **What do you dislike about Rocket Vertica?** It little complicated to use. Setup is also little complicated. **What problems is Rocket Vertica solving and how is that benefiting you?** I am using it for analytical purposes. **Official Response from Paige Roberts:** > Thanks for the review! Cheers, Paige ### 7. Nice experience **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** April 12, 2022 **What do you like best about Rocket Vertica?** Vertica SQL on Hadoop are best in market **What do you dislike about Rocket Vertica?** No do far ..atleast you can try using it and see the automation results **What problems is Rocket Vertica solving and how is that benefiting you?** Its mostly help on complex queries to make easy **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 8. Its very feasible data warehouse and easy to read the data **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** April 12, 2022 **What do you like best about Rocket Vertica?** efficiency of the data fetching from vertica **What do you dislike about Rocket Vertica?** nothing its really good and nothing to dislike **What problems is Rocket Vertica solving and how is that benefiting you?** data format issue will be found then and then its easy to test the data **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 9. Database performance **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** April 11, 2022 **What do you like best about Rocket Vertica?** Fast query performance Columnar Data storage **What do you dislike about Rocket Vertica?** Data size limitations Pricing Limited options for quering clients **Recommendations to others considering Rocket Vertica:** Highly recommended for big data and Hadoop environment **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica clustering Smooth integration with big data **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! I'll pass on your input to the team. Cheers, Paige ### 10. the exam is a little difficult **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Banking | Small-Business (50 or fewer emp.) **Reviewed Date:** March 03, 2022 **What do you like best about Rocket Vertica?** a convenient course with videos and tasks **What do you dislike about Rocket Vertica?** there are no Russian subtitles and voiceovers **What problems is Rocket Vertica solving and how is that benefiting you?** working with MC and a new understanding of SQL **Official Response from Paige Roberts:** > Thanks for taking the time to comment on Vertica Academy. We greatly appreciate it, and I'll pass on your feedback. Cheers, Paige ### 11. FAST AND SCALABLE **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** January 18, 2022 **What do you like best about Rocket Vertica?** The platform is fast. The feature set on the platform help for many use cases **What do you dislike about Rocket Vertica?** I have not encountered any low lights on the platform. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica will help in unifying all the analytics required for an organization ### 12. Data engineer using vertica for database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** July 15, 2021 **What do you like best about Rocket Vertica?** It Column-based analytical functions, this gives us the flexibility to work with massive data, and it makes our query fast and easy. Another point is its k-safety. It saves our data from any node failure **What do you dislike about Rocket Vertica?** If we can say wrong about Vertica, then it's not good. Still, the area where Vertica can update itself is the connector for its clients because when we use Vertica with a new version for spark like 3.0, then it has not better connectivity with Hadoop and spark. We have faced so many issues while connecting our spark application. **What problems is Rocket Vertica solving and how is that benefiting you?** We have created a Business intelligence tool for clients where we have to save massive data and process/query it very fast for a response. I think in this Vertica help's us a lot ### 13. System Architecture Executive Manager **Rating:** 5.0/5.0 stars **Reviewed by:** Dario A. | System Architecture Executive Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** August 23, 2021 **What do you like best about Rocket Vertica?** High performance, high availability, low cost of maintenance **What do you dislike about Rocket Vertica?** It would be nice to have a larger Vertica user community in Brasil **What problems is Rocket Vertica solving and how is that benefiting you?** We are using it as the main big-data repository for the results of the electricity market accounting process in Brasil. The performance provided by the platform allowed us to make data queries in hourly granularity available to our user base over the Internet. ### 14. Good analytics platform **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Internet | Enterprise (> 1000 emp.) **Reviewed Date:** January 14, 2022 **What do you like best about Rocket Vertica?** Ease of use, client centricity, and the customer support **What do you dislike about Rocket Vertica?** This product is still in naive form and needs some improvement **What problems is Rocket Vertica solving and how is that benefiting you?** Managing big data and doing analysis for business purposes **Official Response from Paige Roberts:** > Thanks for taking the time to review. Please, let us know what we can improve. Cheers, Paige ### 15. processing speeds much better than traditional databases ans also easy to setup as well as query **Rating:** 4.5/5.0 stars **Reviewed by:** Akshay B. | Linux System Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** December 11, 2020 **What do you like best about Rocket Vertica?** As we work on servers which receive huge amount of requests per day, integration with vertica for logging all the requests is very efficient as per my perspective. Vertica hds never disappointed ne till now. **What do you dislike about Rocket Vertica?** Databases with big catalog size may takes longer to start, also sometimes you have keep on pressing yes for a prompt while starting big databases **Recommendations to others considering Rocket Vertica:** If your company needs good processing speeds for huge amount of traffic data to be stored Vertica is always a Good to go over the traditional databases. It is easy to setup as well as vertica has a deep documentation how to do it, easy to query, integrate with other applications and use as well **What problems is Rocket Vertica solving and how is that benefiting you?** Processing speed was a major problem which vertica does in seconds,also integrating tradition databases with streaming application s was a pain, which vertica resolved by providing inbuilt schedular. ### 16. Vertica - A Modern Data Analytics platform. **Rating:** 5.0/5.0 stars **Reviewed by:** Waseem P. | Lead Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** February 01, 2021 **What do you like best about Rocket Vertica?** DBD - fabulous Optimization tool. The Training material is excellent, easy to understand and Free. MC, the Vertica UI is good. I would like to see how it performs in truly enterprise environments. ANSI SQL. Perfect choice. Something others like Cassandra, messed up. The most important aspect of Vertica is the underlying technology. Robust and focused on Data analytics. **What do you dislike about Rocket Vertica?** I wont say dislike. I would like to see how security of objects works in detail. Another aspect I would like to understand is how it is setup. I mean I believe the software is setup on shared infrastructure. [or maybe not, need clarity here]. For BFSI and Telecom sector, this is an area of concern. Again, I need to improve my understanding. I have no dislikes. **Recommendations to others considering Rocket Vertica:** If Data Analytics is something you do, give Vertica a look. Its architecture lends extremely well to Analytics. Only the mighty Exadata with a powerful hardware integrated strongly with Oracle RAC is a viable option. If you are on non Oracle cloud platforms, Vertica is easily the best choice for Data. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica is prime solution for Data analytics platform. I believe Vertica is an excellent platform for data analytics. the architecture lends itself extremely well to use Vertica for Data Marts, analytics platform, IoT and maybe even for ML. ### 17. easy analytics for everyone **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** August 24, 2021 **What do you like best about Rocket Vertica?** administrating vertica, extending vertica, ongoing development **What do you dislike about Rocket Vertica?** poor performance on wide tables, missing predicate pushdown for custom source udf, missing ssl support for python udf, slow replication performance on load_snaphot with 10K+ tables in catalog, poor hash join performance comparing with greenplum or clickhouse **What problems is Rocket Vertica solving and how is that benefiting you?** product analytics, ab testing, operational analytics, preparing data for production services (moderation, antifraud, client reporting, ...) ### 18. Robust and Cost effective tool that can prove ROI in shortest time possible **Rating:** 5.0/5.0 stars **Reviewed by:** Syed Asif T. | Sr. Solutions Architect - EDW/BI, Mid-Market (51-1000 emp.) **Reviewed Date:** December 02, 2020 **What do you like best about Rocket Vertica?** Columnar distribution and compression for reduced footprint. MPP for performance and scalability. ANSI compliance makes it easy for change management since users with previous SQL knowledge can move to Vertica easily. Documentation is pretty much clear even video tutorials for users are available which can be a great help. Vertica certification enables users to make more out of Vertica for understanding basic and advanced concepts. **What do you dislike about Rocket Vertica?** Per TB licensing. Users have to worry about license usage at all times which becomes a challenge with you are working in an organization with huge amounts of data. Though buddy projections do not use any license still users tend to create copies of data for the various purpose which in result exhaust license which is a challenge. **Recommendations to others considering Rocket Vertica:** For those who want to validate its ROI, there is a good chance you start small with a minimum number of nodes, and as value realized start building on top of it and scale. Its less expensive than other RDBMS and offer more performance and scalability. The need for specialized is still there which again is not a big problem. We have implemented Vertica at numerous organizations and feedback from users is very positive and even hardcore Oracle and DB2 enthusiasts have recognized significant improvements in the overall solution. **What problems is Rocket Vertica solving and how is that benefiting you?** First of all performance challenges secondly start small with vertical and then scale up. Query execution times are improved using Vertica. The administration is pretty easy since there is a lot of admin stuff maintained by Vertica itself ### 19. Real fast database with horizontal scalability and features like UDx making it more powerful **Rating:** 4.0/5.0 stars **Reviewed by:** Shrijan T. | Associate Solution Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** December 01, 2020 **What do you like best about Rocket Vertica?** Vertica UDx is one of the best capabilities from which you can extend Vertica based on your custom needs, along with this it's integrated environment for ML models is pretty good which brings analytics on plate in just matter of steps. Vertica Eon mode is another best function which provides greater scalability without downtime and even saves the cost. **What do you dislike about Rocket Vertica?** Despite pros con is if you want to bring node up after crash all ip address needs to be same or as an alternative you have to update catalogue (which is generally not recommended) **Recommendations to others considering Rocket Vertica:** If you have analytical workload comprising of realtime and scheduled load and tou need sub second performance, give a try to Vertica as its friendly and cost effective with lot of flexibility and good support. **What problems is Rocket Vertica solving and how is that benefiting you?** Analytical problem for various dashboard and reporting solutions. Major benefit is sub second performance, logging integration with Kafka for real-time data syncing etc. ### 20. Best analytics database in the Market. **Rating:** 4.5/5.0 stars **Reviewed by:** Venkata Krishnam Raju P. | Big Data Vertica DBA at ICICI BANK, HYDERABAD, Enterprise (> 1000 emp.) **Reviewed Date:** April 20, 2021 **What do you like best about Rocket Vertica?** Dustributed computing , analytics functions. And It's continues improvement in the product. ML inside database improvement. **What do you dislike about Rocket Vertica?** In enterprise mode lot of downtime required for node additions and rebalancing of large Database. To avoid this issue, EON mode architecture is suitable. Update and delete statements are minus points in vertica due to these statements delete vectors will create. Lot of these statements will effect negatively on DB performance. **What problems is Rocket Vertica solving and how is that benefiting you?** It reduced lot of ETL jobs and user query runtime. ### 21. Vertica 9 Essentials **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** January 26, 2021 **What do you like best about Rocket Vertica?** I've had a chance to work with Vertica through its evolution from version 2.5.9 to present. The product is able to leverage commodity resources to provide unparalleled performance without loss of stability or data consistency. The engineering and support teams are a privilege to work with and learn from. **What do you dislike about Rocket Vertica?** DDL is blocked during node down events and cluster resizing. I've yet to find a company which does not rely on some form of DDL for regular operations. This limitation mean that despite the database remaining online is effectively a partial outage. **What problems is Rocket Vertica solving and how is that benefiting you?** User Quota's to limit expensive adhoc operations Granular resource pool definitions to ensure process the intended resources available VBR is a wonderful tool ### 22. Vertica Used By Netcore **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** August 24, 2021 **What do you like best about Rocket Vertica?** Speed and Response time, Easy to scale. Able to handle millions of records response in fictions of time. **What do you dislike about Rocket Vertica?** Licensing Module, It Should be Pay As Use. **What problems is Rocket Vertica solving and how is that benefiting you?** Segmentation for the large number of records can be done in seconds. IT Support AWS S3, which saves lots of cost. ### 23. A strong tool for processing BIG Data **Rating:** 4.5/5.0 stars **Reviewed by:** Karthik Murali H. | Data Scientist / Assistant Manager, Enterprise (> 1000 emp.) **Reviewed Date:** November 18, 2020 **What do you like best about Rocket Vertica?** Quick processing time. Faster query handling SQL integration is easy **What do you dislike about Rocket Vertica?** No easy to access community forums Takes time to get answers for queries or issues from the communities Limited client knowledge to get them onboard instead of Hadoop or SQL server. **Recommendations to others considering Rocket Vertica:** If you are in need of a database , but still using outdated technologies like SQL server which can still has its limitation while processing large data sets ( in excess of 10-15 million rows) across 50+ tables, Vertica can be a great tool to process this information and bring out key insights and do analytics on the data. The power of analaytics is only as good as how fast you can process the data and how quick the results come in . **What problems is Rocket Vertica solving and how is that benefiting you?** Social Media analytics with Sentiment analysis Processing data that is >10 million rows is quicker in Vertica and aggregation of granular data ### 24. vertica is fast and supports SQL reducing learning curve **Rating:** 4.0/5.0 stars **Reviewed by:** Babu R. | Senior Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** December 07, 2020 **What do you like best about Rocket Vertica?** 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 Rocket Vertica?** 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. **Recommendations to others considering Rocket Vertica:** 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. **What problems is Rocket Vertica 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. ### 25. Vertica: Present and future relevance **Rating:** 4.0/5.0 stars **Reviewed by:** Animesh S. | Senior System Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 29, 2020 **What do you like best about Rocket Vertica?** 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 Rocket Vertica?** 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. **Recommendations to others considering Rocket Vertica:** Vertica for Reporting **What problems is Rocket Vertica 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. ### 26. Robust tool for Data Analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Neetu Y. | Sr Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** December 08, 2020 **What do you like best about Rocket Vertica?** Vertica is user friendly to use to fetch data from DB and query run is fast. Also, it is nice tool to handle and fetch large data. It is very useful tool for retail and ecommerce industry which has data in billions. **What do you dislike about Rocket Vertica?** Not any dislike about but in my experience in analytics, vertica is best tool i used to get data using SQL. **Recommendations to others considering Rocket Vertica:** best tool i used to fetch data in billions. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica is very useful to get data using SQL for business which we can use to get reports and insights for top management to take good decision. ### 27. Excellent MPP system for Analytics **Rating:** 4.0/5.0 stars **Reviewed by:** Jeetendra M. | Manager - Strategy & Deployment GLOBAL PLAN Analytics, Small-Business (50 or fewer emp.) **Reviewed Date:** December 09, 2020 **What do you like best about Rocket Vertica?** Very easy installation. Robust architecture to store and process terabytes of data very quickly **What do you dislike about Rocket Vertica?** When it comes to GUI based system management it isn't efficient. Also currency is an issue. **Recommendations to others considering Rocket Vertica:** Consider it for Data mart type of applications where you need to do specific analytics based out of Teradata bytes of data. **What problems is Rocket Vertica solving and how is that benefiting you?** We were working on analytical reporting based on very large number of records, which could not be done using other databases. But with Vertica we could get the results pretty fast for business to make timely decisions. Storing and retrieving data is super efficient. ### 28. Vertica review **Rating:** 4.5/5.0 stars **Reviewed by:** Vandana B. | Technology Lead, Enterprise (> 1000 emp.) **Reviewed Date:** December 02, 2020 **What do you like best about Rocket Vertica?** It's extremely helpful for fast querying on the reporting side involving TBs of data. We had migrated same data to newer streaming dbs which did not perform as well for the large data. It's easy to learn and implement - uncluttered and simple ! System tables are easy to read to understand underlying workings. **What do you dislike about Rocket Vertica?** Tuning is developer centric. Which means performance heavily depends on the developers decisions and knowledge. Conditional Updates not possible for alrge datasets - db crashes **Recommendations to others considering Rocket Vertica:** Awesome for sub second performance for huge datasets. **What problems is Rocket Vertica solving and how is that benefiting you?** Sub second performance benchmark are met and nice integration with dashboards ### 29. If you have bulk Data to process and heavy processing load then vertica is a good choice. **Rating:** 4.0/5.0 stars **Reviewed by:** Bipulsingh K. | Associate - Data Science & Analytics, Enterprise (> 1000 emp.) **Reviewed Date:** December 03, 2020 **What do you like best about Rocket Vertica?** we have machine learning and NLP work, I like the most about is I can do much Regular expression and Data cleaning directly in Vertica. We can create our own function which is most helpful thing. **What do you dislike about Rocket Vertica?** For simple crud operation with some joins query could be faster. **Recommendations to others considering Rocket Vertica:** If you are looking for ETL solution then give a chance to Vertica. Performance is good and maximize performance for work related to big data. **What problems is Rocket Vertica solving and how is that benefiting you?** Regular expression at Vertica level I personally used the most for my profesional work. And our team is using it work various machine learning work. ### 30. Very fast and scalable analytical RDBMS. **Rating:** 4.5/5.0 stars **Reviewed by:** Maja P. | Mid-Market (51-1000 emp.) **Reviewed Date:** August 17, 2020 **What do you like best about Rocket Vertica?** Vertica is fast analytical distributed DBMS. This kind of architecture, which enables parallel processing, gives scalability through concurrent loading and querying data while also ensuring data availability in case of node failure. Also, it uses advanced encoding and compression structures which ensure saving storage space - significant feature in the world of data warehouse. Personally, I consider that the best feature Vertica provide is it's completeness , which gives the user many possibilities through in-database developed funcionallities, and integration with other systems and tools, the different ones regarding loading data as well as the ones using data for analytics. **What do you dislike about Rocket Vertica?** Regarding of memory consumption during query execution, Vertica requires substantial amount of prior techical knowledge to write memory-optimized queries. This includes knowledge about Vertica specifics, i.e. projections, encoding, resource pools. On the other side, when one improves his technical expertise, Vertica is by far the best choice of analytical database. **Recommendations to others considering Rocket Vertica:** Vertica is excellent when company has huge amounts of data, concurrent loading streams and extended needs for data visualisation and reporting. When learning more about tehnical concept and structures, one sees all the more possibilities this DBMS offers for the support of various bussiness cases. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica helped us solved the problem of loading vast amounts of data through ETL tools because it enabled us to create concurrent loading streams thanks to it's distributed architecture. Also, Vertica in a very easy manner, enables integration not only with ETL tools, but also with visualization or tools regarding streaming data. ### 31. A great tool, if you are database person **Rating:** 4.5/5.0 stars **Reviewed by:** Martin I. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 30, 2021 **What do you like best about Rocket Vertica?** The setup of the environment, preloaded parts, gui of the tool **What do you dislike about Rocket Vertica?** Some of the questions are more about exact values in the data rather than teoretical. **What problems is Rocket Vertica solving and how is that benefiting you?** I was doing the certification exam only ### 32. World class OLAP database, Great support team **Rating:** 4.0/5.0 stars **Reviewed by:** Dhaval B. | Assistant Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** December 01, 2020 **What do you like best about Rocket Vertica?** Projections feature and rich analytical functions are something I really liked and solved multiple problems **What do you dislike about Rocket Vertica?** No inbuilt Encryption feature, would have better if encryption could be enabled easily **Recommendations to others considering Rocket Vertica:** Good warehousing DB for most of your analytics workload **What problems is Rocket Vertica solving and how is that benefiting you?** Building Analytical Dashboard and reporting modules on over huge volume of data ### 33. Vertica is one of the most incredible database system to use for data warehousing. **Rating:** 5.0/5.0 stars **Reviewed by:** Muhammad Omer A. | ETL/BI Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 15, 2020 **What do you like best about Rocket Vertica?** The columnar approach and storage of data in projections to quickly access the data most frequently queried. **What do you dislike about Rocket Vertica?** The limitation of manually clearing up ROS containers when a query is interrupted (due to network issues) and needs to run again. **Recommendations to others considering Rocket Vertica:** Do go through the documentation. Everything is there if you want to know anything. **What problems is Rocket Vertica solving and how is that benefiting you?** I'm using vertica for Data warehousing for Business Intelligence. The quick data fetching and response time, the query optimization, the data storage and compression are some of the fine things and benefits of using vertica. ### 34. Genuine review for Vertica users **Rating:** 3.5/5.0 stars **Reviewed by:** Anshuman S. | Advance Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 27, 2020 **What do you like best about Rocket Vertica?** 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 Rocket Vertica?** It's little bit costly compared to other Db. **Recommendations to others considering Rocket Vertica:** I can recommend to other users if they want quick output but their budget should also be high. **What problems is Rocket Vertica 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. ### 35. Vertica the high performance DB **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Enterprise (> 1000 emp.) **Reviewed Date:** December 03, 2020 **What do you like best about Rocket Vertica?** It's performance, scalability and it's ease of use.Its reduced data storage is another great feature. It is IO optimized DB **What do you dislike about Rocket Vertica?** Pricing, supporting procedure would be a good option.Deletion is slower in vertica **Recommendations to others considering Rocket Vertica:** Please go ahead with vertica as it is one of the best DB for analytics.A POC will help in judging it's advantages **What problems is Rocket Vertica solving and how is that benefiting you?** It helped in our huge volume and query performance issue which was a pain in traditional DB ### 36. Engineering & Technology Leader work with data for results driven outcome **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** November 17, 2020 **What do you like best about Rocket Vertica?** Vertica is good for both structured and unstructured data mining, however, I find the performance is on the lower side when I evaluated. **What do you dislike about Rocket Vertica?** The pricing is heavy in comparison to the rest of the available options in the industry. However it assures the SLA that I've seen it affordable. **What problems is Rocket Vertica solving and how is that benefiting you?** We were trying to evaluate the big-data of Patent data globally that we want to aggregate, ingest, mine for inference, and be able to search the big-data along with the Marklogic. I've seen Vertica was beneficial with the prototype that I was able to quickly demonstrate and use. However, the pricing was a bit let down to us during this recommendation. ### 37. Vertica certification review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** March 23, 2021 **What do you like best about Rocket Vertica?** Very insightful and learner-oriented videos. Excellent slides. **What do you dislike about Rocket Vertica?** Sometimes the questions in knowledge checks were too technical and narrowed down to just finding the output of the code on the screen. I'd rather have more conceptual questions. **What problems is Rocket Vertica solving and how is that benefiting you?** I have gained a mass of new skills in database designing. ### 38. Strange to see every time query output time was exactly same **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 27, 2020 **What do you like best about Rocket Vertica?** 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. **What do you dislike about Rocket Vertica?** Not easy to write procedure or scripts on vertica **Recommendations to others considering Rocket Vertica:** If you want the fast computation time and looking for a data base who can go with any technology.go for Vertica **What problems is Rocket Vertica 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. ### 39. Great product, sometimes a little slow for processing **Rating:** 4.5/5.0 stars **Reviewed by:** Diego Alberto F. | Analytics & Insights Manager - Uber. Enablement Programs, LATAM Community Ops, Enterprise (> 1000 emp.) **Reviewed Date:** November 16, 2020 **What do you like best about Rocket Vertica?** I like the easiness to write in vertica’s SQL language. It’s very intuitive and easy to understand. **What do you dislike about Rocket Vertica?** In my experience the processing time was long sometimes. The queries were running but taking to much and failing due to insufficient resources. **Recommendations to others considering Rocket Vertica:** Be aware of how efficient your queries are before running them. **What problems is Rocket Vertica solving and how is that benefiting you?** Data Queries mostly. It helped me for summarizing big sets of data into transformed and ready to use data outcomes ### 40. Good Columnar database for OLAP **Rating:** 3.5/5.0 stars **Reviewed by:** Salman K. | Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2020 **What do you like best about Rocket Vertica?** 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 **What do you dislike about Rocket Vertica?** bit complex to learn, there are too many new concept as compare to traditional RDBMS **What problems is Rocket Vertica solving and how is that benefiting you?** We are using vertica for implementing OLAP data warehousing system, I love Flex table feature of vertica ### 41. Its fast , scalable , Data science ready , Most advanced Database ever made. **Rating:** 5.0/5.0 stars **Reviewed by:** ROHIT V. | Associate Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 19, 2020 **What do you like best about Rocket Vertica?** Compression , encoding , K safety , 24x7 data loads , Fast , scalable , Machine learning , language support **What do you dislike about Rocket Vertica?** Very less Learning resources to learn Vertica. **Recommendations to others considering Rocket Vertica:** I must say it is awesome database , it can fulfill all your need. Vertica is the future for Data processing. **What problems is Rocket Vertica solving and how is that benefiting you?** We are using it in Business intelligence , Data science , to Store and Process the data and get insights. ### 42. Review on Vertica Technology **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 21, 2020 **What do you like best about Rocket Vertica?** The best about Vertica is it has 99.99% availability and 100% consistency. It has got powerful tools like Vertica Backup and Restore utility which helps recover single table or schema or cluster from past backup images. The most admirable is its K Safe Feature due to which it helps maintain the consistency among the nodes. If a node goes down it does automatic sync as well. It also has Database Designer which will help you tune your SQLs and suggest optimized projections. To add icing to the case it has management console its GUI interface as well which helps you monitor multiple clusters using the same GUI . It has got nice online support as well in case of issues. The incidents of cluster down specifically to the projects I support had gone down 100% . If one node goes down still due to Ksafe feature your entire cluster remains up and available to the business. Over all on personal grounds a very reliable and useful products that any Organization can rely on. Note : This is my genuine personal opinion only for the product I have worked hence the candid feedback. **What do you dislike about Rocket Vertica?** About its upgrade path and just supporting 1 release backward compatibility if you upgrade your cluster. Also cross environment restores for the cluster having different names but same nodes restores should be made possible that are having different names. So entire snap can be restored. Note : This is my genuine personal opinion only for the product I have worked hence the candid feedback. **Recommendations to others considering Rocket Vertica:** Over all a good product worth it for the money you spent. **What problems is Rocket Vertica solving and how is that benefiting you?** 100% cluster availability issue is resolved. Maintenance down time is reduced. Also business functions are executing per expectations. ### 43. Modernizing EDW **Rating:** 4.0/5.0 stars **Reviewed by:** Sanjay S. | Architect, Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2020 **What do you like best about Rocket Vertica?** Its performance, scalability, integration, easy integration with big data environment. Vertica is capable to support streaming data and able to ingest data stream at low latency. **What do you dislike about Rocket Vertica?** Its data size limitation, pricing is high with large data size. **Recommendations to others considering Rocket Vertica:** Vertica a columnar database is excellent db for certain use cases. **What problems is Rocket Vertica solving and how is that benefiting you?** Able to ingest high volume/streamed Call Detail Record(CDR), in telecom domain. ### 44. Vertica review **Rating:** 5.0/5.0 stars **Reviewed by:** Divya S. | Sr Big data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 08, 2020 **What do you like best about Rocket Vertica?** Analytics functions and query time are good **What do you dislike about Rocket Vertica?** More complex computations like hive can be improved **What problems is Rocket Vertica solving and how is that benefiting you?** Query time optimisation ### 45. Columnar storage datawarehouse on cloud **Rating:** 5.0/5.0 stars **Reviewed by:** Sheetal C. | Senior Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** November 25, 2020 **What do you like best about Rocket Vertica?** MPP architecture columnar compression high performance **What do you dislike about Rocket Vertica?** Data size limitations high pricing limited options for querying clients **What problems is Rocket Vertica solving and how is that benefiting you?** Data warehouse, backend for BI and Analytical tools ### 46. Vertica Database is Easy to understand AS RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** December 06, 2020 **What do you like best about Rocket Vertica?** 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 Rocket Vertica?** lack of HIgh concurrency, Vertica can improve in with its concurrency transaction. **Recommendations to others considering Rocket Vertica:** 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. **What problems is Rocket Vertica solving and how is that benefiting you?** since its transaction happen in memory, its way faster than RDBMS DB. ### 47. Fast and scalable database for enterprise data warehousing **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** November 30, 2020 **What do you like best about Rocket Vertica?** 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 **What do you dislike about Rocket Vertica?** Expensive and few resources to learn more about the product apart from few tech blogs and the documentation comes from Vertica **What problems is Rocket Vertica solving and how is that benefiting you?** Banking domain, we were using for generating customer reporting for business users ### 48. Database is very optimized easy to use and integrate **Rating:** 5.0/5.0 stars **Reviewed by:** Pankaj M. | Mid-Market (51-1000 emp.) **Reviewed Date:** December 03, 2020 **What do you like best about Rocket Vertica?** 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 Rocket Vertica?** it does not support stored procedures so we have to write explicit functions in code **What problems is Rocket Vertica solving and how is that benefiting you?** pulling and doing calculations on big amount of data is the very big benefit we are getting ### 49. Vertica Pros COns **Rating:** 4.0/5.0 stars **Reviewed by:** Rajat A. | Technical Associate Architect | Owner | Manager Big Data, Enterprise (> 1000 emp.) **Reviewed Date:** December 01, 2020 **What do you like best about Rocket Vertica?** Good:- Vertica is column fast database for analytical purpose Vertica easy to install Vertica has support **What do you dislike about Rocket Vertica?** It needs maintaince Experts are not easily available **What problems is Rocket Vertica solving and how is that benefiting you?** move entire Business Intelligence system 300 reports from Oracle to Vertica it was fast 5sec SLA it was easily maintainable it has integration with almost all reporting system and ETLs ### 50. Performance **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2021 **What do you like best about Rocket Vertica?** The peer nodes in a Cluster and distribution of query from the requester to executer **What do you dislike about Rocket Vertica?** Interactive - should be more GUI interactive **What problems is Rocket Vertica solving and how is that benefiting you?** query planning, performance tuning ## 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=3§ion=pricing&secure%5Bexpires_at%5D=2026-08-07+08%3A35%3A44+-0500&secure%5Bsession_id%5D=c04e18da-6e53-450f-9cce-046944345b9b&secure%5Btoken%5D=751f1a8a90cac04988e6fc683cddcf46396f3922e8186908f2bc1c8e08113101&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 - Generative AI **Additional Functionality** - Parallel Processing - Ad hoc Analysis - Multiple Data Sources - API - In-Database Processing - Monitoring - Real-Time Reporting - Data Synchronization - Real-Time Monitoring - Data Connectors - Performance Metrics - Ad hoc Reporting - Alerts/Notifications - Access Controls/Permissions - Drag & Drop - Data Visualization - Data Import/Export - Match & Merge - Data Transformation - Secure Data Storage - Data Extraction - AI Copilot - Customizable Reports - Activity Dashboard - Data Migration - In-Memory Processing - Data Mapping **Building Reports** - Data Transformation - Data Modeling - WYSIWYG Report Design - Integration APIs - Real-Time Data - Real-Time Data - Third-Party Integrations **Platform** - Mobile User Support - Customization - User, Role, and Access Management - Internationalization - Sandbox / Test Environments - Performance and Reliability - Breadth of Partner Applications - Mobile Access - Metadata Management ## 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 (713 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (371 reviews)