We performed a comparison between Teradata 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."It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"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."
"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."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"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."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"It has improved my organization's functionality and performance."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"The user interface needs to be improved."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"I would like to see an improved Knowledge Base on the web."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"It would help to make scaling easier with a reduced cost. "
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"Suboptimal projection design causes queries to not scale linearly."
"It would be great if this were a managed service in AWS."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"We faced some challenges when trying to use the temporary tables feature."
"I believe the installation process could be streamlined."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
Teradata is ranked 3rd in Data Warehouse with 54 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Teradata is rated 8.2, while Vertica is rated 8.2. The top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and Oracle Database, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Oracle Exadata and BigQuery. See our Teradata 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.