Deprecated and Removed Functionality

Vertica retires functionality in two phases:

  • Deprecated: Vertica announces deprecated features and functionality 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: Vertica removes a feature 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

The following functionality was deprecated and will be removed in future versions:

Release Functionality Notes
11.0.1 Shared DATA and DATA,TEMP storage locations See CREATE LOCATION
Admission Controller Webhook image The admission controller webhook is included in the Vertica DB operator image. For details, see VerticaDB Operator.
Admission Controller Helm chart The admission controller is included in the verticadb-operator Helm chart. For details, see Installing the VerticaDB Operator.
11.0

AWS library functions:

Instead, use EXPORT TO DELIMITED.
INFER_EXTERNAL_TABLE_DDL (path, table) syntax Instead, use new USING PARAMETERS syntax to specify format and other parameters.
HDFSUseWebHDFS configuration parameter and LibHDFS++ Currently, a URL in the hdfs scheme uses LibHDFS++ to access data, and this configuration parameter allows you to force it to use WebHDFS instead. LibHDFS++ is deprecated and, in the future, hdfs URLs will automatically use WebHDFS. For details see HDFS File System.
DESIGN_ALL option for EXPORT_CATALOG() DESIGN option generates equivalent output.
Vertica Spark connector V1 The old version of the Vertica Spark connector (now referred to as the connector V1) has been deprecated in favor of the new, open-source Spark connector. See Integrating with Apache Spark
admintools db_add_subcluster --is-secondary argument The admintools db_add_subcluster tool's --is-secondary argument is no longer necessary. The tool now defaults to creating a secondary subcluster.

Removed

The following functionality was removed:

Release Functionality Notes
11.0.2 Spark connector V1 Use the new open source Spark Connector. See Integrating with Apache Spark
System table WOS_CONTAINER_STORAGE
WOS-related columns in system tables  
11.0.1 admin_tools -t config_nodes
DBD meta-function DESIGNER_SET_ANALYZE_CORRELATIONS_MODE
11.0 Reading structs from ORC files as expanded columns Use the ROW type to declare structs. See Complex Types.
DISABLE_ELASTIC_CLUSTER()
flatten_complex_type_nulls parameter to the ORC and Parquet parsers

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 (now set automatically based on the TLSMODE of the LDAPLink TLS CONFIGURATION)
  • LDAPLinkTLSReqCert

Superseded in 11.0 by direct equivalents in TLS CONFIGURATION:
vbr configuration parameters retryCount and retryDelay

History

The following functionality or support has been deprecated or removed as indicated:

Functionality Component Deprecated in: Removed in:
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 and LibHDFS++ Server 11.0
INFER_EXTERNAL_TABLE_DDL (path, table) syntax Server 11.0

AWS library functions:

  • AWS_GET_CONFIG
  • AWS_SET_CONFIG
  • S3EXPORT
  • S3EXPORT_PARTITION
 Server 11.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

Array-specific functions:

  • array_count
  • array_length
 Server 10.0
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
Mac 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
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
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