Micro Focus Vertica for SQL on Hadoop 10.1.1 has been released

  • KM03808377
  • 06-May-2021
  • 06-May-2021


Micro Focus Vertica for SQL on Hadoop 10.1.1 English


Recommended Software Update

Micro Focus is announcing the release of

Product: Vertica for SQL on Hadoop
Version: 10.1.1
Languages: English

To download version 10.1.1, you must first select version 10.1 in the Software Licenses and Downloads Portal.

The following  new key features are available with this version:

Vertica 10.1.1 adds a broad array of improvements and enhancements. Vertica analytics gets a boost with support for the latest version of PMML, 4.4, some useful new analytical functions, and a new machine learning algorithm: Approximate Quantile Sketch. While analytics is usually the biggest news in any release, this time the even bigger news is twofold. The first is the Limited Availability of Vertica in Eon Mode on Microsoft Azure cloud. Some of Vertica’s largest customers have already signed up to test Eon Mode functionality on Azure storage. And, with 10.1.1, Vertica officially starts Beta support of Kubernetes and containers. A Vertica-tested Docker image will be available on Dockerhub and Github. We welcome customers to try it out as many ways as they can before our upcoming GA release. This version also includes improvements in complex types support to more seamlessly unify data lake and data warehouse architectures, enhanced security including FIPS 140-2 support, and more.

Limited Availability Vertica in Eon Mode on Microsoft Azure Cloud
Vertica in Eon Mode on Azure

  • Support for Vertica in Eon Mode on Azure Storage
  • Export Parquet to Azure Blob Storage
  • External tables and Copy from Azure Blob Storage

Kubernetes Beta 
Beta Support of Kubernetes and Containers

  • Vertica-tested Docker image available on Dockerhub and Github
  • Customers invited to beta test
  • Support for Kubernetes StatefulSets
  • Support for Helm Charts

Analytics and Machine Learning Enhancements
Updated PMML and a New Algorithm

  • PMML 4.4 support
  • Approximate Quantile Sketch
  • ListAgg function – supports multi-character separators
  • ARGMAX/ARGMIN analytical functions added

Security and Compliance 
Current FIPS Support and Improved Voltage Integration

  • FIPS 140-2 support
  • Voltage and Access Policies enhancements

Complex Types for Data Lakes 
Broaden array and compression support

  • Add ORC support for one-dimensional arrays
  • Extend primitive one-dimensional array support to JSON
  • Improve string_to_array function
  • Add GZIP and other compression type support for export to Parquet

Many other improvements in a variety of areas

  • Predicate pushdown into ODBC
  • Use of column alias in SELECT clause of more expressions
  • Improve commit and snapshot concurrency 
  • Disable foreign key constraint check during object-level backup and restore

For more information, please check the Release Notes for this version (available from MySupport).

If you have an active support subscription for these products, please plan for downloading this version from the Software Licenses and Downloads Portal. To access these products in the Software Licenses and Downloads Portal, you will need to sign in with your Micro Focus credentials.

Our goal is to provide you with clear visibility into the support time-line of software products, enabling you to use this information to plan, test, and deploy new product versions. For more information, check our MySupport Software Product Lifecycle pages, where you can find support time-line information for previously released versions. For this newly released version, the following time-line applies (dates subject to change, always check the Software Product Lifecycle pages referenced above for the latest information):

Support time-line
Date Details
Feb 28, 2023 End of Committed Support

Please note that all Vertica customers with active support subscriptions are eligible to update to Vertica 10.1.1