Deprecated and Retired Functionality
This section describes the two phases Vertica follows to retire Vertica functionality:
- 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 (see Deprecated in This Release, below). When users access this functionality, it may return informational messages about its pending removal.
- Retired: 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
The following Vertica functionality was deprecated in this release. This functionality will be retired in a future Vertica version:
DISABLE_ELASTIC_CLUSTER(): Future releases will no longer support disabling elastic cluster scaling in a database.- Support for Windows Server 2012. Vertica continues to support Windows 2012 R2 and 2016.
partition_keycolumn in system tablesSTRATAandSTRATA_STRUCTURESeof_timeoutparameter of the Kafka functionKafkaSource
Removed in This Release
| No longer supported: | Notes |
|---|---|
| Prejoin projections, and projections that use range segmentation | In release 9.2, Vertica will remove support for existing projections that include either or both. |
vbr --setupconfig command |
Instead, create vbr configuration files by copying and editing existing files or the samples shipped with Vertica. |
| S3 UDSource in the AWS Library | Instead, use COPY with an S3 path. |
History
The following functionality has been deprecated or removed as indicated:
| Functionality | Component | Deprecated in: | Removed in: |
|---|---|---|---|
DISABLE_ELASTIC_CLUSTER()
|
Server | 9.1.1 | |
eof_timeout parameter of Kafka function KafkaSource |
Server | 9.1.1 | |
| Windows Server 2012 | Server | 9.1.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 parameter |
Server | 9.0 | |
Machine Learning for Predictive Analytics package parameter key_columns for data preparation functions. |
Server | 9.0 | 9.0.1 |
Vertica meta-function DROP_PARTITION (superseded by DROP_PARTITIONS) |
Server | 9.0 | |
Machine Learning for Predictive Analytics package parameter owner. |
Server | 8.1.1 | 9.0 |
vbr --setupconfig command |
Server | 8.1 | 9.1.1 |
RENAME_MODEL()
|
Server | 8.1 | 8.1.1 |
DELETE_MODEL()
|
Server | 8.1 | 8.1.1 |
Backup and restore --setupconfig command |
Server | 8.1 | 9.1.1 |
| Ability to create a projection in a schema different from its anchor table | Server | 8.0.1 | 8.1.1 |
SET_RECOVER_BY_TABLE(). Do not disable recovery by table.
|
Server | 8.0.1 | |
PreExcavatorReplicatedProjection()
|
Server | 8.0.1 | |
| HDFS Connector | Server | 8.0 | 9.0 |
| Prejoin projections | Server | 8.0 | 9.1.1* |
Administration Tools option --compat21 |
Server | 7.2.1 | |
 ext3 file system
SUSE Linux Enterprise Server (SLES) 11.0 Service Pack 3 (SP3) continues to support the
ext3 file system.
|
Server | 7.2 | 8.0 |
| Projection buddies with inconsistent sort order | Server | 7.2 | 9.1 |
| 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()
|
Server | 7.1 | |
bwlimit
|
Server | 7.1 | 9.0 |
EXECUTION_ENGINE_PROFILES counters: file handles, memory allocated, and memory reserved |
Server | 7.0 | |
MERGE_PARTITIONS()
|
Server | 7.0 | 9.0 |
|
krb5 client authentication method
Use the Kerberos gss method for client authentication, instead of krb5. See Configuring Kerberos Authentication.
|
All clients | 7.0 | |
|
|
Server | 7.0 | 8.1.1 |
| range-segmentation-clause | Server | 6.1.1 | 9.1.1* |
scope parameter of CLEAR_PROFILING() |
Server | 6.1 | |
IMPLEMENT_TEMP_DESIGN()
|
Server, clients | 6.1 |
* As of version 9.1.1, you can no longer create pre-join and range segmentation projections. Support for existing projections is scheduled for removal in version 9.2.
