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.
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.
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)||✓||✓|
|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-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.
Vertica delivers on cloud flexibility like no other analytics platform can
Get projects into production to deliver on the promise of machine learning
Modernize your enterprise data warehouse with Vertica Analytics Platform