--- 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-07-18' 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. Easy Query and fast retrieval **Rating:** 4.0/5.0 stars **Reviewed by:** Janaki J. | Director of Business Operations, Mid-Market (51-1000 emp.) **Reviewed Date:** November 03, 2022 **What do you like best about Rocket Vertica?** I have been using Vertica for storing massive healthcare data and doing analytics and querying fast **What do you dislike about Rocket Vertica?** May be the licence part and maintaining the clusters **What problems is Rocket Vertica solving and how is that benefiting you?** Data recovery and retrieval is so much easy with Vertica. Clustered approach helps the data backup of ensures there is no loss oof data **Official Response from Paige Roberts:** > Thank you for taking the time to write a review! Much appreciated, Paige ### 2. Vertica Review **Rating:** 4.0/5.0 stars **Reviewed by:** Ferdinand G. | Senior Data Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** November 14, 2022 **What do you like best about Rocket Vertica?** Vertica is very versatile in Database Management in Big Data and OLAP. **What do you dislike about Rocket Vertica?** Vertica is only available now for AWS architecture which needs to reach other platforms. **What problems is Rocket Vertica solving and how is that benefiting you?** Since we are using Big Data, fast access to data is necessary, which Vertica can support. **Official Response from Paige Roberts:** > Hi Ferdinand, Thanks for the review! Vertica deploys pretty much anywhere, on-prem, on any cloud, containerized, or even private clouds. I assume you mean our SaaS version, Vertica Accelerator, since it is just on Amazon cloud right now. I'll pass your comments to our PM team to let them know you'd like to see it on more clouds. Cheers, Paige ### 3. Demanding but great course **Rating:** 5.0/5.0 stars **Reviewed by:** Paul M. | Data Engineering, Enterprise (> 1000 emp.) **Reviewed Date:** May 01, 2022 **What do you like best about Rocket Vertica?** This is a comprehensive review of the essential knowledge you need to understand the more fundamental concepts in Vertica. It reviews from hardware to administration. **What do you dislike about Rocket Vertica?** The workspace was not properly configured, thus I had to reconfigure some network parameters (node names) while doing the configuration file in the backup module. Sometimes, the course is slow-paced, especially in the hands-on labs. **What problems is Rocket Vertica solving and how is that benefiting you?** Three businesses that belong to the firm I work on have Vertica as their main database storage system. The infrastructure is designed to work in development and production environments. Of those three businesses, only one has been able to fully deploy into production and that was possible only through Vertica. This is especially relevant because Vertica has full integration capabilities with BI tools like Tableau and is the only way to show data to executive users **Official Response from Paige Roberts:** > Thanks for taking the time to write a thoughtful review on Vertica and the Vertica Academy courses at academy.vertica.com Cheers, Paige ### 4. Reviewing Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** Amir M. | Senior Solutions Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2022 **What do you like best about Rocket Vertica?** Vertica is a analytics database which stores and processes large volume of data. Since it is a data warehouse platform, you do not need to worry about the physical design and can start using it for analytics. **What do you dislike about Rocket Vertica?** Vertica is not a nosql database so you need to review your use cases and the type of data you would be processing with Vertica before you start using itfor your workloads **What problems is Rocket Vertica solving and how is that benefiting you?** It is being used for data warehousing to store and process workloads for analytics which in turn helps different teams with reports and data insights to amke critical decisions **Official Response from Paige Roberts:** > Thank you for taking the time to write a review! Cheers, Paige ### 5. A good, versatile analytics data wh in the current market **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 15, 2022 **What do you like best about Rocket Vertica?** It is faster, cheaper, and reliable. It also supports heavy ETL and BI queries to subsecond Api processes. It can also integrate with other products to encrypt sensitive data. **What do you dislike about Rocket Vertica?** The scalability is there but not fast enough. It should scale faster than the current timing, need to improve efficiency. **What problems is Rocket Vertica solving and how is that benefiting you?** It helps projecting data easier and make you see it from different point of view. It definitely makes user more prodcutibe. BI performance has seen improvement. **Official Response from Paige Roberts:** > Thanks for the review! Really appreciate you taking the time. Cheers, Paige ### 6. Good data analytics tool with great capabilities **Rating:** 4.0/5.0 stars **Reviewed by:** Nandakumar G. | DevOps Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** November 17, 2022 **What do you like best about Rocket Vertica?** On-prem and cloud deployment flexibility **What do you dislike about Rocket Vertica?** client support is missing for rust and some major components can be opensourced **What problems is Rocket Vertica solving and how is that benefiting you?** data analytics, which is important for our business purpose to get proper insights from large volume of data. ### 7. Vertica is good tool if you are looking for managed analytical database with low Ops. **Rating:** 3.5/5.0 stars **Reviewed by:** sabarish k. | Application Development Associate, Enterprise (> 1000 emp.) **Reviewed Date:** November 18, 2022 **What do you like best about Rocket Vertica?** Easy to deploy both on-prem and on cloud. **What do you dislike about Rocket Vertica?** High concurrency could be managed better. **What problems is Rocket Vertica solving and how is that benefiting you?** We have a large amount of warehouse data using Vertica we can quickly convert massive amounts of data into insights. **Official Response from Paige Roberts:** > Thank you for the review! Really appreciate you taking the time. Cheers, Paige ### 8. It is a data platform used for multiple purposes **Rating:** 4.5/5.0 stars **Reviewed by:** Megha Y. | Scrum master, Mid-Market (51-1000 emp.) **Reviewed Date:** July 09, 2022 **What do you like best about Rocket Vertica?** It's is usually best to be used for ETL and ELT. This is the best in market tool of its kind, it can also connect to various sources via it's connectors of different options **What do you dislike about Rocket Vertica?** Vertica can be made more flexible interms of its cost and management of infrastructure so customer have more options to costomise in much more flexible way..... **Recommendations to others considering Rocket Vertica:** It's one shop stop for all your analytics needs **What problems is Rocket Vertica solving and how is that benefiting you?** It is used to make centralised repository to build unified data platform. As it is vercitile in connecting to multiple data sources both file system and data bases **Official Response from Paige Roberts:** > Thank you so much for the nice review! Much appreciated, Paige ### 9. Vertica is best in class in it's domain of providing both world class products and services **Rating:** 5.0/5.0 stars **Reviewed by:** Neelakanta P. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 05, 2022 **What do you like best about Rocket Vertica?** Vertica is not just a database, it is a best in class analytical platform as well and is powerful enough to store huge data from big data platforms in a single unified platform **What do you dislike about Rocket Vertica?** Vertica can host it's more services as our offering, also as SAS cloud service. Also can make their cost model more flexible so customer can have more liberty to chose as per necessity **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica is mainly used for both typical ETL and ELT use cases. It helped in pulling data from and migrating from On-premise storage systems and also helped in building unified data platform **Official Response from Paige Roberts:** > Thank for taking the time to review! Much appreciated, Paige ### 10. Vertica review **Rating:** 5.0/5.0 stars **Reviewed by:** Kapil J. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2022 **What do you like best about Rocket Vertica?** Vertica is best suited for the realtime dataware house queries. The adtech industry mostly rely on the vertica as it is most user friendly and fast enough data processing engine. **What do you dislike about Rocket Vertica?** There nothing about about the vertica you will dislike. The only improvement vertica can do is it can improve the non relational data storage design as compared to druid. **What problems is Rocket Vertica solving and how is that benefiting you?** Here in admaxim we are using vertica as a main revenue calculator tool. Daily we are generating scheduled report for n number of publishers as well ass DSPs vertica db. **Official Response from Paige Roberts:** > Thank you so much for the great review! Much appreciated, Paige ### 11. Column oriented SQL database, superb for data warehouse and analytics. **Rating:** 4.0/5.0 stars **Reviewed by:** Abdul R. | Associate Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** July 07, 2022 **What do you like best about Rocket Vertica?** Fast for aggregate queries, best for data analytics. **What do you dislike about Rocket Vertica?** Not enough performance for plain queries like select etc. Update query performance in worst, but delete/insert better than update **Recommendations to others considering Rocket Vertica:** Fast for aggregate queries, best for data analytics. Update query performance in worst, but delete/insert better is than update. **What problems is Rocket Vertica solving and how is that benefiting you?** Update performance in worst, but delete/insert better than update script. **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! Much appreciated, Paige ### 12. Data Engineering using Vertica for 5 years **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** December 22, 2020 **What do you like best about Rocket Vertica?** It is a great solution for massive data warehouse application building. **What do you dislike about Rocket Vertica?** It is very costly and was not cool with multiple users accessing it at once. **Recommendations to others considering Rocket Vertica:** Use it for computation and processing but do not expose to it transactional users **What problems is Rocket Vertica solving and how is that benefiting you?** Our data warehouse was based on Vertica. Its parallel processing and thus query execution is quite good. **Official Response from Paige Roberts:** > Thanks for the review! Cheers, Paige ### 13. Excellent tool for big data analysis **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Logistics and Supply Chain | Mid-Market (51-1000 emp.) **Reviewed Date:** November 18, 2022 **What do you like best about Rocket Vertica?** I like the Geospatial analysis and time series analysis more relevant to my work and they helped me get the right analysis. **What do you dislike about Rocket Vertica?** pricing can be improved for individual contributors as well. **What problems is Rocket Vertica solving and how is that benefiting you?** I work in the Geospatial domain so to analyze large amounts of Geo data I find Vertica more suitable than competitors. **Official Response from Paige Roberts:** > Thank you for the wonderful review! Glad the geospatial analytics is working for you. Cheers, Paige ### 14. I have more than 1 year of experience in bigdata and data warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** Nikita K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Rocket Vertica?** Vertica is the fastest data warehousing service. It also provides real time data analytics and many big data solutions. It is one of the most secure ETL service provider. **What do you dislike about Rocket Vertica?** Vertica is not as much flexible to cloud providers as other data warehousing services. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica has helped in my organization for solving major big data problems. We can process billons of rows of data on real time basis. It also helps in real time data analysis. **Official Response from Paige Roberts:** > Thank you for taking the time to write a review! Much appreciated, Paige ### 15. Vertica as a columnar database is good and efficient candidate for massive parellel processing **Rating:** 4.5/5.0 stars **Reviewed by:** Rajaram R. | Senior Manager - Supply Chain Analytics, Enterprise (> 1000 emp.) **Reviewed Date:** July 18, 2022 **What do you like best about Rocket Vertica?** Ease of use and its ability to be flexible. Syntax are similar to that of SQL and most of post processing queries can be run effortlessly. **What do you dislike about Rocket Vertica?** Commercialising a good product is not upto the mark. Forums are not very active and for some basic queries support can be improved **What problems is Rocket Vertica solving and how is that benefiting you?** Simplifies ELT and superfast in loading and copying data from one schema/table to another. Process flow and performance helps to run complex queries easily **Official Response from Paige Roberts:** > Thanks for the great review! Much appreciated, Paige ### 16. The best analytics platform for various purposes which can handle very large data with ease. **Rating:** 4.5/5.0 stars **Reviewed by:** Arunesh T. | Lead Assistant Manager, Enterprise (> 1000 emp.) **Reviewed Date:** July 18, 2022 **What do you like best about Rocket Vertica?** Features of the Vertica services, can be used on-premise as well as on the cloud, robustness, scalability, performance and handling large data with ease. **What do you dislike about Rocket Vertica?** It is overall very good but there is scope for improvement in maintenance, and integration with other tools and sometimes gives a sluggish response. **What problems is Rocket Vertica solving and how is that benefiting you?** We are using Vertica for business analytics and used for taking multiple decisions across organizations in different verticals by using Vertica business analytics results. **Official Response from Paige Roberts:** > Thank you so much for taking the time to write a review! We really appreciate it. Cheers, Paige ### 17. Vertica is a powerful and must have tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** November 14, 2022 **What do you like best about Rocket Vertica?** Large-scale data handling, custom queries, and dealing with unstructured data. **What do you dislike about Rocket Vertica?** Spark Connector. Also , SAAS version of vertica should be available on Azure. **What problems is Rocket Vertica solving and how is that benefiting you?** We are storing 20TB of data on vertical . Vertica is our data lake and all the data is stored for reporting , ML and analytics purpose. **Official Response from Paige Roberts:** > Thank you for the review! I'll pass on your comments to our PM team. Cheers, Paige ### 18. I have 3 years of experience in bigdata and data warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** Trupti A. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Rocket Vertica?** Vertica is the fastest ETL service provider and real-time data delivery provider. It also provides best data quality after compression and data analysis on datasets. **What do you dislike about Rocket Vertica?** Vertica is not much compatible with cloud service providers and it is difficult to set up as compared with other datawarehousing services. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica is helping in my organization for real-time data capturing and Faster ETL transactions. It is also helping for in memory data analytics and customisation. **Official Response from Paige Roberts:** > Thank you for the great review! Cheers, Paige ### 19. Product with great capabilities **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** February 01, 2022 **What do you like best about Rocket Vertica?** We use Vertica as our primary data warehouse solution across different operations. It's very reliable in terms of performance and maintenance. We like the Eon Mode concept, which gives you an advantage on scaling, switching between On-Prem and Cloud. So far, vertica has been a good solution for us, and we look forward to exploring other inbuilt features such as ML and trying Vertica to be a part of On-Prem data lake. **What do you dislike about Rocket Vertica?** The price could be better, significantly when you purchase licenses based on TB. the product can also be improved by having a user interface to manage the connections, resources, etc. **Recommendations to others considering Rocket Vertica:** I would recommend Vertica for people looking for Analytical DWH. Given that it's a columar database, the query performance is impressive and can also be used for real-time integration. It also has features to separate computing from storage ability to scale up significantly. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica has been our primary data warehouse solution. Data from multiple source systems and of different types get processed into DWH. It is then transformed into data marts and used by other platforms like BI, CVM, and CRM. **Official Response from Paige Roberts:** > Thank you so much for the detailed review! I'll pass on your feedback. Thanks again, Paige ### 20. It is useful when we use it for processing minimal amount of data and not supports few DB functions **Rating:** 2.5/5.0 stars **Reviewed by:** SenthilNathan N. | Senior Project Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 15, 2022 **What do you like best about Rocket Vertica?** It is easy to access and user friendly. Query execution time and analysis will be very faster when compared to other RDBMS. **What do you dislike about Rocket Vertica?** It Will not handle huge amount data and slow down the performance due to data size limitations. **What problems is Rocket Vertica solving and how is that benefiting you?** We are using Vertica to store temporary data and it process it very quickly. So it reduces execution time of our process **Official Response from Paige Roberts:** > Hi SenthilNathan, Thank you for taking the time to write a review. Vertica is famous for having over 650 built-in functions, more than any other database on the market, all the standard SQL functions plus geospatial, time series, event pattern matching, text analytics, and machine learning functions. These are in every version of Vertica, even the free Community Edition. We also have customers using Vertica for petabyte level data sets, both on the cloud and on-prem. If you're running into problems in these areas, give our support folks a call. We can help you get more out of the software. Cheers, Paige ### 21. Data engineer **Rating:** 4.0/5.0 stars **Reviewed by:** Sandeep s. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 18, 2022 **What do you like best about Rocket Vertica?** High availability, parallel processing. As well as it's provides sharding/segmentation of data across nodes **What do you dislike about Rocket Vertica?** Nothing much to say, i liked the product and it is really awesome and best data base for big data storage **What problems is Rocket Vertica solving and how is that benefiting you?** It stores data in highly compressed and optimized columinar format, this gives incredible performance and also its uses ANSI standard SQL to perform operations. **Official Response from Paige Roberts:** > Thanks for the great review! Appreciate you taking the time. Cheers, Paige ### 22. vertica - a highly scalable and available database system **Rating:** 4.5/5.0 stars **Reviewed by:** shrey G. | Deputy Manager, Enterprise (> 1000 emp.) **Reviewed Date:** July 29, 2022 **What do you like best about Rocket Vertica?** The availability of spread and it's scalable nature. It's ability to integrate with a large variety of tech stack including spark. **What do you dislike about Rocket Vertica?** The inability to scale without vertica assistance. In terms of both machine support and database scaling. **What problems is Rocket Vertica solving and how is that benefiting you?** It's creates an easy integration with our tech stack providing an apt business friendly database system **Official Response from Paige Roberts:** > Thank you for the great review! Cheers, Paige ### 23. Vertica review its trustworthy and data oriented **Rating:** 3.5/5.0 stars **Reviewed by:** Sweety W. | Senior Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 20, 2022 **What do you like best about Rocket Vertica?** Vertica provides comprehensive live on demand and in person training covering self placed training and instructor lead classes , webinars and certifications Gets customer to problems or bottleneck **What do you dislike about Rocket Vertica?** One things that person should know is new structure Not successful in cloud busine transformation Cannoy say its best in industry yet Recent changes Leadership changes **Recommendations to others considering Rocket Vertica:** Go with it **What problems is Rocket Vertica solving and how is that benefiting you?** Problems could be solved using best cloud solutions and engineering solutions benefits would be to reach that milestone to achieve desired goal and employees can learn new technologies **Official Response from Paige Roberts:** > Thanks for taking the time to review! Much appreciated. Cheers, Paige ### 24. Environment is good and scope for learning the new technology **Rating:** 4.0/5.0 stars **Reviewed by:** Majoju R. | Lead Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Rocket Vertica?** Easy to connect with management and friendly employees. Scope for learning new technologies **What do you dislike about Rocket Vertica?** I have not seen any concerns with Vertica. It is suggestable to everyone. **Recommendations to others considering Rocket Vertica:** Better to go for Vertica if they are looking for a cloud platform for their business needs **What problems is Rocket Vertica solving and how is that benefiting you?** It is basically focussed on the healthcare industry and It helps me learn the domain **Official Response from Paige Roberts:** > Thanks for the great review! Cheers, Paige ### 25. I have used vertical in one of the solution to enable faster generation of business insights **Rating:** 4.5/5.0 stars **Reviewed by:** Umesh Kumar R. | Senior Technical Architect, Enterprise (> 1000 emp.) **Reviewed Date:** August 22, 2022 **What do you like best about Rocket Vertica?** It suports large volume of data and able to perform analytics in almost real time. It separates compute & storage. **What do you dislike about Rocket Vertica?** It focuses primarily on structured data. **What problems is Rocket Vertica solving and how is that benefiting you?** Flexible deployment model is supported **Official Response from Paige Roberts:** > Gotta love autocorrect. Thanks for the review! Cheers, Paige ### 26. Vertica is a very good tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Rocket Vertica?** Vertica is world's best database management system **What do you dislike about Rocket Vertica?** Nothing is wrong in vertica , no negative **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica works very nice for ETL scripts **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! Much appreciated, Paige ### 27. The best staging database **Rating:** 5.0/5.0 stars **Reviewed by:** Utsav R. | Data Engineering - Sr Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** January 15, 2022 **What do you like best about Rocket Vertica?** Data reliability, scalability and transaction controls at its best. The compatibility with major ETL( Talend) and dashboarding tools(Qlik) is seemless. Just best! **What do you dislike about Rocket Vertica?** Sometimes we might face node failures and failover controllers are not much handy. Data limit exceeds quickly and there are warnings in command line which i personally felt cumbersome. **Recommendations to others considering Rocket Vertica:** Vertica is a good substitute for enterprise database with all the supports and cross platform leverages. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica External tables have Good compatibility with Hadoop's hive. Data can easily be migrated and is quite fast for all datasets. Creating Reporting system in realtime and Near real time is really good. **Official Response from Paige Roberts:** > Thank you for the wonderful review! I'll pass on your feedback to our engineers. Thanks again, Paige ### 28. 2+ Years of Experience in Data analytics and Warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** Rakesh kumar B. | Associate Software QA Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Rocket Vertica?** One of the best platform for - Data Warehousing Real Time Data Analytics **What do you dislike about Rocket Vertica?** Migration to cloudis not much flexible.. **Recommendations to others considering Rocket Vertica:** Best platform for ETL, Data analytics, Data Warehousing **What problems is Rocket Vertica solving and how is that benefiting you?** Provides real time data analytics for data set Loads millions of rows in least time and with perfection **Official Response from Paige Roberts:** > Thank you for the great review! We really appreciate you taking the time. Cheers, Paige ### 29. Robust Data Modeling and Visualization Program **Rating:** 4.5/5.0 stars **Reviewed by:** Rachael A. | Data Warehouse Architect, Enterprise (> 1000 emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Rocket Vertica?** Vertica enables me to automatically integrate, collect and model data from disperate data repositories into one cloud analytics tool. **What do you dislike about Rocket Vertica?** Unavailability of mobile app like GCP to track data virtualization progress. **What problems is Rocket Vertica solving and how is that benefiting you?** We utilize Vertica for big data processing, modeling and visualization. **Official Response from Paige Roberts:** > Thank you for the great review! Cheers, Paige ### 30. Having 3+ experience in Data warehousing, bigdata **Rating:** 4.0/5.0 stars **Reviewed by:** Abhishek P. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Rocket Vertica?** Fastest platform for ETL. Real time data analytics. **What do you dislike about Rocket Vertica?** Not much flexible with cloud platform... **Recommendations to others considering Rocket Vertica:** Highly recommended. **What problems is Rocket Vertica solving and how is that benefiting you?** In my current project helped me to load millions of rows per second, solved big data issues and providing real time data analytics for current dataset. **Official Response from Paige Roberts:** > Thanks so much for the review! Much appreciated, Paige ### 31. Vertica makes analytics easier **Rating:** 3.5/5.0 stars **Reviewed by:** Danish N. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** January 11, 2022 **What do you like best about Rocket Vertica?** You can find vertica in almost every popular cloud services. Amazon web service, Google cloud platform and microsoft azure. **What do you dislike about Rocket Vertica?** Vertica optimizer for query handling is not as great as other leaders. You need to know ahead of projection and sql query then only it makes sense to use it **Recommendations to others considering Rocket Vertica:** You can use it without the need to data transfer from your traditional data warehouse **What problems is Rocket Vertica solving and how is that benefiting you?** Doing EDA and gap analysis in vertica is fairly straightforward.the best thing is that we dont require to transfer data from one data warehouse to vertica to use it. Hdfs support is great. One tip is to use vertica in two different modes for project management . You can always makes use of both storage and compute engine using a single mode also. **Official Response from Paige Roberts:** > Hi Danish, Thank you for the review. We really appreciate you taking the time. Database Designer might be a help with query optimization. Database Designer is Vertica's AI app that analyzes your existing data and query load, and optimizes the data storage for faster queries, without requiring any specialized knowledge. https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/PhysicalSchema/DBD/AboutDatabaseDesigner.htm Let us know if there's anything we can help with. ### 32. 3+ year experience in data warehousing **Rating:** 4.0/5.0 stars **Reviewed by:** Prachi A. | Software Developer, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Rocket Vertica?** Provides best platform for data warehousing **What do you dislike about Rocket Vertica?** Not flexible for cloud migration or not compatible **Recommendations to others considering Rocket Vertica:** Makes ur work easy as provided one of the best platforms for data warehousing **What problems is Rocket Vertica solving and how is that benefiting you?** Provides real time data analytics , providing paas **Official Response from Paige Roberts:** > Thank you for the great review! Really appreciate you taking the time. Cheers, Paige ### 33. Great performance and great community **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 26, 2022 **What do you like best about Rocket Vertica?** The performance for my use case at my work at one of my previous companies was very good given it is a column based DB. Also, for different usecases and learning new stuff, the community and documentation was an immense support. **What do you dislike about Rocket Vertica?** I think there should be a provision to have an extensive managed service tieup with cloud providers which will further help ease off development rather than self-managing the DB. **What problems is Rocket Vertica solving and how is that benefiting you?** I was working on high scale big data problems involving a lot of columnar transaction data and most queries we hit generally involved picking up a subset of those columns. The performance was very good for our use case. **Official Response from Paige Roberts:** > Thanks for taking the time to leave such a nice review. If you're looking for something more managed, our SaaS app Vertica Accelerator might be helpful. https://www.vertica.com/product/vertica-accelerator/ Much appreciated, Paige ### 34. The best integrated multitool for data storage and analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Dmitry V. | Data Warehouse Architect, Enterprise (> 1000 emp.) **Reviewed Date:** September 02, 2021 **What do you like best about Rocket Vertica?** What you usually expect from a storage solution is that it can save and provide comfortable access to all the data, not only for engineers but for plain users. My experience with Vertica shows that it is a versatile and resilient tool, which provides a lot of fine-tuning knobs, but at the same time forgives the mistakes you make on data architecture design steps and at the same time motivates to incrementally enhance your solutions. A lot of integration capabilities, including Kafka, Spark and Hadoop, powerful security features. It is also a software solution that makes it easy to scale up much easier than in appliance solutions. **What do you dislike about Rocket Vertica?** Several features are not (yet) presented in Vertica, which might be useful: 1. Procedures - not to process data or perform analytics, but to enhance SQL with DSL or common data access routines. It is particularly useful for DWH, when highly normalized layers require to have dynamically generated SQL to access. 2. Conditional execution. It will be handy for schemata management. With conditional execution, it is possible to define schema with idempotent change management. 3. Federative data access - sometimes it is much easier to just ask something in other databasess in real time, than to integrate it. Particularly useful for analytics. Hope it will ve delivered some day. **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica is our primary tool for big data analytics (for structured data). Here's what we do: - Ingest data from Kafka directly, and from other sources using Apache Nifi and Apache Airflow - Create data pipelines for building cleaned and trustworthy datasets on user marts level - Bulding detailed layer using modified anchor modeling approach - Manage access to data via global role-model and unified data access policies - Perform retention operations for old data partitions by moving it (again directly) to Hadoop - Business analytics via Tableau - ML models training and scoring, ad-hoc analytics and sandboxes - CI/CD for schemata changes and versioning (using Gitlab) All in all it is a tool that has a lot of applications in data management field. And in most if the application cases it is not just "has capability", but does it on state-of-the-art level. ### 35. Vertica Analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Sinchan S. | Consultant - Analytics & Insights, Enterprise (> 1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Rocket Vertica?** Strong analytics options, integration with bunch of partner products, big data analytics **What do you dislike about Rocket Vertica?** ML integration, scalability and role based access control options **What problems is Rocket Vertica solving and how is that benefiting you?** Analytical insights lead to strategic decision making **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! We really appreciate it. Cheers, Paige ### 36. My Vertica Experience **Rating:** 5.0/5.0 stars **Reviewed by:** Yash P. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 04, 2022 **What do you like best about Rocket Vertica?** The UI is quite user friendly and easy to understand. **What do you dislike about Rocket Vertica?** Nothing for now. I haven't yet explored that much to comment. **What problems is Rocket Vertica solving and how is that benefiting you?** It provides many useful big data services and supports languages like java and python. **Official Response from Paige Roberts:** > Thank you for the nice review! Cheers, Paige ### 37. Long time, happy Vertica customer **Rating:** 5.0/5.0 stars **Reviewed by:** Joe G. | Vertica Data Warehouse Admin (ASE Certified), Enterprise (> 1000 emp.) **Reviewed Date:** April 06, 2015 **What do you like best about Rocket Vertica?** Columnar storage makes for fast data access. Lots of storage on fewer nodes. Use of projections is an intuitive way to manage tables and help optimize queries. Great customer service, very responsive! Most importantly, they LISTEN to their customers! They are very responsive to problem inquiries, work closely with me and my fellow DBAs to figure out problem causes and solutions, and when an opportunity arises for a fix or an enhancement to the product, our combined solutions end up in the product for other users to benefit from! I have never had that experience with any other company. **What do you dislike about Rocket Vertica?** It has taken a while for Vertica to come up to speed on getting their product to fully take advantage of all the benefits the cloud (AWS, Azure, Google, etc) has to offer. But with their latest versions they are finally there! **Recommendations to others considering Rocket Vertica:** Go through with a POC, it will open your eyes to the benefits Vertica will have on your system. And when working with competitors to do side by side comparisons, make them disclose what and how much hardware they are using to run the comparison queries against Vertica. It's not always apples to apples, and it is not always disclosed unless you ask! **What problems is Rocket Vertica solving and how is that benefiting you?** We have a wide and varied use of Vertica across the company. ETL/ELT processes, more intense reporting queries, and API queries requiring high concurrency and lightning fast response times. Vertica is able to handle all of it! We are moving data over from another data warehouse product as well, and are seeing query time reductions immediately, and exponential cost savings over the other product. ### 38. Vertica space **Rating:** 3.0/5.0 stars **Reviewed by:** Nishant M. | Senior ETL/BI Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Rocket Vertica?** Ease of learning and support availabilityy **What do you dislike about Rocket Vertica?** Skillset availability and performace with high volume **What problems is Rocket Vertica solving and how is that benefiting you?** Not really benefitting,Abinitio and TD seema to be more eased **Official Response from Paige Roberts:** > Thank you for the review. Cheers, Paige ### 39. As i have worked on the projection it will help the to get the faster data processing by optimizing **Rating:** 4.0/5.0 stars **Reviewed by:** Vikas K. | ETl developer, Enterprise (> 1000 emp.) **Reviewed Date:** July 04, 2022 **What do you like best about Rocket Vertica?** Projections and functions to query data. **What do you dislike about Rocket Vertica?** Performance and scalability. Its required high memory to query data. **What problems is Rocket Vertica solving and how is that benefiting you?** Data warehousing with very effective procing and that is every business want to do. **Official Response from Paige Roberts:** > Thanks for the nice review. Appreciate you taking the time. Cheers, Paige ### 40. My Experience and review **Rating:** 3.0/5.0 stars **Reviewed by:** Kowshik P. | Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 22, 2022 **What do you like best about Rocket Vertica?** The speed of the vertica system and it's capabilities **What do you dislike about Rocket Vertica?** No implementation languages supported in Vertica **What problems is Rocket Vertica solving and how is that benefiting you?** Document storage purpose we have leveraged **Official Response from Paige Roberts:** > Hi Kowshik, Thank you for the review. Not sure what you're having trouble with as far as implementation languages, but Vertica has SDKs for C++, Java, Python, and R. There's also open source interfaces for Go and Node.js, and a user defined extension (UDx) framework, so you can create your own Vertica functions in Java, Python, C++, or R. Hope that helps, and thanks again for taking the time to review, Paige ### 41. Amazing Tool Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** Nirmal K. | Snow Solution Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Rocket Vertica?** User Friendly Graphical User Interface. **What do you dislike about Rocket Vertica?** learning Curve too lengthy, not up to mrk **What problems is Rocket Vertica solving and how is that benefiting you?** My day to day data analytics and reporting needs. **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 42. Vertica the game changer **Rating:** 4.5/5.0 stars **Reviewed by:** Abhijit M. | Cloud Architect, Enterprise (> 1000 emp.) **Reviewed Date:** July 09, 2022 **What do you like best about Rocket Vertica?** Faster Analytics, Real time processing.. **What do you dislike about Rocket Vertica?** GUI need to be improved. Should have more options on cloud.. **What problems is Rocket Vertica solving and how is that benefiting you?** Big data Analytics, faster database and quick insights. **Official Response from Paige Roberts:** > Thank you for the nice review! Much appreciated, Paige ### 43. All Rounder Platform for Data Analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** January 14, 2022 **What do you like best about Rocket Vertica?** I like the tools and support which Vertica G2 provides. Most importantly I like it as helps in performing analytical operations very efficiently and effectively. **What do you dislike about Rocket Vertica?** I would like them to improve the interface and increase more support with the cloud platformd such as AWS, AZURE and GCP. Also like to see if Vertica G2 can integrate more tools and programming features. **What problems is Rocket Vertica solving and how is that benefiting you?** The major problem is the optimisation and performance tunning which I think Vertica G2 can handle very efficiently. Processing and analysing the non structured data is a major problem I see which Vertica can do it. **Official Response from Paige Roberts:** > Hi Rituraj, Thanks for taking the time to write a review! We're constantly upgrading the Vertica Management Console to provide better user experience. Try out the latest version if you get a chance. Also, Vertica is now available on AWS, Azure, and GCP, as well as a Kubernetes operator, for even greater cross-platform portability. Vertica Accelerator is our new managed service on AWS. We're getting great feedback on the ease of use for Vertica Accelerator. Check it out if you get the chance. Thanks again for the great review, Paige ### 44. Experience with Vertica **Rating:** 4.5/5.0 stars **Reviewed by:** Francis Suthakar A. | Technology Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** May 01, 2022 **What do you like best about Rocket Vertica?** Bring the value to the business to attract the customer based on the right time accurate analysis in a faster way using Vertica. **What do you dislike about Rocket Vertica?** Nothing to dislike since all are valuable **What problems is Rocket Vertica solving and how is that benefiting you?** Handling huge data and getting the right KPIs after processing and analysing the data **Official Response from Paige Roberts:** > Thanks for posting a review! Cheers, Paige ### 45. Vertica is launch of new era **Rating:** 5.0/5.0 stars **Reviewed by:** Chetan P. | Data Engineer II, Small-Business (50 or fewer emp.) **Reviewed Date:** January 18, 2022 **What do you like best about Rocket Vertica?** Powerful functions that vertica provide for data anlytics create a difference between vertica and other tools , it's fast and more powerful for olap use cases and queries **What do you dislike about Rocket Vertica?** Nothing for now , but can be more helpful if we have more deatures to deal with cloud services such as glue catalog , athena and aws data lake , google big query **Recommendations to others considering Rocket Vertica:** Nothing **What problems is Rocket Vertica solving and how is that benefiting you?** Vertica helps me to derive critical data metrics that helps me to understand my data in depth and analytics data that help me to create BI report to visualise my data **Official Response from Paige Roberts:** > Thanks for taking the time to leave a review. We appreciate it. Cheers, Paige ### 46. Experience with Vertica **Rating:** 2.5/5.0 stars **Reviewed by:** Divya S. | Technical Support Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** May 02, 2022 **What do you like best about Rocket Vertica?** I really liked the way Vertica manages the huge data and partition concept. **What do you dislike about Rocket Vertica?** Resource management process as it admin have more chances to prioritize the accounts **What problems is Rocket Vertica solving and how is that benefiting you?** Data unavailability issues and data mismatch issues mostly **Official Response from Paige Roberts:** > Hi Divya, Thanks for taking the time to post a review. Since the score is fairly low, could you let us know how we can improve? Cheers, Paige ### 47. Vertica an expert in database **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Rocket Vertica?** Vertica is fast and good in performance. **What do you dislike about Rocket Vertica?** Vertica on cloud usage and awareness is very less. This needs to be improved more **What problems is Rocket Vertica solving and how is that benefiting you?** Plays a major role for Datawarehousing solution implementation **Official Response from Paige Roberts:** > Thank you for taking time to write a review! Much appreciated, Paige ### 48. It's great DB **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** May 02, 2022 **What do you like best about Rocket Vertica?** Vertica is real fast query engines, scalable and easy to use it **What do you dislike about Rocket Vertica?** At the moment nothing, I like it very much **What problems is Rocket Vertica solving and how is that benefiting you?** Performance per query of millions of tuples **Official Response from Paige Roberts:** > Thank you so much for the complimentary review! Much appreciated, Paige ### 49. Amazing Product **Rating:** 4.5/5.0 stars **Reviewed by:** Rohan S N. | Statistical Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** April 03, 2022 **What do you like best about Rocket Vertica?** Vertica offers flexibility to work on huge datasets and makes querying super fast. **What do you dislike about Rocket Vertica?** The product needs development on the wide tables performance. **What problems is Rocket Vertica solving and how is that benefiting you?** Performing retro analysis for client reporting. Adhoc analysis. Query execution time lapse are improved. **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! Much appreciated, Paige ### 50. Data warehousing using Vertica **Rating:** 2.5/5.0 stars **Reviewed by:** Pulkit M. | Senior Lead Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 07, 2022 **What do you like best about Rocket Vertica?** The ability of Vertica to intelligently improve query performance. **What do you dislike about Rocket Vertica?** The UI is not user-intuitive and bland in appearance. **What problems is Rocket Vertica solving and how is that benefiting you?** Good query performance and solves the query bottleneck problem as observed in other data warehouse technologies. **Official Response from Paige Roberts:** > Thanks for taking time to write a review! Glad you like the smart, fast queries. I'll pass on your feedback about the need to improve the user interface. Cheers, Paige ## 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=2§ion=pricing&secure%5Bexpires_at%5D=2026-08-02+18%3A32%3A32+-0500&secure%5Bsession_id%5D=fce66f42-8a8f-4292-afa8-7e0364597bd2&secure%5Btoken%5D=3d8261357dbc042ee42918ec9a35bf5416c981af3959f7c67734767d63e06b83&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)