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.
Which edition is right for you?
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.
| Express | Premium | |
| 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) | ✓ | ✓ |
| UDx’s written 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 AWS Marketplace. Vertica By the Hour includes support and requires no time commitments or license requirements.
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