This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
New features
This section describes the new features introduced in the most recent releases of Vertica and provides references to detailed information in the documentation set.
New features
This section describes the new features introduced in the most recent releases of Vertica and provides references to detailed information in the documentation.
For known and fixed issues in the most recent release, see the Release Notes.
2 - Deprecated and removed functionality
Vertica retires functionality in two phases:.
Vertica retires functionality in two phases:
-
Deprecated: Deprecated features and functionality are announced in a major or minor release. Deprecated features remain in the product and are functional. Published release documentation announces deprecation on this page. When users access this functionality, it may return informational messages about its pending removal.
-
Removed: Feature are removed in a major or minor release that follows the deprecation announcement. Users can no longer access the functionality, and this page is updated to verify removal (see History, below). Documentation that describes this functionality is removed, but remains in previous documentation versions.
Deprecated
Removed
The following functionality has been removed:
|
Release |
Functionality |
Notes |
|
26.1 |
Community Edition trial RPMs, images, and containers |
Sign up for a free trial of Vertica. |
History
The following functionality or support has been deprecated or removed as indicated:
|
Functionality |
Component |
Deprecated in: |
Removed in: |
OAuth2JITClient security parameter. |
Server |
24.2.0 |
|
|
The following Helm chart parameters:
logging.maxFileSize
logging.maxFileAge
logging.filePath
logging.maxFileRotation
|
Kubernetes |
24.2.0 |
|
|
The following JDBC and ODBC connection properties:
- OAuthRefreshToken/oauthrefreshtoken
- OAuthClientSecret/oauthclientsecret
- oauthtruststorepath (JDBC only)
- oauthtruststorepassword (JDBC only)
|
Client drivers |
24.1.0 |
|
Integration with the Linux logrotate utility |
Server |
24.1.0 |
|
|
vbr utility in Kubernetes pods |
Kubernetes |
|
24.1.0 |
|
Scrutinize in Kubernetes pods |
Kubernetes |
|
24.1.0 |
v1beta1 VerticaDB custom resource definition API version |
Kubernetes |
23.4.0 |
25.3.0 |
serviceAccountNameOverride Helm chart parameter |
Kubernetes |
23.4.0 |
24.1.0 |
skipRoleAndRoleBindingCreation Helm chart parameter |
Kubernetes |
23.4.0 |
24.1.0 |
spec.communal.kerberosRealm VerticaDB custom resource definition parameter |
Kubernetes |
23.4.0 |
24.1.0 |
spec.communal.kerberosServiceName VerticaDB custom resource definition parameter |
Kubernetes |
23.4.0 |
24.1.0 |
spec.temporarySubclusterRouting VerticaDB custom resource definition parameter |
Kubernetes |
23.4.0 |
24.1.0 |
|
Vertica Kubernetes (No keys) image |
Kubernetes |
23.4.0 |
24.1.0 |
|
Vertica Kubernetes admintools support |
Kubernetes |
23.4.0 |
24.1.0 |
|
Oracle Enterprise Linux 6.x (Red Hat compatible kernels only) |
Supported platforms |
23.4.0 |
24.1.0 |
|
Oracle Enterprise Linux 7.x (Red Hat compatible kernels only) |
Supported platforms |
23.4.0 |
|
|
Red Hat Enterprise Linux 7.x (RHEL 7) support |
Supported platforms |
23.4.0 |
24.1.0 |
|
The following log search tokenizers:
v_txtindex.AdvancedLogTokenizer
v_txtindex.BasicLogTokenizer
v_txtindex.WhitespaceLogTokenizer
logWordITokenizerPositionFactory and logWordITokenizerFactory from the v_txtindex.logSearchLib library
|
Server |
23.4.0 |
24.1.0 |
|
DHParams |
Server |
23.3.0 |
|
|
OAuthJsonConfig and oauthjsonconfig |
Client drivers |
23.3.0 |
|
|
Visual Studio 2012, 2013, and 2015 plug-ins and the Microsoft Connectivity Pack |
Client drivers |
12.0.4 |
23.3.0 |
|
ADO.NET driver support for .NET 3.5 |
Client drivers |
12.0.3 |
|
prometheus.createServiceMonitor Helm chart parameter |
Kubernetes |
12.0.3 |
|
webhook.caBundle Helm chart parameter |
Kubernetes |
12.0.3 |
24.1.0 |
|
cert-manager for Helm chart TLS configuration |
Kubernetes |
12.0.2 |
23.3.0 |
Use webhook.certSource parameter to generate certificates internally or provide custom certificates. See Helm chart parameters. |
Kubernetes |
12.0.2 |
|
|
The following Kafka user-defined session parameters:
|
Kafka |
12.0.3 |
|
|
vsql support for macOS 10.12-10.14 |
Client drivers |
|
12.0.3 |
|
CA bundles |
Security |
12.0.2 |
|
|
The following parameters for CREATE NOTIFIER and ALTER NOTIFIER:
-
TLSMODE
-
CA BUNDLE
-
CERTIFICATE
|
Security |
12.0.2 |
|
|
The TLSMODE PREFER parameter for CONNECT TO VERTICA. |
Security |
12.0.2 |
|
|
JDBC 4.0 and 4.1 support |
Client drivers |
12.0.2 |
23.4.0 |
|
Support for Visual Studio 2008 and 2010 plug-ins |
Client drivers |
12.0.2 |
12.0.3 |
|
Internet Explorer 11 support |
Management Console |
|
12.0.1 |
|
ODBC support for macOS 10.12-10.14 |
Client drivers |
|
12.0 |
|
The following ODBC/JDBC OAuth parameters:
-
OAuthAccessToken/oauthaccesstoken
-
OAuthRefreshToken/oauthrefreshtoken
-
OAuthClientId/oauthclientid
-
OAuthClientSecret/oauthclientsecret
-
OAuthTokenUrl/oauthtokenurl
-
OAuthDiscoveryUrl/oauthdiscoveryurl
-
OAuthScope/oauthscope
|
Client drivers |
12.0 |
|
hive_partition_cols parameter for PARQUET and ORC parsers |
Server |
12.0 |
|
|
The following ODBC/JDBC OAuth parameters:
-
OAuthAccessToken/oauthaccesstoken
-
OAuthRefreshToken/oauthrefreshtoken
-
OAuthClientId/oauthclientid
-
OAuthClientSecret/oauthclientsecret
-
OAuthTokenUrl/oauthtokenurl
-
OAuthDiscoveryUrl/oauthdiscoveryurl
-
OAuthScope/oauthscope
|
Client drivers |
12.0 |
|
|
INFER_EXTERNAL_TABLE_DDL function |
Server |
11.1.1 |
|
|
Admission Controller Webhook image |
Kubernetes |
11.0.1 |
11.0.2 |
|
Admission Controller Helm chart |
Kubernetes |
11.0.1 |
|
|
Shared DATA and DATA,TEMP storage locations |
Server |
11.0.1 |
|
|
DESIGN_ALL option for EXPORT_CATALOG() |
Server |
11.0 |
|
|
HDFSUseWebHDFS configuration parameter, HCatalogConnectorUseLibHDFSPP, and LibHDFS++ |
Server |
11.0 |
25.1 |
|
INFER_EXTERNAL_TABLE_DDL (path, table) syntax |
Server |
11.0 |
11.1.1 |
|
AWS library functions:
-
AWS_GET_CONFIG
-
AWS_SET_CONFIG
-
S3EXPORT
-
S3EXPORT_PARTITION
|
Server |
11.0 |
12.0 |
|
Vertica Spark connector V1 |
Client |
11.0 |
|
admintools db_add_subcluster --is-secondary argument |
Server |
11.0 |
|
|
Red Hat Enterprise Linux/CentOS 6.x |
Server |
10.1.1 |
11.0 |
|
STRING_TO_ARRAY(array,delimiter) syntax |
Server |
10.1.1 |
|
|
Vertica JDBC API com.vertica.jdbc.kv package |
Client Drivers |
10.1 |
|
|
ARRAY_CONTAINS function |
Server |
10.1 |
|
|
Client-server TLS parameters:
-
SSLCertificate
-
SSLPrivateKey
-
SSLCA
-
EnableSSL
LDAP authentication parameters:
-
tls_key
-
tls_cert
-
tls_cacert
-
tls_reqcert
LDAPLink and LDAPLink dry-run parameters:
-
LDAPLinkTLSCACert
-
LDAPLinkTLSCADir
-
LDAPLinkStartTLS
-
LDAPLinkTLSReqCert
|
Server |
10.1 |
11.0 |
|
MD5 hashing algorithm for user passwords |
Server |
10.1 |
|
|
Reading structs from ORC files as expanded columns |
Server |
10.1 |
11.0 |
|
vbr configuration section [S3] and S3 configuration parameters |
Server |
10.1 |
|
|
flatten_complex_type_nulls parameter to the ORC and Parquet parsers |
Server |
10.1 |
11.0 |
|
System table WOS_CONTAINER_STORAGE |
Server |
10.0.1 |
11.0.2 |
|
skip_strong_schema_match parameter to the Parquet parser |
Server |
10.0.1 |
10.1 |
|
Specifying segmentation on specific nodes |
Server |
10.0.1 |
|
|
DBD meta-function DESIGNER_SET_ANALYZE_CORRELATIONS_MODE |
Server |
10.0.1 |
11.0.1 |
|
Meta-function ANALYZE_CORRELATIONS |
Server |
10.0 |
|
|
Eon Mode meta-function BACKGROUND_DEPOT_WARMING |
Server |
10.0 |
|
|
Reading structs from Parquet files as expanded columns |
Server |
10.0 |
10.1 |
|
Eon Mode meta-functions:
-
SET_DEPOT_PIN_POLICY
-
CLEAR_DEPOT_PIN_POLICY
|
Server |
10.0 |
10.1 |
|
vbr configuration parameter SnapshotEpochLagFailureThreshold |
Server |
10.0 |
|
|
Array-specific functions:
-
array_min
-
array_max
-
array_sum
-
array_avg
|
Server |
10.0 |
10.1 |
|
DMLTargetDirect configuration parameter |
Server |
10.0 |
|
|
HiveMetadataCacheSizeMB configuration parameter |
Server |
10.0 |
10.1 |
|
MoveOutInterval |
Server |
10.0 |
|
|
MoveOutMaxAgeTime |
Server |
10.0 |
|
|
MoveOutSizePct |
Server |
10.0 |
|
|
Windows 7 |
Client Drivers |
|
9.3.1 |
|
DATABASE_PARAMETERS admintools command |
Server |
9.3.1 |
|
|
Write-optimized store (WOS) |
Server |
9.3 |
10.0 |
7.2_upgrade vbr task |
Server |
9.3 |
|
|
DropFailedToActivateSubscriptions configuration parameter |
Server |
9.3 |
10.0 |
--skip-fs-checks |
Server |
9.2.1 |
|
|
32-bit ODBC Linux and OS X client drivers |
Client |
9.2.1 |
9.3 |
|
Vertica Python client |
Client |
9.2.1 |
10.0 |
|
macOS 10.11 |
Client |
9.2.1 |
|
|
DisableDirectToCommunalStorageWrites configuration parameter |
Server |
9.2.1 |
|
|
CONNECT_TO_VERTICA meta-function |
Server |
9.2.1 |
9.3 |
|
ReuseDataConnections configuration parameter |
Server |
9.2.1 |
9.3 |
|
Network interfaces (superseded by network addresses) |
Server |
9.2 |
|
|
Database branching |
Server |
9.2 |
10.0 |
|
KERBEROS_HDFS_CONFIG_CHECK meta-function |
Server |
9.2 |
|
|
Java 5 support |
JDBC Client |
9.2 |
9.2.1 |
|
Configuration parameters for enabling projections with aggregated data:
-
EnableExprsInProjections
-
EnableGroupByProjections
-
EnableTopKProjections
-
EnableUDTProjections
|
Server |
9.2 |
|
|
DISABLE_ELASTIC_CLUSTER() |
Server |
9.1.1 |
11.0 |
eof_timeout parameter of KafkaSource |
Server |
9.1.1 |
9.2 |
|
Windows Server 2012 |
Server |
9.1.1 |
|
|
Debian 7.6, 7.7 |
Client driver |
9.1.1 |
9.2.1 |
|
IdolLib function library |
Server |
9.1 |
9.1.1 |
|
SSL certificates that contain weak CA signatures such as MD5 |
Server |
9.1 |
|
|
HCatalogConnectorUseLibHDFSPP configuration parameter |
Server |
9.1 |
25.1 |
|
S3 UDSource |
Server |
9.1 |
9.1.1 |
|
HCatalog Connector support for WebHCat |
Server |
9.1 |
|
partition_key column in system tables STRATA and STRATA_STRUCTURES |
Server |
9.1 |
10.0.1 |
|
Vertica Pulse |
Server |
9.0.1 |
9.1.1 |
|
Support for SQL Server 2008 |
Server |
9.0.1 |
9.0.1 |
|
SUMMARIZE_MODEL meta-function |
Server |
9.0 |
9.1 |
RestrictSystemTable parameter |
Server |
9.0.1 |
|
S3EXPORT multipart parameter |
Server |
9.0 |
|
|
EnableStorageBundling configuration parameter |
Server |
9.0 |
|
Machine Learning for Predictive Analytics package parameter key_columns for data preparation functions. |
Server |
9.0 |
9.0.1 |
|
DROP_PARTITION meta-function, superseded by DROP_PARTITIONS |
Server |
9.0 |
|
Machine Learning for Predictive Analytics package parameter owner. |
Server |
8.1.1 |
9.0 |
Backup and restore --setupconfig command |
Server |
8.1 |
9.1.1 |
|
SET_RECOVER_BY_TABLE meta-function. Do not disable recovery by table. |
Server |
8.0.1 |
|
Column rebalance_projections_status.duration_sec |
Server |
8.0 |
|
|
HDFS Connector |
Server |
8.0 |
9.0 |
|
Prejoin projections |
Server |
8.0 |
9.2 |
Administration Tools option --compat21 |
Server |
7.2.1 |
|
|
admin_tools -t config_nodes |
Server |
7.2 |
11.0.1 |
|
Projection buddies with inconsistent sort order |
Server |
7.2 |
9.0 |
|
backup.sh |
Server |
7.2 |
9.0 |
|
restore.sh |
Server |
7.2 |
9.0 |
|
copy_vertica_database.sh |
Server |
7.2 |
|
|
JavaClassPathForUDx configuration parameter |
Server |
7.1 |
|
|
ADD_LOCATION meta-function |
Server |
7.1 |
|
|
bwlimit configuration parameter |
Server |
7.1 |
9.0 |
|
vbr configuration parameters retryCount and retryDelay |
Server |
7.1 |
11.0 |
|
EXECUTION_ENGINE_PROFILE counters: file handles, memory allocated |
Server |
7.0 |
9.3 |
|
EXECUTION_ENGINE_PROFILES counter memory reserved |
Server |
7.0 |
|
|
MERGE_PARTITIONS() meta-function |
Server |
7.0 |
|
|
krb5 client authentication method
Note
Use the Kerberos gss method for client authentication, instead of krb5.
|
All clients |
7.0 |
|
|
range-segmentation-clause |
Server |
6.1.1 |
9.2 |
scope parameter of meta-function CLEAR_PROFILING |
Server |
6.1 |
|
|
Projection creation type IMPLEMENT_TEMP_DESIGN |
Server, clients |
6.1 |
|
3 - New and changed in version 26.3
New features and changes in version 26.3
SQL editor enhancements
The SQL editor is now enhanced with these features:
- Simplified database object management - Easily create and manage database objects, including schemas, tables, views, stored procedures, and flex tables through an intuitive interface.
- Real-time SQL preview - Instantly view the generated SQL at every step with greater transparency and control before applying changes.
- Enhanced object explorer - Quickly browse and navigate all database objects from a centralized object explorer.
- Detailed object insights - Select any database object to view its properties, configuration details, and relevant metadata in a dedicated information panel.
- Improved SQL editor experience - Execute multiple SQL queries in a single session for quicker and efficient query workflows.
- Advanced query analysis tools - Analyze query behavior with integrated support for viewing execution plans and explain plans, helping users optimize performance and troubleshoot queries effectively.
Unified Console now supports all platforms supported by Management Console (MC), including x86 and ARM64 architectures, giving you greater flexibility to deploy and manage Vertica across a wider range of hardware environments.
Query optimization enhancements
Enhanced query optimization capabilities in Vertica AI Assist empower users with:
- LLM-powered explanations: Summarize query optimizations and provides clear, actionable insights for troubleshooting and performance tuning.
- Metadata-aware optimization: Leverage comprehensive Vertica metadata, including table statistics, projections, and resource usage, to deliver more accurate and context-aware optimization rationale.
- Visual explain plan graphs: Render optimized explain plans in a graphical interface, allowing intuitive analysis of query execution paths, operators, and costs.
- Profile summary: Provide a high-level overview of query execution, including duration, status, and resource usage.
- Query profile export: Generate profile export details and a download link for the profile tarball (.tar.gz).
Vertica Spark Connector 4.1.1 with Java 21 support
You can now use Vertica Spark Connector 4.1.1 in Java 21 environments. This update includes a fix for cross-database JDBC cache reuse, improving the reliability of Data Source V2 (DSv2) read and write operations.
Vertica Grafana Connector supports Grafana 13
You can query, explore, and visualize data with full support for Grafana 13 dashboards. This provides compatibility with Grafana 13 and includes the updates required to align with Grafana's React 19 frontend framework and plugin architecture.
Management Console supports multi-factor authentication (MFA)
Administrators can configure MFA for local authentication, federated server authentication, and identity provider (IDP) authentication workflows through Management Console's integration with Keycloak. Supported IDP protocols include SAML v2.0, OpenID Connect v1.0, and Keycloak OpenID Connect.
Note
For local authentication and federated server authentication, administrators configure MFA in Keycloak. For IDP authentication, administrators configure MFA in the external IDP.
Object-level in-database restore points
You can now save object-level in-database restore points by specifying object inclusion rules when you create an archive or save a restore point. Object-level restore points include only the specified objects and their dependent objects, and you can restore all or a subset of those objects from the archive. For more information, see Save restore points and RESTORE FROM ARCHIVE.
NUMA multi-node cluster management with VCluster CLI
VCluster CLI now supports managing NUMA (Non-Uniform Memory Access) multi-node clusters, where multiple database nodes run on the same physical host on different client ports. New options for add_node and remove_node let you specify per-node client ports and control NUMA node assignment for each host. This works both on real NUMA hardware and in standard environments running multiple nodes on a single host. For more information, see NUMA multi-node clusters.
Standalone MCP server RPM
Starting in version 26.3, the Vertica MCP server is distributed as a standalone RPM with its own release cadence, and must be installed on a dedicated host outside the Vertica cluster. Going forward, each MCP server release supports the most recently released version of the Vertica database. Note that MCP server release 26.3 specifically requires Vertica version 26.2.0-1, as this patch has been updated with standalone MCP server support.
For installation instructions, see Installing the MCP server RPM.
TLS v1.3 support
Vertica now supports TLS v1.3 in addition to TLS v1.2. The following changes provide support for both protocol versions:
-
CREATE TLS CONFIGURATION and ALTER TLS CONFIGURATION now include a separate CIPHERLIST parameter for specifying TLS v1.2 cipher suites. The previously existing CIPHER SUITES parameter is now used for TLS v1.3 cipher suites exclusively.
-
The TLS_CONFIGURATIONS system table includes a new CIPHER_LIST column for TLS v1.2 cipher suites.
-
A new TLSCipherSuites Security parameters specifies TLS v1.3 cipher suites for client-server communication. The existing EnabledCipherSuites parameter continues to apply to TLS v1.2.
Run end-to-end ML workflows with the MCP server
The Vertica MCP server now provides machine learning (ML) tools for running end-to-end, in-database ML workflows through natural-language interaction with AI agents. Using conversational prompts, you can prepare data, split, train and test sets, train and evaluate models, generate predictions, and manage models across their lifecycle.
The tools are organized into categories such as data preparation and feature engineering, exploratory data analysis, model training, prediction, model evaluation, and model registry and governance. For an overview and example workflows, see Machine learning with the MCP server. For a complete reference of every tool, see ML tools reference.
TLS fallthrough annotation for VerticaDB operator deployments
The VerticaDB operator supports a new vertica.com/enable-fallthrough annotation that controls whether operator-generated TLS authentications allow fallthrough. When set to true, a failed TLS connection can fall through to password authentication. This release also adds detailed guidance for enabling TLS across the database lifecycle on Kubernetes when creating, reviving, or updating a database, as well as during operator and server upgrades. For more information, see Custom resource definition parameters and Enable TLS in Vertica on Kubernetes.
Expose additional ports on subcluster services
The VerticaDB custom resource now supports a subclusters[i].extraPorts parameter that lets you expose additional ports on a subcluster service. Each entry accepts a port name, port, optional targetPort, and nodePort (for NodePort services), so you can route traffic for services such as metrics or administration endpoints alongside the standard database ports. For more information, see Custom resource definition parameters.
Export additional log streams with the sidecar logger
The vertica-logger sidecar image now supports exporting logs from different database components. Beginning with vertica-logger version 2.1.0, you can set the LOG_FILE_TYPE environment variable to export a specific log stream. Set it to VERTICA (default) for vertica.log, SPREAD for spread.log, or UDXLOGS for UDxFencedProcesses.log. Each sidecar exports a single log stream, so add a separate sidecar for each component you want to export. For more information, see VerticaDB custom resource definition.
ARM64 architecture support for containerized images
Vertica container images now support the arm64 architecture in addition to amd64. Any image with multiarch in its tag runs on both amd64 and arm64 hosts. For an example, see the opentext/vertica-logger tags. For more information, see Vertica images.