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.