Vertica’s SQL Data Warehouse is trusted by the world’s leading data-driven companies, including Bank of America, Cerner, Etsy, Intuit, Uber and more to deliver speed, scale and reliability on mission-critical analytics. Vertica combines the power of a high-performance, massively parallel processing SQL query engine with advanced analytics and machine learning so you can unlock the true potential of your data with no limits and no compromises.
No longer move data or settle for siloed views. Access a single platform for data warehouse modernization and data lake exploration.
Fear of growing data volumes and users is a thing of the past. Complex questions get responses quickly, while scaling data and users linearly.
Data storage decisions made today won’t impact your ability to execute in the future. Evolve as requirements change or new technologies emerge.
Future-proof your analytics with a software-only, unified data analytics platform available in the widest range of deployment models.
Deploy Vertica on-premises, in the clouds, on Apache Hadoop, or as a hybrid model. Choose the right file formats and storage systems today, with the flexibility to change or move as organizational priorities shift in the future. No more proprietary hardware lock-in or closed systems.
To ensure you get the best value for your use case, there are now two editions of Vertica – premium and express. With Premium Edition, there are no limits to features, nodes or data size. The Vertica Express Edition includes a subset of Premium Edition features, but is offered at an even more affordable price. For example, it includes all the basic features such as Workload Management, but does not include more advanced features like Live Aggregate Projections. See the table on the right for details.
|MPP Architecture, High Availability||✓||✓|
|Role-Based and Column Security||✓||✓|
|Standard SQL (ANSI 99)||✓||✓|
|Flex Tables (metered at 1/10th)||✓||✓|
|DB Designer, Management Console, Elastic Cluster||✓||✓|
|ORC & Parquet Readers (to query Hadoop data)||✓||✓|
|FIPS 140-2 Support||✓|
|UDx’s written in Java and C++, Voltage UDx (Voltage UDx is pre-built and shipped with Vertica)||✓||✓|
|UDx’s written in Python and R||✓|
|Advanced SQL Functions (Analytical, Pattern Matching, Time Series, Geospatial)||✓|
|ROLAP SQL Functions (Rollup Aggregations, Grouping Sets Aggregations, Cube Aggregations, Pivot)||✓|
|Predictive Analytics Functions (e.g. outlier detection, linear & logistic regression, k-means, naïve bayes, random forest, confusion matrix, etc.)||✓|
|Fault Groups, Key Value interface||✓|
|Live Aggregate Projections, Flattened Tables, Text Search||✓|
Vertica supports the world’s leading data-driven disruptors in their pursuit of industry and business transformation. Our latest webcast series celebrates these Data Disruptors with insights from Philips Healthcare, Nimble Storage, The Climate Corporation, Simpi.fi and more.
Vertica is available as a perpetual or subscription license for on-premise or cloud-based deployments. The software license can be purchased on a per-node or per-terabyte basis.
Want to analyze your data lake at an economically favorable price? Purchase the Vertica External Data add-on to analyze data stored in Hadoop or Amazon S3 data lakes.