SQL Functions and Statements

This section contains information on updates to SQL Functions and Statements for Vertica Analytic Database 8.1.x:

MERGE Support for Update and Insert Filters

Each WHEN MATCHED and WHEN NOT MATCHED clause in a MERGE statement can now optionally specify an update filter and insert filter, respectively:

WHEN MATCHED AND update-filter THEN UPDATE ...
WHEN NOT MATCHED AND insert-filter THEN INSERT ...

Each filter can specify multiple conditions. For details on using these filters, see Update and Insert Filters in the Administrator's Guide.

Adding New Columns to Existing Projections

Previously, when you added a new column to a table using ALTER TABLE ADD COLUMN, existing projections (non-superprojections) did not include the new column. If you wanted to include the new column in your projection, you needed to drop and recreate it. Vertica has added the option PROJECTIONS to ALTER TABLE ADD COLUMN. When you add a new column to a table, use the PROJECTIONS option to simultaneously add the column to one or more existing projections.

For the statement syntax for adding columns to tables, see ALTER TABLE. For an example of adding a new column to an existing projection, see Adding Table Columns.

Function to Verify Kerberos Configuration

You can use the KERBEROS_CONFIG_CHECK metafunction to verify your Kerberos configuration. The function tests each element of Kerberos configuration and reports specific errors if it finds any.

More Details

For more information see the SQL Reference Manual.