Vertica’s 20 coolest features in 2020
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.
The future belongs to the fast, and Vertica delivers the fastest, most scalable advanced analytics platform, forever independent from underlying infrastructure.
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.
Vertica is built for the scale and complexity of today’s data-driven world
Analyze All of Your Data
No longer move data or settle for siloed views. Access a single platform for data warehouse modernization and data lake exploration.
Achieve Scale and Performance
Fear of growing data volumes and users is a thing of the past. Complex questions get responses quickly, while scaling data and users linearly.
Future-Proof Your Analytics
Data storage decisions made today won’t impact your ability to execute in the future. Evolve as requirements change or new technologies emerge.
Architected for Performance
Remove scale, performance, and capacity constraints with a platform architected from day one to handle the largest data volumes and most demanding workloads. Vertica delivers 10-50x faster performance or more compared to legacy systems.
What could you achieve with 50x faster analytics?
Massively Parallel Processing
Run queries in parallel across infrastructure and scale-out linearly for faster performance or more users
Columnar Storage
Increase query speed over traditional row-based storage systems by reading only the necessary data
Advanced Compression
Apply advanced compression algorithms to reduce disk space by up to 90% and improve performance by lowering costly I/O
Optimized Projections
Store data in format and structure optimized to improve performance on mostly frequently run analytics
Complete Freedom from Underlying Infrastructure
The data storage decisions you make today shouldn’t impact your ability to execute in the future
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.
The power to ramp up your analytics capabilities
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)
Parquet Export
UDx’s written in Java and C++, Voltage UDx (Voltage UDx is pre-built and shipped with Vertica)
Write UDXs in Python and R
Workload Analyzer
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
Data Disruptors Webcast Series
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.
Extensive Ecosystem Integrations
Vertica works with your existing data infrastructure. Integrate with the most commonly used hardware, public clouds, open source tools, popular programming languages, and commercial solutions.
Pay-as-you-go
Purchase Vertica with usage-based, hourly pricing directly from the AWS Marketplace or Google Marketplace.
Software License
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.
External Data
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.
Find out more
Vertica in the Clouds
Vertica delivers on cloud flexibility like no other analytics platform can
Machine Learning
Get projects into production to deliver on the promise of machine learning
On-Premises
Modernize your enterprise data warehouse with Vertica Analytics Platform