We performed a comparison between Aster Data Map Reduce and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature is the ease of uploading data from multiple sources."
"The ease of deployment is useful so clients are up and running quickly in comparison to other products."
"It's stable and reliable."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The solution is quick, has good compression data, and is not expensive."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"I have found the solution to be scalable."
"It is hard for some of our users to set up rules for cleansing and transforming data, so this is something that could be improved."
"There are some ways that the handling of unstructured data could be improved."
"From my perspective, it would be good if they gave better ITIN/R plugins to use the data for AI modeling, or data science modeling. We can do it now; however, it could be more elegant in terms of interfacing."
"The integration with AI has room for improvement."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"The geospatial functionality could be designed better."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
Aster Data Map Reduce is ranked 19th in Data Warehouse with 3 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Aster Data Map Reduce is rated 7.4, while Vertica is rated 8.2. The top reviewer of Aster Data Map Reduce writes "Has good base product functionality of data storage and analytics but there should be an option to use it on the cloud ". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Aster Data Map Reduce is most compared with , whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and BigQuery. See our Aster Data Map Reduce vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.