Deprecated and Removed Functionality

Vertica retires Vertica 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 Vertica functionality was deprecated and will be retired in future versions:

Release Functionality Notes
10.0.0

Array-specific functions:

  • array_min
  • array_max
  • array_sum
  • array_avg
  • array_count
  • array_length

Superseded by new functions that operate on collections, including arrays:

  • apply_min
  • apply_max
  • apply_sum
  • apply_avg
  • apply_count
  • apply_length

Configuration parameters:

  • HiveMetadataCacheSizeMB
  • DMLTargetDirect
  • MoveOutInterval
  • MoveOutMaxAgeTime
  • MoveOutSizePct
 Setting these parameters has no effect.
vbr configuration parameter SnapshotEpochLagFailureThreshold

With WOS removal, full and object backups no longer use SnapShotEpochLagFailureThreshold. If a vbr configuration file contains this parameter, vbr returns a warning that it was ignored.
Meta-function ANALYZE_CORRELATIONS Calls to this meta-function return with a warning message.
Reading structs from Parquet files as expanded columns Use the ROW complex type.
Eon Mode meta-function BACKGROUND_DEPOT_WARMING Foreground depot warming is no longer supported. Nodes only warm depots in the background. Calling this function has no effect.

Eon Mode meta-functions:

  • SET_DEPOT_PIN_POLICY
  • CLEAR_DEPOT_PIN_POLICY

Superseded by:

10.0.1 Specifying segmentation on specific nodes  
DBD meta-function DESIGNER_SET_ANALYZE_CORRELATIONS_MODE Calls to this meta-function return with a warning message.
skip_strong_schema_match parameter to the Parquet parser  
System table WOS_CONTAINER_STORAGE  

Removed

Release Functionality Notes
10.0.0 Write‑only storage (WOS)

As of 10.0, WOS and related functionality has been removed from Vertica.
Vertica Python client Replaced by open source Vertica Python client.
DropFailedToActivateSubscriptions configuration parameter If a subscription fails to activate and is stuck in the passive state, Vertica always drops it.
Database branching You can no longer create database branches.
10.0.1 partition_key column in system tables STRATA and STRATA_STRUCTURES This column has been removed from both tables.

History

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

Functionality Component Deprecated in: Removed in:
System table WOS_CONTAINER_STORAGE Server 10.0.1  
skip_strong_schema_match parameter to the Parquet parser Server 10.0.1  
Specifying segmentation on specific nodes Server 10.0.1  
DBD meta-function DESIGNER_SET_ANALYZE_CORRELATIONS_MODE Server 10.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  

Eon Mode meta-functions:

  • SET_DEPOT_PIN_POLICY
  • CLEAR_DEPOT_PIN_POLICY
 Server 10.0  
vbr configuration parameter SnapshotEpochLagFailureThreshold Server 10.0  

Array-specific functions:

  • array_min
  • array_max
  • array_sum
  • array_avg
  • array_count
  • array_length
 Server 10.0  
DMLTargetDirect configuration parameter Server 10.0  
HiveMetadataCacheSizeMB configuration parameter Server 10.0  
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() 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  
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() 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(). 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  
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  
vbr configuration parameters retryCount and retryDelay Server 7.1  
JavaClassPathForUDx configuration parameter Server 7.1  
ADD_LOCATION() meta-function Server 7.1  
bwlimit configuration parameter Server 7.1 9.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. See Configuring Kerberos Authentication.
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