Highlights of key features that make Vertica a game-changer in the world of analytics database technologies and machine learning. See these top 20 features that make Vertica stand out from the competition.
Vertica’s SQL Data Warehouse is trusted by the world’s leading data-driven companies, including 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.
Are you looking for a comprehensive view of Vertica capabilities? Download the Vertica Overview data sheet.
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.
Integrate seamlessly with current data access methods with the flexibility to change or move as priorities shift. No more proprietary infrastructure lock-in or closed systems. And no surprises at license time. Everyone needs development, test, and HA, so those come free. Pay only for production.
With Vertica, there are no limits to your data analytics explorations. You get MPP architecture for highly scalable capacity as your data grows. You get Flex Tables for working with semi-structured data, plus the ability to query HDFS (Hadoop) data in place. And you get advanced features like Live Aggregate Projections and the ability to write User Defined Extensions (UDXs) in Python or R.
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)
UDx’s written in Java and C++, Voltage UDx (Voltage UDx is pre-built and shipped with Vertica)
Write UDXs 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-premises or cloud deployments. The software license can be purchased on a per-node or per-terabyte basis and comes with Dev, QA, and HA environments.
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.