Here’s the difference between Vertica and Redshift. The comparison is based on pricing, deployment, business model, and other important factors.
Vertica develops data management solutions for storing and querying databases. Its products include The Vertica Analytic Database, which helps in analyzing data; Vertica for the Cloud, a cloud-based analytic database that helps in data management; and Vertica Analytic Database appliance, a hardware/software data management solution, which enables the clients to conduct near-real-time and ad hoc queries. After acquisition it is now promoted as HP Vertica Systems and has tools for SQL analysis on Hadoop.
Amazon Redshift is a fully managed petabyte scale data warehouse service. Redshift is designed for analytic workloads and connects to standard SQL based clients and business intelligence tools. Redshift delivers fast query and I/O performance for virtually any size dataset by using columnar storage technology and parallelizing and distributing queries across multiple nodes. Most common administrative tasks associated with provisioning, configuring, monitoring, backing up, and securing a data warehouse are automated.