Vertica Analytics Platform Version 9.2.x Documentation

SQL Functions and Statements

Zstandard Compression Support

CREATE TABLE, CREATE PROJECTION, and COPY now support Zstandard compression. For details, see Encoding Types.

ALTER TABLE Enhancements

ALTER TABLE supports two new options:

  • IF NOT EXISTS can qualify ALTER TABLE…ADD COLUMN:
    ALTER TABLE table-name ADD COLUMN IF NOT EXISTS column-name data-type
  • IF EXISTS can qualify ALTER TABLE…DROP COLUMN:
  • ALTER TABLE table-name DROP COLUMN IF EXISTS column-name

CREATE SEQUENCE Enhancements

CREATE SEQUENCE now supports the option IF NOT EXISTS.

New Flex Table Function Parameters

The following flex table functions have new parameters:

Function New Parameters

MAPITEMS

  • max_key_length
  • max_value_length
MAPKEYS:

max_key_length

MAPKEYSINFO max_key_length
MAPVALUES: max_value_length