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 ease of deployment is useful so clients are up and running quickly in comparison to other products."
"It's stable and reliable."
"The most valuable feature is the ease of uploading data from multiple sources."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"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."
"The extensibility and efficiency provided by their C++ SDK."
"Its projections and encoding are excellent tools for tuning large volumes."
"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 solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"The solution is quick, has good compression data, and is not expensive."
"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."
"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."
"There are some ways that the handling of unstructured data could be improved."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Suboptimal projection design causes queries to not scale linearly."
"They could improve the integration and some of the features in the cloud version."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"It needs integration with multiple clouds."
"I believe the installation process could be streamlined."
"The geospatial functionality could be designed better."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
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 Oracle Exadata. 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.