We performed a comparison between Teradata Cloud Data Warehouse and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The most valuable feature is the ease of running queries."
"The product is reliable."
"I like the projection feature, which increases query performance."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Allows us to take volumes and process them at a very high speed."
"The performance is very good and the aggregate records are fast."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"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 cost of Teradata Cloud Data Warehouse has room for improvement."
"It could be a bit more user-friendly."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"Suboptimal projection design causes queries to not scale linearly."
"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."
"The integration of this solution with ODI could be improved."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"They could improve on customer service."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
More Teradata Cloud Data Warehouse Pricing and Cost Advice →
Teradata Cloud Data Warehouse is ranked 13th in Cloud Data Warehouse with 3 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. Teradata Cloud Data Warehouse is rated 8.0, while Vertica is rated 8.2. The top reviewer of Teradata Cloud Data Warehouse writes "Is quick, easy to upgrade, and cost-effective". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Teradata Cloud Data Warehouse is most compared with Snowflake, Amazon Redshift, Teradata and Oracle Exadata, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.
We monitor all Cloud 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.