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."
"It's stable and reliable."
"The ease of deployment is useful so clients are up and running quickly in comparison to other products."
"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."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Its projections and encoding are excellent tools for tuning large volumes."
"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."
"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."
"The geospatial functionality could be designed better."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Limitations in group by projections is where I would like to see an improvement."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Support is an area where it could get better."
"They could improve on customer service."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"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 20th 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.