We performed a comparison between TIBCO Live Datamart, Vertica, and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The solution has a powerful aggregating feature"
"You can create your own rules that include mathematic calculations."
"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."
"Partition and join back to node are easy and simple for DBAs."
"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."
"Speed and resiliency are probably the best parts of this product."
"The solution is quick, has good compression data, and is not expensive."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"Very fast for query processing."
"We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database."
"Scalable (Massive) Parallel Processing (MPP) – The ability to bring to bear large amounts of compute against large data sets with Greenplum and the EMC DCA has proven itself to be very effective."
"It's one of the fastest databases in the market. It's easy to use. From a maintenance perspective it's a good product. The segmentation, or architecture of the product is different than other databases such as Oracle. So even in 10 years, the data distribution for such segments will not affect other segments. The query performance of the product, for complex queries, is very good. It has good integration with Hadoop."
"The most valuable feature for us is horizontal scaling."
"Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform."
"It's super easy to deploy and it also supports different languages and analytics."
"Helps us to achieve large-scale analytics."
"Improvements need to be made on the load balancing side."
"The solution's setup could be quicker and easier."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"The integration with AI has room for improvement."
"Documentation has become much better, but can always use some improvement."
"The biggest problem is the cost of cloud deployment."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"They could improve on customer service."
"Limitations in group by projections is where I would like to see an improvement."
"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."
"One of the disadvantages, not a disadvantage with the product itself, but overall, is the expertise in the marketplace. It's not easy to find a Greenplum administrator in the market, compared to other products such as Oracle."
"Extra filters would be helpful."
"they need to interact more with customers. They need to explain the features, especially when there are new releases of Greenplum. I know just from information I've found that it has other features, it can be used to for analytics, for integration with Big Data, Hadoop. They need to focus on this part with the customer."
"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"The installation is difficult and should be made easier."
"Initial setup is a little complex. It took around two weeks to deploy."
"They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."