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 in This Release

No deprecated functionality

Removed in This Release

Functionality Notes
DATABASE_PARAMETERS admintools command

Starting with release 9.3.0, support for various WOS-related functionality will be phased out from new databases. See Phase-out of WOS Support for details.

History

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

Functionality Component Deprecated in: Removed in:
DATABASE_PARAMETERS admintools command Server 9.3.1
Write-optimized store (WOS) Server 9.3
7.2_upgrade vbr task Server 9.3
DropFailedToActivateSubscriptions configuration parameter Server 9.3
Windows 7 Client Drivers 9.3.1
‑‑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
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
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
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
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 parametef 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
HDFS Connector Server 8.0 9.0
Prejoin projections Server 8.0 9.2
Administration Tools option --compat21 Server 7.2.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
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 9.0
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 typeIMPLEMENT_TEMP_DESIGN Server, clients 6.1