SQL Functions and Statements

RELOAD_ADMINTOOLS_CONF

The RELOAD_ADMINTOOLS_CONF meta-function updates admintools.conf on all UP nodes using the current catalog information. Use this function to confirm that the server updated admintools.conf for a node that recently came up.

Exporting Table Access Policies

The SQL scripts generated by Vertica meta-functions EXPORT_TABLES, EXPORT_OBJECTS, and EXPORT_CATALOG now include CREATE ACCESS POLICY statements, as applicable.

Node-Level Support for CLEAR_DATA_DEPOT

The CLEAR_DATA_DEPOT meta-function can now clear depot data from a single node. Previously, you could remove depot data from a subcluster or from the entire database cluster.

ARRAY_CAT Support for Complex Types

The ARRAY_CAT function now supports elements of complex types. Both input arrays must have the same element type; for example, ROW elements must have the same fields.

INFER_EXTERNAL_TABLE_DDL

The INFER_EXTERNAL_TABLE_DDL meta-function now supports both Parquet and ORC formats. The new syntax is updated to include a format parameter. The earlier syntax has been deprecated.

TO_JSON Supports Sets

The TO_JSON function now supports SET arguments. You no longer need to cast them to arrays.

EXPLODE Supports Complex Arrays and Sets

The EXPLODE function now supports arrays of complex types, multi-dimensional arrays, and sets.