• Product
    • Vertica Accelerator, Vertica-as-a-Service
    • Vertica Unified Analytics Platform, Customer-Managed Software
    • Product Overview
  • Industries
    • AdTech
    • Financial Services
    • Gaming
    • Healthcare
    • Technology
    • Telecommunications
    • Utilities
  • Partners
    • Become a Partner
    • Find a Partner
    • Partner Portal
    • 3rd Party Technology Partner Integration
    • Quickstarts
    • Partners Overview
  • Resources
    • Blog
    • Case Studies
    • Demos
    • Infographics
    • Tech Topics – What is…
    • Videos
    • Webcasts
    • All Resources
  • About
    • About Vertica
    • News & Recognition
    • Events
    • Careers
    • Contact us
  • Services & Support
    • Professional Services
    • Vertica Academy
    • User Forum
    • Patches
    • Contact Support
    • Documentation
      • Product Documentation
      • Knowledge Base
      • Troubleshooting Checklists
    • Downloads
      • Client Drivers
      • Patches
      • Software/Licenses
  • Try Vertica

  • Log In
  • Contact Us
  • User Forum
  • Vertica Academy
  • English
Vertica
  • Log In
  • Contact Us
  • User Forum
  • Vertica Academy
  • English
Vertica
  • Product
    • Product Overview

      Product Overview

      Vertica delivers unified analytics and machine learning at unprecedented speed, scale, and value.

      Learn More

    • Product
      • Vertica Accelerator,
        Vertica-as-a-Service
        • Vertica SaaS offering
        • Built on and delivers all the functionality of the Vertica Unified Analytics Platform
        • Automated administration and runs in your own AWS account
    • second column
      • Vertica Unified Analytics Platform,
        Customer-Managed Software
        • Bring Your Own License (BYOL) analytics software
        • Runs on-premises, hybrid, multi clouds, and containerized
        • Advanced analytics, in database ML, and data lake query engine
    • Product Resource
      Vertica 12

      Vertica Announces Vertica 12 for Future-Proof Analytics

      Latest version of analytics database enables more deployment flexibility, advanced analytics, and enhanced machine learning

  • Industries
    • Solutions Overview

      Featured Use Case:
      Customer Behavior Analytics

      Customer centricity is a mission critical initiative across industries. Unify customer data, deliver personalized, omni-channel experiences, and grow and retain your customer base.

      Learn More

    • Industries
      • AdTech
      • Financial Services
      • Gaming
      • Healthcare
    • Industries
      • Technology
      • Telecommunications
      • Utilities
    • Solutions Resource

      Harness the Internet of Things (IoT)

      IoT data is expected to grow exponentially across industries. Learn how to leverage sensor data at massive scale for business and customer value.

      Read On

  • Partners
    • Partners Overview

      Partners

      Tight integration with and support from leading technology and solution providers.

      Learn More

    • Partners
      • Become a Partner
      • Find a Partner
      • Partner Portal
    • col 2
      • 3rd Party Technology Partner Integration
      • Quickstarts
    • Partners Resource
      Vertica 11

      Vertica Inside – Embedded Analytics at Scale

      Seize the huge growth opportunity for OEM software developers

  • Resources
    • Resource Library

      Resources

      Explore our Thought Leadership library, including the most recent articles, webcasts and reports, with expert insights.

      Browse Resources

    • Resource Library
      • Blog
      • Case Studies
      • Demos
      • eBooks
      • Infographics
      • Videos
    • Webcasts
      • Tech Topics – What is…
      • Webcasts
      • Data Analytics Thought Leader Series
      • Data Disruptors Webcast Series
      • Under the Hood Webcast Series
    • Resources Menu Resource
      Vertica’s Analytical Database Earns Leader Status in the GigaOm Radar for Data Warehouses

      GigaOm Data Warehouse Report

      Vertica receives multiple Exceptional ratings for key criteria, market and user categories and recognition for future-looking product development 

  • About
    • About Vertica

      About Vertica

      Built for Fast. Built for Freedom.

      Learn More

    • About Vertica
      • News & Recognition
      • Events
    • col 2
      • Careers
      • Contact us
    • About Resource

      Stay Informed

      Sign-up to receive our monthly newsletter.

      Subscribe

      Latest newsletter

  • Services & Support
    • Support Resource

      Services & Support

      Access subscription-based pricing: New customers eligible for a 50% discount.

      Act now

    • Support Links
      • Professional Services
      • Vertica Academy
      • User Forum
      • Contact Support
    • Documentation
      • Documentation
      • Product Documentation
      • Knowledge Base
      • Troubleshooting Checklists
    • Downloads
      • Downloads
      • Client Drivers
      • Patches
      • Software/Licenses
  • Try Vertica

Introducing Vertica 9

Delivering High-Performance In-Database Machine Learning and Advanced Analytics Anywhere, Anytime, on Any Major Cloud

Unified advanced analytics database features advancements in in-database Machine Learning, direct querying of Parquet data on AWS S3, support for Google Cloud Platform and Azure Power BI, and beta release of cloud optimized separation of compute and storage

Read the Press Release and check out our recent News Coverage

 

The latest release includes improvements across Vertica’s four core areas of platform development, as well as the beta release of Vertica in Eon Mode, which enables organizations to evaluate the separation of compute and storage for Amazon Web Services (AWS) deployments:

  • Analyze in the Right Place
  • Machine Learning and Advanced Analytics
  • Freedom from Underlying Infrastructure
  • Performance at Exabyte Scale

Questions about Vertica 9? Check out the FAQ Page and Solution Brief

Analyze in the Right Place

 

Query Parquet Data from S3 Data Lake

  • Challenge: Highly concurrent, interactive analysis of the exploding volume of data stored on AWS S3
  • Solution: External tables allow customers to query Parquet data stored in AWS S3 directly from Vertica
  • Benefits: Ability to explore S3 Data Lake with advanced SQL analytics and extreme performance

Data Access Restriction with Security Realms

  • Challenge: Managing security concerns on Hadoop so different groups of users have access to select sets of data
  • Solution: Leverage Kerberos Realms to support different data access policies for various groups
  • Benefit: Enhanced control and data access restriction over different groups of users

Integration with Apache Sentry

  • Challenge: Companies that have centralized the management of user permissions want Hadoop usernames pass through when using Vertica to access data on HDFS
  • Solution: Vertica integrated with Apache Sentry so that the privileges associated with a Cloudera username can govern access control in Vertica
  • Benefit: Reduced operational burden with centralized security policies

Machine Learning and Advanced Analytics

 

Convert Categorical Data to Numerical Data

  • Challenge: When preparing data for statistical analysis, users must manually convert categorical data to numerical data
  • Solution: Built-in function automatically converts categorical data to numerical data with one-hot encoding columns, or dummy variables, from a given column in Vertica
  • Benefit: Less time spent on manual data preparation and custom conversion scripts

Cross-Validate Machine Learning Models

  • Challenge: Data scientists need to review the comparative performance of various algorithms and choose from multiple possible hyper-parameter values
  • Solution: Cross-validation function that enables more accurate evaluation of a model’s performance by training the model with more varied subsets of data
  • Benefit: Data scientists can more easily compare various models and avoid overfitting

Export Machine Learning Models

  • Challenge: Users with multiple Vertica clusters or separate development and production clusters need to train a machine learning model in one cluster and then move it to other clusters for scoring
  • Solution: Ability to import/export machine learning models across Vertica clusters
  • Benefit: Less time spent duplicating model building and training

Vertica’s new in-database machine learning capabilities are like gold! We are extremely excited to train our Machine Learning models on our data in Vertica and ship them with our platform to run on our customers’ clusters. This is something that is much harder with any other tool. Vertica’s in-database machine learning will improve our ability to offer new predictive analytics features quickly and easily to our growing customer base. It will improve our competitive positioning.

  • - Abhishek Sharma, Data Scientist, Fidelis Cybersecurity

Freedom from Underlying Infrastructure

 

 

Available on Google Cloud Marketplace “Launcher”

  • Challenge: Companies want more freedom from underlying infrastructure and to avoid being locked into one cloud
  • Solution: Regular publication of Vertica template images in the Google Cloud Marketplace that launch a guided provisioning process
  • Benefits: Vertica users running in the AWS or Azure clouds, or on premises, can more easily deploy their workloads to Google Cloud

 Microsoft Power BI Certification

  • Challenge: Previous integration between Microsoft Power BI and Vertica limited the scale and performance of data loading and analytics
  • Solution: Power BI now connects to Vertica via a new DirectConnect approach
  • Benefits: Faster, more scalable and more secure data analytics with Vertica and Microsoft Power BI

Cloud Provisioning with Management Console (MC)

  • Challenge: Scripting requirements of cloud vendors’ provisioning tools make it difficult to get started in the cloud
  • Solution: Augment Cloud Service Provider (CSP) provisioning tools with a user-friendly GUI wizard in the Vertica Management Console, including post-provisioning steps such as data loading and querying
  • Benefits: Easier to get Vertica up and running in the cloud, saving time and resources

Eon Mode Beta: Separation of Compute and Storage

  • Challenge: Variable-demand workloads need to scale for peak demand, and reduce size during low activity
  • Solution: Separation of compute and storage so that compute can be reduced during low-demand periods
  • Benefits: Rapid elasticity, blazingly fast query performance and reduced infrastructure spending. Now, Vertica v9.0.1 provides significantly improved throughput scaling over v9.

Performance at Exabyte Scale

 

 Hierarchical Partition Management

  • Challenge: Partitioning data into slices can significantly improve query execution because the Vertica optimizer can isolate the relevant storage containers, and eliminate the rest
  • Solution: Users can now create a custom, hierarchical definition of partition structure
  • Benefits: Faster queries at Petabyte scale

Universal Unique Identifier (UUID) Data Type

  • Challenge: Storing UUID data as text strings is an inefficient use of space
  • Solution: Allow customers to store UUID columns as a more space-efficient data type
  • Benefits: Data stored more efficiently

Flattened Tables

  • Challenge: Many queries involve joins between a large fact table and multiple dimension tables, which increases query overhead and reduces performance
  • Solution: Flattened tables include columns that get their values by querying other tables, offering a flattened view of data stored in complex schemas
  • Benefits: Less overhead and faster query performance
  • PRODUCT
  • INDUSTRIES
  • RESOURCES
  • PARTNERS
  • ABOUT
  • DOCUMENTATION
  • CONTACT US
  • Try Vertica

  • Returning Customer? Log In
Vertica Analytical Database Logo
  • Facebook
  • Twitter
  • LinkedIn
  • YouTube
  • Privacy Policy
  • Cookie Policy

Copyright © 2023 Open Text Corporation. All rights reserved.

Vertica uses cookies to give you the best possible online experience. You can change your consent choices at any time by updating your cookie settings.

Cookie Privacy Manager

Some essential features on Vertica.com won't work without certain cookies. Other cookies help improve your experience by giving us insights into how you use our site and providing you with relevant content. For more information, please check out our cookie policy here.

Strictly Necessary

ON

These cookies provide a secure login experience and allow you to use essential features of the site

Analytics / Performance

Analytics cookies allow us to improve our website by giving us insights into how you interact with our pages, what content you're interested in, and identifying when things aren't working properly. The information collected is anonymous.

Targeting

We use targeting cookies to test new design ideas for pages and features on the site so we can improve your experience. We also collect information about your browsing habits so we can serve up content more relevant to your interests. Disabling these cookies would mean the content you see on the site might not be as relevant to you.