• Support for INSERT, DELETE, UPDATE, MERGE, ADD COLUMN, and DROP COLUMN

• Full and incremental backup and restore through the ckpdb and rollforwarddb operations

• Master node failover

• YARN support

• Statements MODIFY…TO COMBINE and MODIFY…TO RECONSTRUCT replace the COMBINE and REWRITE forms of the CALL VECTORWISE statement, which are deprecated.

• CALL VECTORWISE is now a privileged operation that requires the user to have DB_ADMIN database privileges. This feature has upgrade considerations.

• SET INSERTMODE statement lets you control whether inserts go through the PDT (memory) or directly to disk.

• CREATE STATISTICS and DROP STATISTICS statements. Also, new options on COPY FROM and vwload that create statistics on the table just loaded.

• INTERSECT and EXCEPT set operators for use in the same context as UNION

• CREATE TABLE IF NOT EXISTS statement creates the table if it does not exist and returns without error if the table exists.

• Configuration option [engine] enable_reuse_disk_spilling=true enables spilling to disk for reused query plan parts.