This feature adds the ability to automatically rotate the X100 error log file if its size surpasses a specified limit or if a specified time interval has passed. It also adds the option of automatically compressing the rotated log file to .gz format.

See Automatic Log Rotation in X100 in the System Administrator Guide for more information on this feature.

The UDF engine startup is now part of the ingstart utility, which ensures predictable behavior and can surface configuration issues quickly and efficiently. This change enables the Configure-By-Form (CBF) utility to control the UDF engine startup and enables the ingstatus utility to view the UDF engine status.

See cbf Command--Start Configuration-By-Forms in this guide for more information.

This feature enables database procedures to process despite runtime errors by identifying exceptions. Conditions can be set to identify an error condition such as an SQLSTATE code, a DBMSERROR code, or a predefined exception name. The condition can also be a user-declared condition raised using the SIGNAL and RESIGNAL statements.

See Exception Handling in Database Procedures in the SQL Language Guide.

This feature enables pattern-matching on more complex patterns by providing the standard conforming SIMILAR TO function that works on SQL standard regular expressions.

See Pattern-matching Predicates in the SQL Language Guide.

In a multi-user setting, UDF management can allow a common pool of UDFs created by the Database Administrator (DBA) to be accessible to all users of the database.

This feature enables configuring query results to spill to disk when the query result memory is low.

See Query Result Caching in the System Administrator Guide for more information.

This feature adds support for different URL schemes, such as gs, adl, adls, abfs, abfss, s3a, s3n, http, https, hdfs, maprfs, and viewfs, to COPY VWLOAD (SQL load), vwload (command line load in cluster and non-cluster mode) and INSERT INTO EXTERNAL CSV (SQL export) by enabling and deploying Apache Hadoop file system drivers for single node (non-MPP) Vector.

See Methods for Loading Data in this guide for more information.

This feature introduces a smart MinMax index (set by AUTO_TUNE to the WITH Clause), which enables Vector to dynamically choose a current subset of MinMax index columns based on collected statistics. Vector drops unnecessary index columns and adds necessary columns to the MinMax index according to their predicted selectivity, with respect to upcoming filter queries, based on the set of filter queries seen so far. This feature reduces memory utilization, while attempting to maintain run time performance, by eliminating index columns that are rarely queried or do not have a high (predicted) selectivity.

See WITH Clause in the SQL Language Guide for more information.

This feature enables shadow instances, that are kept in close sync with the main instance, to be ready in the case of an outage to the main instance so the shadow instance can take over.

See Vector Instance in the Vector Connectivity Guide for more information.